Hi, NN log is under /var/log/hadoop-hdfs and HS2 under /var/log/hive by default. If you use Cloudera Manager, you can check in CM's configuration page for both of them. To determine why the directory was not removed: - check if the table is managed or external table, as external table will not delete HDFS files - check the HMS server log, also under /var/log/hive on the HMS host, to check if there is any permission errors, as it is HMS's responsibility to create and delete HDFS paths - please also confirm if you have Hive Impersonation enabled? (under CM > Hive > Configuration > "HiveServer2 Enable Impersonation" if you are using CM) Cheers Eric ... View more

Hi Zane, Please share the failed query PROFILE as attachment to the thread if possible. Also, what's the default MEMORY_LIMIT for Impala? Have you tried to increase this limit to see if it can help with the query? SET MEMORY_LIMIT=20g; Of course the value will depend on how much memory you have on your impala daemon host. Cheers Eric ... View more

Hi Vishal, Did you mean you just finished your certification exam or you got your certification? If you have your certification, then result should be sent to you already. If you just finished the exam, then expect the result in a couple of days max. Cheers Eric ... View more

Hi Tim, The doc says: This optimization does not apply if the queries contain any WHERE, GROUP BY, or HAVING clause. Do you know if it still applies if WHERE condition only has partition column as well? Cheers Eric ... View more

Glad it helps. Cheers Eric ... View more

What do you mean by "not so early", did you mean by "not so easy"? You should be able to test out to confirm if it is version issue. Cheers Eric ... View more

Hi, COORDINATOR_ONLY impala daemon will not perform data reads, rather it only coordinates query execution by distributing jobs to executors. Why do you need to enable this for COORDINATOR_ONLY impala daemons? Or is it that all your COORDINATOR_ONLY impala daemons fail with this error? Also, have you checked whether socket /var/run/hdfs-sockets/dn exist on that impala daemon host? Cheers Eric ... View more