About pj1111

pj1111 · ‎02-19-2020

Hi Folks , I am facing one issue , i have tried all the methods but its not working can you please help on this . one column have data like below its there row wise (Original column) IT Strategy& Architecture BDC India [MITX 999],Corporate & IC Solution Delivery [SVII], Operations Solution Delivery [SVIA], Mainframe Service [MLEM],Strategy & Architecture [MLEL] the above 3 rows i need to split into two columns like below 1st column IT Strategy& Architecture BDC India,Corporate & IC Solution Delivery,Operations Solution Delivery,Mainframe Service,Strategy & Architecture 2nd columns [MITX 999],[SVII],[SVIA],[MLEM], [MLEL] please help , working new for impala data lake . Thank You ..!

pj1111 · ‎02-18-2020

previous i am working oracle technology and now working in impala big data . In oracle i have implements some logic using following functions regexp_substr() and level . but in impala not supported these two functions . can you please suggest me these two related functions in impala data lake . thank you ..!

pj1111 · ‎02-04-2020

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

Online	Offline
Last Visited	‎03-18-2020 10:42 AM

Date Registered	‎02-04-2020 12:08 PM
Last Visited	‎03-18-2020 10:42 AM
Total Messages Posted	4

technical problem

Need help for not supported function impala

technical problem