[IMPALA-8455] GET_TABLE failed with InvalidStorageDescriptorException

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: Impala 3.2.0
• Fix Version/s: Impala 3.3.0
• Component/s: Catalog
• Epic Color: ghx-label-7
• Assignee: Bharath Vissapragada
• Reporter: Xiaomin Zhang
• Created: 25/Apr/19 09:25
• Updated: 18/Jun/19 23:02
• Resolved: 18/Jun/19 23:02

Description

When ImpalaD is enabled local catalog mode, GET_TABLE call returns error when some table is using unsupported serde. 

To reproduce:

1) Enable local catalog mode:

--use_local_catalog=true
--catalog_topic_mode=minimal
--invalidate_tables_timeout_s=60

2) Create an CSV table:

create table sample(id int)
row format serde 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
stored as textfile;

3) In HUE, it shows below error while loading the tables:

LocalCatalogException: Could not load table default.sample from metastore CAUSED BY: TException: TGetPartialCatalogObjectResponse(status:TStatus(status_code:GENERAL, error_msgs:[TableLoadingException: Failed to load metadata for table: default.sample CAUSED BY: InvalidStorageDescriptorException: Impala does not support tables of this type. REASON: SerDe library 'org.apache.hadoop.hive.serde2.OpenCSVSerde' is not supported.]), lookup_status:OK) 

4) "SHOW TABLES" is not affected and runs fine.