@Mayank Bhatt @sundeep dande I faced the same issue too. When I changed the engine from tez to mr(mapreduce) it worked! ... View more

@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