question Re: How to upload a CSV file to HIVE? in Archives of Support Questions (Read Only)

How to upload a CSV file to HIVE?

mmay14 — Fri, 16 Sep 2022 12:42:48 GMT

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

Re: How to upload a CSV file to HIVE?

jsensharma — Sun, 18 Aug 2019 09:03:01 GMT

@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.

Re: How to upload a CSV file to HIVE?

mmay14 — Sun, 07 Jan 2018 16:36:14 GMT

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.