Hello,
I have a csv file that has columns which contains commas within a string
enclosed with a ". ex: column name:*'Issue' *value:*"Other (phone, health
club, etc)"*
*Question:* What should the data type of 'Issue' be? Or how should I format
the table (row format delimited terminated by) so that the comma in the
column (issue) is accounted for correctly
I had set it as below but this puts the words in the string (ex: *"Other
(phone, health club, etc)") * into separate columns
create table consumercomplaints (ComplaintID int,
Product string,
Subproduct string,
Issue string,
Subissue string,
State string,
ZIPcode int,
Submittedvia string,
Datereceived string,
Datesenttocompany string,
Company string,
Companyresponse string,
Timelyresponse string,
Consumerdisputed string
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
location '/user/hive/warehouse/mydb/consumer_complaints.csv';
Sample data -- Complaint ID,Product,Sub-product,Issue,Sub-issue,State,ZIP
code,Submitted via,Date received,Date sent to company,Company,Company
response,Timely response?,Consumer disputed? 943291,Debt collection,,Cont'd
attempts collect debt not owed,Debt is not
mine,MO,63123,Web,07/18/2014,07/18/2014,"Enhanced Recovery Company,
LLC",Closed with non-monetary relief,Yes, 943698,Bank account or
service,Checking account,Deposits and
withdrawals,,CA,93030,Web,07/18/2014,07/18/2014,U.S. Bancorp,In
progress,Yes, 943521,Debt collection,,Cont'd attempts collect debt not
owed,Debt is not mine,OH,44116,Web,07/18/2014,07/18/2014,"Vital Solutions,
Inc.",Closed with explanation,Yes, 943400,Debt collection,"Other (phone,
health club, etc.)",Communication tactics,Frequent or repeated
calls,MD,21133,Web,07/18/2014,07/18/2014,"The CBE Group, Inc.",Closed with
explanation,Yes,
Thanks,
Vidya
