Support Questions

Find answers, ask questions, and share your expertise

Impala catalog metadata

avatar
Explorer

Impala gives me this error when I Insert a new record on a table [ERROR: AnalysisException: Failed to load metadata for table: 'X'
CAUSED BY: TableLoadingException: Failed to load metadata for table: X status_code: GENERAL, error_msgs:[TableLoadingException: The following columns have types incompatible with the existing columns in their respective positions]

 

 

1 REPLY 1

avatar
Expert Contributor

@MoatazNader Can you set false for below property and try to rerun the query.

 

CM>Impala> Configuration>Catalog Server Hive Advanced Configuration Snippet (Safety Valve)

set hive.metastore.disallow.incompatible.col.type.changes to false

and restarted the Impala service.