Cloudera Community
yashwanth
user rank
New Contributor

Re: how to load double quotes data of fields in hi...

by New Contributor in Support Questions
‎03-13-2024 08:53 AM
1 Kudo
‎03-13-2024 08:53 AM
1 Kudo
Hi Smruti, Thanks for your reply, I want the property in a way that ',' within double quotes should not split and the fields which are not having ',' inside double quotes should be splitted.  ... View more

how to load double quotes data of fields in hive t...

by New Contributor in Support Questions
‎03-12-2024 10:57 AM
‎03-12-2024 10:57 AM
Can I know the working table property for splitting the records as shown below. Input field - 123,"456","INDIA","INDIA",789,"DELHI INDIA, PIN. North INDIA","101","NEW Delhi ","LOCATION" Expected hive output("|" indicates split) - 123 |  "456" |  "INDIA" |  "INDIA" |  789 |  "DELHI INDIA, PIN. North INDIA" |  "101" |  "NEW Delhi " |  "LOCATION"   ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎03-27-2024 06:24 AM
Community Statistics
Member Since ‎03-12-2024 10:48 AM
Last Visited ‎03-27-2024 06:24 AM
Posts 2
Kudos received 1