[IMPALA-280] AnalysisException / TableLoadingException while trying to load table metadata for select query

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 0.7
• Fix Version/s: Impala 1.0
• Assignee: Henry Robinson
• Reporter: Hari Sekhon
• Created: 17/Apr/13 16:19
• Updated: 20/Dec/15 00:05
• Resolved: 03/May/13 07:04

Description

[localhost:21000] > select * from myTable;
Query: select * from myTable
ERROR: AnalysisException: Failed to load metadata for table: myTable
CAUSED BY: TableLoadingException: Failed to load metadata for table: myTable
CAUSED BY: IllegalArgumentException: null

Refreshing the metadata in impala-shell doesn't help.

hive> describe extended myTable;
OK
process_type string
status string
date_modified timestamp
table_id int

Detailed Table Information Table(tableName:myTable, dbName:default, owner:hadoop, createTime:1359496019, lastAccessTime:0, retention:0,
sd:StorageDescriptor(cols:[FieldSchema(name:process_type, type:string, comment:null), FieldSchema(name:status, type:string, comment:null),
FieldSchema(name:date_modified, type:timestamp, comment:null), FieldSchema(name:table_id, type:int, comment:null)],
location:hdfs://myNameNode:8020/user/hive/warehouse/myTable,
inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false,
numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format= , field.delim=

This looks like it's because of Hive SerDe which isn't supported at this time but I think this needs to not crash and instead give a more user friendly feedback error message.