Skip to content
Advertisement

how to split one row of result in to two rows in impala

Below is the requirement and it needs to converted in SQL.

I will receive only one record from source but I need to verify below condition and split it into two rows in impala.

Expected values from source for final_columns is ('IC', 'OG', 'BK').

I need to check the below condition only if I received value 'BK' in final_columns.

Advertisement

Answer

Could you please try this sql? I created dummy inline view to duplicate the data.

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