Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

datalakeyu
Valued Contributor

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
datalakeyu
Valued Contributor

Re: How to select data from Apache hive table?

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

1 Reply
datalakeyu
Valued Contributor

Re: How to select data from Apache hive table?

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

Community Browser