I am creating an app with KPI's. Iam using a HIVE database. I have three fields in my table Year, Month , Date. I want to find the latest partition daily from these three fields.(year,month,date).
I want to find the max of all the three fields and write a SQL query to obtain the result. Please do help.
I have tried like,
Load
..
..
SQL Select * from HIVE.''.'';
Temp:
load max(year) as maxyear,
max(month) as maxmonth,
max(date) as maxdate
resident table;
SQL select * from HIVE.''.'' where....
I am not sure how to obtain the result using WHERE clause.
