Set variable in hive query

[Ravisankar Mani]

Hi everyone,

I assign values for  set variable. Please refer following query

SET Row_Number_0 = 0;
SELECT
            criticid AS criticid,
            sum(rating) as rating,
              ${hiveconf:Row_Number_0}= ${hiveconf:Row_Number_0} + 1  AS
R_N_1
 FROM
GROUP BY recommend_ratings2.criticid
ORDER BY  criticid ASC;

the assign variable(3 or select values) only returns true or false

But the same query returns 1,2,3.........  (row number) in mysql. Could you
please help exact query to return assign values?


Regards,

Ravisankar M R