Hi Tom, which "while" loop you refer to? ... View more

Do you have workflow that updates those files outside of Impala? If yes, you need to refresh or invalidate metadata on those table so that impala can see the latest version. ... View more

What's the error you are getting? Have you tried to add ` around the day, since it is reserved as a UDF function? Like below: update anp_catdidai1_working.dim_bsp_date set `day`=day(date_num); ... View more

Kudu is different from HDFS. The data you inserted into Impala KUDU table stored in Kudu side. You can check Kudu's table via Kudu's web UI or using Kudu commands: https://kudu.apache.org/docs/command_line_tools_reference.html And Kudu user guide can be found here: https://www.cloudera.com/documentation/enterprise/latest/PDF/cloudera-kudu.pdf I am not a kudu guy, so can't share more info, but hopefully you can get what you are after from the links. But the operations you mentioned like add or drop partitions, you should be able to do it via Impala, that's the purpose of impala and kudu integration. Cheers ... View more

LATERAL VIEW is not available in Impala yet, see below link: https://www.cloudera.com/documentation/enterprise/latest/topics/impala_langref_unsupported.html#langref_hiveql_unsupported Currently only Hive supports it. ... View more

idle_session_timeout should kill the zombie sessions from the impala server side. How did you check those zombie connections? How long is your session timeout? ... View more

Hi, Can you please confirm which version of CDH are you using? I can test and confirm the same from my lab. Thanks ... View more

SELECT * does not trigger MR job, while SELECT struct_col.field will, which means the jar is probably available on HS2 host, but not available on the NM hosts. As Naveen mentioned, the class is in hive-hcatalog-xxx.jar, so you can put this jar into Hive AUX directory on HS2 host and then it should be distributed to the cluster while query is running in MR mode. Regarding JsonSerDe in C6.1, Naveen is right and it has been confirmed. ... View more