this is my data in csv file .in this file company_name are seperated by , . how to company_data in single column?
query:
Hive>create table us_employee(first_name varchar(50),last_name varchar(50),company_name sting ,address string,city string,country string,state varchar(30),zip bigint,phone1 string,phone2 string,email string,web string) row format delimited fields terminated by ‘ , ’
location ‘hdfs://quickstart.cloudera:8020/user/cloudera/mydata/employee’ tblproperties(‘skip.header.line.count’=’1’);

after its getting only starting name

how to two names in single column?