Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikuser22
Creator II
Creator II

QVD to SQL transformation

HI

I am new to Qlik sense. I would like to know if there is any documentation available for my requirement so I can learn and do it. 

I have 3 tables. All the tables are loaded and stored using QVD. Now I want to change everything to fetch the data from HIVE database and find the partition of the latest data added(Like the last data added according to the date/month) on daily basis and update. 

SO basically instead of getting it from QVD's , I want to change the script to SQL and find latest.  

Sample

LOAD 

..

..

..

,

FileBaseName() as Filename

 

from [$(vFile)] (ooxml, embedded labels, table is [All Records])
where not isnull([..........]) ;
trace 'Table is loaded from the new file';

 

This should be changed to Select * from HIVE...........

 

Do help. 

 

 

Labels (2)
1 Reply
JordyWegman
Partner - Master
Partner - Master

Hi Abirami,

Have you tried just loading from HIVE? Can you show what syntax Qlik is giving you?

Jordy

Climber

Work smarter, not harder