0

How do I create an external table from a collection of compressed parquet files (e.g., gz.parquet) in Hive/Impala?

PTDS
  • 217
  • 3
  • 8

1 Answers1

1

If the folder has _metadata file and is not partitioned then you can use this SQL command:-

 CREATE EXTERNAL TABLE tablename LIKE PARQUET 'hdfs:///_metadata' STORED AS PARQUET LOCATION 'hdfs://folder_location_of_parquet'; .
morfious902002
  • 916
  • 1
  • 11
  • 29