question Re: Incompatible parquet Schema on Impala but queries work fine in Hive in Support Questions

Incompatible parquet Schema on Impala but queries work fine in Hive

Muskan — Tue, 10 Jan 2023 18:11:58 GMT

Hello ,

I am facing issues while executing some queries , I am getting below error for time being and the issue is being resolved autoamtically .

I checked the files but there is no schema mismatch .

Can you please suggest me how i can fix the issue.

ChethanYM — Mon, 04 Mar 2024 13:33:24 GMT

@Muskan can you set this parameter before running the query and see if this helps?

set PARQUET_FALLBACK_SCHEMA_RESOLUTION=1;

Regards,

Chethan YM

Muskan — Tue, 05 Mar 2024 14:01:46 GMT

It works

But we can set as default property in our cloudera manager for impala

ChethanYM — Tue, 19 Mar 2024 16:23:57 GMT

You can set it in CM Impala advance configs ->

Impala Daemon Command Line Argument Advanced Configuration Snippet (Safety Valve)

Regards,

Chethan YM

Muskan — Tue, 19 Mar 2024 17:33:43 GMT

Thanks