Te problem improved upgrading the driver version. It still persists, but is rarer. ... View more

@mareb you could use a code/text sharing service to store the code and share the link here ... View more

Could help to explain what's the meaning of first 2 sentence?  Set Hive.....   What would happen if we don't have 2 sentences? How would that impact our query?   Thanks.         ... View more

yes, It exists in the hive CDH source. org.apache.hadoop.hive.ql.udf package is part of hive-exec.jar. PFB [hive@node3 lib]$ /usr/jdk64/jdk1.8.0_112/bin/jar -tvf hive-exec.jar | grep "org.apache.hadoop.hive.ql.udf" | wc -l 660 ... View more

@luigui @MBohlmann  I believe you are hitting https://issues.apache.org/jira/browse/HIVE-22260 ... View more

@enirys  You could refer to the following doc for Hive tuning: https://docs.cloudera.com/HDPDocuments/HDP2/HDP-2.6.5/bk_hive-performance-tuning/content/ch_connectivity-admission-control.html#guidelines-hiveserver2-heaps   If you have other services running on the same HS2 node as well, you might want to reduce Hive heap size  or move a service to a different node. Are you expecting too many connections as explained in the above doc, else you might want to bring down HS2 heap size? If you do not see too many connections, but notice high heap usage, you might want to take a heap dump as @asish mentioned, and see if there is memory leak.   Load balancing across HS2 could take place based on how you are accessing Hive. You could use zooKeeper based connection string. ... View more

yes that was indeed a problem 🙂   I was about to comment on that ... View more