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 ..! ... View more