Skip to content
Advertisement

convert a single row into 2 rows on impala/hive

I have a huge table with millions of rows/IDs in the below format.

I need to convert this into the below format so that the values are in 2 rows as shown below.

Can you please help me with an impala/hive query to help with this? Thanks a lot.

Advertisement

Answer

I think a way would be this one:

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement