Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Abirami,
Have you tried just loading from HIVE? Can you show what syntax Qlik is giving you?
Jordy
Climber