Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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.