Cloudera Community
Abdul_
user rank
New Contributor

Re: Hive - Line Termination in Quotes

by New Contributor in Support Questions
‎04-17-2023 11:07 PM
‎04-17-2023 11:07 PM
Hi @tj2007, It is not possible to modify the data. I have tried the "LazySimpleSerDe" but it didn't give the correct output (Mentioned below). ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde' with serdeproperties ( "separatorChar" = ",", "quoteChar" = '\""') STORED AS TEXTFILE "IM43163","SOUTH,OFC","10-Jan-23" ? ? "IM41763","John: ? ? comment added","12-Jan-23" ? ?   However, I need output like this. IM43163 SOUTH,OFC 10-Jan-23 IM41763 John:comment added 12-Jan-23 Please also note that the input file is a CSV file which I am successfully able to open it in Excel. Your support will be highly appreciated. ... View more

Hive - Line Termination in Quotes

by New Contributor in Support Questions
‎04-17-2023 03:03 AM
‎04-17-2023 03:03 AM
My data set is as below. "IM43163","SOUTH,OFC","10-Jan-23" "IM41763","John: comment added","12-Jan-23" CREATE EXTERNAL TABLE database.table1( `col_1` string, `col_2` string, `col_3` string)ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde' WITH SERDEPROPERTIES ( "separatorChar"="," , "quoteChar"="\"") Since the record is splitted amont two rows therefore it is not loading properly and gives null values. The output I am getting is mentioned below. IM43163 SOUTH,OFC 10-Jan-23 IM41763 ? ? ? ? ? ... View more
Contact Me
Online
Offline
Last Visited
‎06-26-2023 08:06 AM
Community Statistics
Member Since ‎04-17-2023 02:26 AM
Last Visited ‎06-26-2023 08:06 AM
Posts 2