one row to more rows

if we have data like the following:

and we want to get a table like the following:

The way to do it is using “Lateral view” and “explode()”. Here is the example:

hive> select name, single_alias from test lateral view explode(split(alias, ' ')) test_alias as single_alias;

The explode() is used for let array data into a single row data, like explode([1, 2, 3]) will be

• 1
• 2
• 3