Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have to obtain latest data using sql query. I have loaded the data using HIVE connector. It has three field year,month,date. I want to find max(year),max(month),max(date) and output the latest partition data.
Example:
Table1:
Load
..
..
..
year,
month,
date;
Temp:
Load max(year) as maxyear,
max(month) as maxmonth,
max(date) as maxdate;
resident table1;
drop table table1;
SQL select * from HIVE.tablename;
I want to get the latest partition every time. I am not sure how to use the SQL statement and not sure if I am doing the right thing in load statement. I am very much new to qliksense.
Thanks in advance.
I have also modified the script like,
Table1:
Load
..
..
..
year,
month,
date;
SQL SELECT * FROM HIVE.``.`` ;
Temp:
Load max(year) as maxyear,
max(month) as maxmonth,
max(date) as maxdate;
resident table1;
Let Maxyear = peek('Maxyear',-1);
Let Maxmonth = peek('Maxmonth',-1);
Let Maxday = peek('Maxday',-1);
SQL SELECT * FROM HIVE.``.``
where ( year > $(Maxyear) AND month > $(Maxmonth) AND day > $(Maxday) );
I don't know if i am right. I get an error. Please help.