How to upload a CSV file to HIVE?

[#1]

Hi

I have only just begun to learn HIVE. I am trying to upload a CSV file. However it does not look correct in Ambari view, please see screen shot attached. I cannot set up my columns as the data does not look to be separating correctly.

Have I missed a step or done something wrong? I have field delimiter set a ",".

pic8.jpg

[#2 · Accepted solution]

@Matt

In the Hive View if you click on the "Settings" button just at the right side of "File Type" field then you should see more options to select the delimiter.

.

.

You will need to check your file to findout if it has any special characters? Or if the Data Delimiter is choosen correctly or not?

Also please check different File Editiors like "vi" editor or "vim" or some other tools to see if your File contains any hidden character.

[#3]

thank you. I was following this procedure however there was an error in my csv file. For some reason I needed to resave it again as csv.