1 Reply Latest reply: Oct 14, 2016 1:33 PM by Haikuo Yu RSS

    How to select data from Apache hive table?

    Haikuo Yu

      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!