Member since
01-03-2019
5
Posts
0
Kudos Received
0
Solutions
06-25-2019
01:18 PM
@Mayank Bhatt @sundeep dande I faced the same issue too. When I changed the engine from tez to mr(mapreduce) it worked!
... View more
01-05-2019
11:28 PM
1 Kudo
@PP Include over() clause in your select query . Try with below query: select row_number() over(),* from testDB.testTable; Example: select row_number() over() as rn,* from ( select stack(2,1,"foo",2,"bar") as (id,name) )t;
+-----+-------+---------+--+
| rn | t.id | t.name |
+-----+-------+---------+--+
| 1 | 1 | foo |
| 2 | 2 | bar |
+-----+-------+---------+--+ "rn" is the row number column that we have added in the above result.
... View more