Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to select data from Apache hive table?

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!

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Finally we find the above script is right, while the problem comes from the Hive file.

View solution in original post

1 Reply
Anonymous
Not applicable
Author

Finally we find the above script is right, while the problem comes from the Hive file.