Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Cannot import CSV into table in Hive

Cannot import CSV into table in Hive

New Contributor

I try to import CSV into the new table in the database, I use the "+" mark on table side to import file instead of hive query editor because there are 20+ columns, but it shows:

 

AnalysisException: Syntax error in line 25: ...on` string ) ROW FORMAT SERDE 'org.apache.hadoop.hiv... ^ Encountered: IDENTIFIER Expected: DELIMITED CAUSED BY: Exception: Syntax error

 

I remove all commas in CSV and choose the right path for the database and no spaces for column names. I am really confused!

 

Don't have an account?
Coming from Hortonworks? Activate your account here