Hi, In NameNode when I run the query via odbc script (php/perl or python), I can fetchAll results (9.2M) in a variable in about 30 seconds, but when I tried with the same script/query on another remote 2 servers, the execution time was in first server 28 min and in second 17 min. To exclude the assuming that it's a network speed issue, I fetch the result on a file and then I copied it with scp command to the first remote server, and it finished in ~40 seconds. What I observe in Query info in CM that there is a big different between the *Threads: Network Send Wait Time* values in the 3 queries : in NN query: 9.40s in 1st remote server: 16.7m in 2nd remote server: 26.8m And also I try an java script with Impala JDBC, but the results in NN are already not stimulate to continue. But so far I cann't find where is the problem and how can I resolve it. NB: I'm working on CDH 5.12.0/Impala 2.9.0, I installed Impala ODBC 2.5.37.1014.   Hope you can respode to me ASAP, because this issue is a realy an obstacle of using a cluster that we made a several months to make it. Thanks in advance. ... View more

Hi, I have a partitionned tables that have more than 50k partitions, it work a good except the Hive Metastore operations, like DROP and ALTER ... RENAME, I face this error message: Query: drop table cars ERROR: ImpalaRuntimeException: Error making 'dropTable' RPC to Hive Metastore: CAUSED BY: MetaException: Timeout when executing method: drop_table_with_environment_context; 600003ms exceeds 600000ms I don't now if it's, a memory problem, or it's normal and I should adjust the timeout value.. ? if yes, which one ? Thanks to help me ASAP. ... View more