How Do I Handle the Error Reported When the Schema of the Parquet Table Queried by Impala Is Inconsistent with the File Schema?

Question

The column sequence defined by Parquet table creation statement is inconsistent with that in the data file, resulting in an error during Impala query.

Answer

Add set PARQUET_FALLBACK_SCHEMA_RESOLUTION=name; before running the query.

To permanently apply the configuration, log in to FusionInsight Manager, choose Cluster > Services > Impala, and click Configurations and then All Configurations. In the tab, choose Impalad(Role) > Customization. Add the parameter -default_query_options to impalad.customized.configs and set its value to PARQUET_FALLBACK_SCHEMA_RESOLUTION=name. Save the configuration and restart the instance whose configuration expired.