import cvs to hive,

[ronnie]

Dear all,

I have created a table in hive with a few columns and stored as textfile.

And I have loaded the csv file to the table by using load data local inpath command to put the csv file to the hive table created above, but all the data imported to 1 column only, the rest of the columns are empty, I open the csv file in notepad, excel, seems like everything is in order, I have tried --hive-drop-delims and --fields-terminated-by '\t' in the load data command, the result is still the same.

Has anyone tried this before?

[Rishabh Chandra]

I have imported sql db data to hdfs in csv format using delimited by, then further imported to hive. Can u please post the complete command you used

[yong]

I use load data inpath command, but there are too much works to clean the data, I have changed to sqoop.

--
hadoop-skills.com
---
You received this message because you are subscribed to a topic in the Google Groups "Hadoop Learners from Hadoop-skills.com" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/hadoop-learner-tutorial-training-community/-MaWHDo6Pec/unsubscribe.
To unsubscribe from this group and all its topics, send an email to hadoop-learner-tutorial-tra...@googlegroups.com.
Visit this group at https://groups.google.com/group/hadoop-learner-tutorial-training-community.
To view this discussion on the web, visit https://groups.google.com/d/msgid/hadoop-learner-tutorial-training-community/74fe409b-d688-4c5f-9ae5-fed72cc72080%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Rishabh Chandra]

I too used sqoop command for data transfer. I will provide exact command if in case you need to refer