I want to use the MERGE statement on an external table that we have in our data warehouse. However, the transactional table property cannot be set on an external table and thus I am not able to run any MERGE queries. Is there any workaround for this ? ... View more

Hi, I wanted to enable SSL for Hive server2 on our multi node cluster. But we already have Kerberos authentication for hive. Is there any way to enable SSL with Kerberos. According to the document it says enable SSL only without Kerberos - https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.5/bk_security/content/ch_wire-hiveserver2.html Regards, Abhay ... View more

Hi, I am trying to create a table with a primary key in Hive, adding a primary key constraint was a feature which was introduced in Hive 2.1. I am using HDP 2.6.4 and have already enabled interactive query in hive config, which has enabled Hive 2.0 view. I am only using Hive 2.0 view for all the query tests. When I run the version check command in the remote shell box, I see that the hive version is still 1.2, which is the same version shown in the "Stacks and Versions" tab on the Ambari page. Is there any way to use the Hive 2.1 on HDP 2.6.4? , Hi, I tried using some of the features introduced in Hive 2.1 and could not use it with HDp 2.6.4. On checking the hive version in the remote shell box, I can see that the Hive version is still showing as 1.2. I have already enabled Interactive query and I am trying the new hive features in Hive 2.0 view, but it still fails to run the commands. Does anybody know a solution to change the Hive version on the HDP? ... View more