[IMPALA-650] AnalysisException For External Parquet Table with no Data files

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Duplicate
• Affects Version/s: Impala 1.1.1
• Fix Version/s: Impala 1.2.1
• Labels: imapala parquet
• Assignee: Lenni Kuff
• Reporter: David E. Wheeler
• Created: 01/Nov/13 22:04
• Updated: 20/Dec/15 00:05
• Resolved: 04/Nov/13 15:52

Description

If I create an external parquet table pointing to an empty directory, it does not work:

[example.com:21000] > create external table foo (id integer) STORED AS PARQUETFILE LOCATION '/empty/directory';
Query: create external table foo (id integer) STORED AS PARQUETFILE LOCATION '/empty/directory'
[example.com:21000] > select * from foo;
ERROR: AnalysisException: Failed to load metadata for table: default.foo
CAUSED BY: TableLoadingException: Failed to load metadata for table: foo
CAUSED BY: MetaException: org.apache.hadoop.hive.serde2.SerDeException SerDe parquet.hive.serde.ParquetHiveSerDe does not exist

I am not even able to drop the table at this point.

So, how does one create a new external Parquet table that one can then insert data into?