@hores, You are right! Looks like latest Impala in CDH6.x supports column level stats: https://www.cloudera.com/documentation/enterprise/latest/topics/impala_compute_stats.html COMPUTE STATS [db_name.]table_name [ ( column_list ) ] [TABLESAMPLE SYSTEM(percentage) [REPEATABLE(seed)]] column_list ::= column_name [ , column_name, ... ] What version are you using? Cheers Eric ... View more

@Amn_468 Having lots of connections to impala daemon might overload it and cause issues, this is the reason for the alert. Now the question is will your impala daemon handle those connections. If yes, you can increase the max client connections, but if no, we might need to find out why there are many connections that makes you about to go to the limit. Are there any connections that are supposed to be closed but still open? You should check the resources being used on the host to determine if impala is really under pressure or not and decide your action. Cheers Eric ... View more

@LeonanCarvalho, The error looks like that AM was not able to reach back to HS2 for some reason. Have you tried to ping HS2 from the AM host for this particular job? If you re-run, when AM on another NM, do you get the same error all the time? Cheers Eric ... View more

You can't specify columns as Impala will collect all, but you can do it at partition level. ... View more

Lots of Hadoop components are using ZK to store information. One example I have seen is that when someone tries to query a table in Hive that has many many partitions, Hive will try to lock those partitions by storing this locking info in ZK. So depends on how many partitions, ZK will increase its usage. However, again, many things can happen, you need to capture what was happening in your cluster when issue occurred and do proper analysis. Cheers Eric ... View more

Looks like it is Oozie server log? Is it only affecting Oozie Server? What about other services? Can you share oozie-site.xml file for review? Cheers Eric ... View more

For number 2, ANY changes outside of Impala, you will need INVALIDATE METADATA, or if new data added, then REFRESH will do. Work is underway to improve it: https://issues.apache.org/jira/browse/IMPALA-3124 Cheers Eric ... View more

Hi Nanda, Are you using Cloudera Manager? If yes, can you go to CM > Hue > Instances > Hue Server > Processes, and then check the hbase-conf/hbase-site.xml and hive-conf/hive-site.xml files and confirm if ZK configurations are set properly there? Are all Hue instances having the same issue? Thanks Eric ... View more

Hi @Harish19, There is SSL Options button somewhere in the ODBC driver configuration window, please click through and confirm if you have SSL enabled on the client side. Cheers Eric ... View more