Skip to content
Advertisement

How Create a hive external table with parquet format

I am trying to create an external table in hive with the following query in HDFS.

getting error

Error while compiling statement: FAILED: ParseException line 11:2 missing EOF at ‘LOCATION’ near ‘)’

What is the best way to create a HIVE external table with data stored in parquet format?

Advertisement

Answer

I am able to create table after removing property TBLPROPERTIES(“Parquet.compression”=”SNAPPY”)

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement