@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.