Latest partition in sql query

qlikuser22 — Mon, 10 May 2021 08:57:43 GMT

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.

Please any help. thanks.

Re: Latest partition in sql query

qlikuser22 — Mon, 10 May 2021 13:14:37 GMT

Ány document on Incremental load using SQL query. ?? DO help

topic Latest partition in sql query in App Development

Latest partition in sql query

Re: Latest partition in sql query