hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ravisankar Mani <rrav...@gmail.com>
Subject Set variable in hive query
Date Fri, 05 Jun 2015 11:22:41 GMT
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

Mime
View raw message