Cloudera Community
Announcements
Celebrating as our community reaches 100,000 members! Thank you!
Manoj_hadoop
user rank
New Contributor

Re: how to read csv have comma in cell and new lin...

by New Contributor in Support Questions
‎01-24-2020 01:36 PM
‎01-24-2020 01:36 PM
Have you tried using openSerde In DDL? Create Table tablename(columns) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde';   Thanks, Manoj ... View more

Re: Hive- escaping field delimiter in column value

by New Contributor in Support Questions
‎01-24-2020 09:04 AM
‎01-24-2020 09:04 AM
Hi,   You can use (ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde') as well.   Create Table tablename (columns) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde';   Thanks, Manoj ... View more
Contact Me
Online
Offline
Last Visited
‎04-16-2024 07:05 PM
Community Statistics
Member Since ‎11-26-2019 12:24 PM
Last Visited ‎04-16-2024 07:05 PM
Posts 2