Support Questions
Find answers, ask questions, and share your expertise

Issue - Load data from CSV into HIVE table using HUE browser

New Contributor

I have an issue while importing a CSV file into Hue / Hive table with the data exported from Arcadia Operational Dev ( Download CSV option ).

For eg: A column ( say Owner ) that has got values as “Lastname,Firtsname” is not inserted into one single column as expected.

Expected :
----------------
Owner ( Column 1 )                            Description ( Column 2 )
Root,Joe                                                        This is a test data for Arcadia Labs

Actual :
---------------
Owner                                      Description
“Joe                                                            Root”

Please suggest if there is any fix for this.

3 REPLIES 3

Super Collaborator

Can you show the first couple lines of your file exactly as they appear in the file. You can open the CSV with a simple text editor of your choice and show the output in a comment here. 

 

When you are in the upload screen in Hue, note that under Extras section there are additional parameters that you might need to adjust to fit your file formatting.

Screen Shot 2020-12-16 at 10.51.13 PM.png

New Contributor

Attached the few lines of the csv file opened on Notepad ++

 

 


csv.png

Super Collaborator

Out-of-the-box Hue can't properly parse this format. There are some potential solutions in this thread: https://stackoverflow.com/questions/13628658/hive-load-csv-with-commas-in-quoted-fields

and it depends on what you are comfortable with: pre-processing the file to reformat the input or to use a different SerDe in Hive. 

 

Hope that helps,

Alex

; ;