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.

technical problem

Highlighted

technical problem

New Contributor

i am facing one technical issue in impala data lake

i have colum like below

Colum1
------
Mlbx123
ML
MLS
DSER12

i need to show data like below

Colum1     c1     C2      c3     c4         c5          c6
Mlbx123     m% ML% mlb% mlbx% mlbx1% mlbx12%
ML              m% null     null    null      null        null
MLS            m% ml%    null    null     null        null
DSER12     D% ds%    dse%  dser% dser1% null

 

kindly help on above logic how to write in impala DB 

 

Don't have an account?
Coming from Hortonworks? Activate your account here