hiv table data load using csv

0 votes

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?

May 21, 2022 in Big Data Hadoop by Srinivas
• 120 points

edited Mar 4 112 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP