I would like to get the latest recording from each group (myType is type column) from Apache hive table.
I use the following script at Qlik sense, but there is loading data error.
ROW_NUMBER() OVER (PARTITION BY myType ORDER BY myDate Desc) as LatestRow
Any suggestion is appreciated!
Finally we find the above script is right, while the problem comes from the Hive file.
Retrieving data ...