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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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