Generate a select query in a way that i can select 5 columns and assign a unique row.
How can i generate a select query in a way that i can select 5 columns and assign a unique row # For each of those rows. For example. I have a table my_hivetable as my_col1, my_col2, my_col3, my_col4.
The out i want from my query is: row_id, my_col1, my_col2, my_col3, my_col4
where row_id ranges from 1 till total # of rows.
Thanks in advance.