Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

I have to get the output of data given below using hive query:

Highlighted

I have to get the output of data given below using hive query:

New Contributor

Input Dataset:

sys_data_test.tran_xrefsys_data_test.skusys_data_test.qtysys_data_test.item_dessys_data_test.price
123-45-678956785blue shirt50
123-45-678974892hat70
123-45-678944891Jeans25


Output Required:

sys_data_test.tran_xrefsys_data_test.skusys_data_test.qtysys_data_test.item_dessys_data_test.price
123-45-678956781blue shirt10
123-45-6789
5678
1blue shirt
10
123-45-6789
5678
1blue shirt
10
123-45-6789
5678
1blue shirt
10
123-45-6789
5678
1blue shirt
10
123-45-678974891hat35
123-45-6789
7489
1hat
35
123-45-678944891Jeans25