Hi @yo_leo  As per document, it is mentioned that you should have at most 50 executors per coordinator. Which is the recommended maximum value. However this may vary as per the workload and complexity of the queries executed in Impala https://impala.apache.org/docs/build/asf-site-html/topics/impala_scaling_limits.html https://impala.apache.org/docs/build/asf-site-html/topics/impala_dedicated_coordinator.html   ... View more

Hi @Kropiciel  To connect ODBC driver with multiple HiveServers, you can configure High Availability for Hive using LB, refer below doc for same. The use the LB hostname and port in the connection string https://docs.cloudera.com/cdp-private-cloud-base/7.1.9/configuring-apache-hive/topics/hive-ha-loadbalancer.html Let us know if this helps.   As for the python connection use below code and check how it goes.   CODE: --------- from sqlalchemy import create_engine #Input Information host = hive_hostname port = 10000 schema = schema_name table = table_name   #Execution engine = create_engine(f'hive://{host}:{port}/{schema}') engine.execute(QUERY) ... View more

Hi @Kalpit  can you confirm the version of the hadoop cluster ... View more

Hi @SDPLearner Can you please check and confirm if it works using impala-shell or not. ... View more

Hi @echodot your table seems to be transactional, that is why it is not getting altered. Please create a non-tractional table and then perform your task ... View more

 @echodot    Try to execute the queries below and then run your query. # alter table ATABLE set tblproperties('impala.disable.recursive.listing'='true'); # refresh ATABLE; # check if your query works or not ... View more

Hi @echodot  As the source table is not in parquet format, try ing below command to create and load the data CREATE TABLE jmaster.hivetesttable AS SELECT * FROM JMASTER.ATABLE STORED AS PARQUET; ... View more