Hi @Abdul_ , It looks like the issue is that the data contains a newline character (\n) within a field value, which causes the record to be split into two rows, causing the problem. Can you modify the data to remove "\n" from the sample data? In that case, the create statement that you are using is correct. However, if data modification is impossible, you may use "LazySimpleSerDe". However, it may not be as performant as the OpenCSVSerde for large datasets. Hope this helps, Tarun Was your question answered? Make sure to mark the answer as the accepted solution. If you find a reply useful, say thanks by clicking on the thumbs-up button.
... View more
