Need to identify a way to query HiveMetastore(Mysql) and gather output in following format DB_NAME, TABLE_NAME, PARTITION_COUNT We have about 1.2 Mil Partitions, There is a scope to delete unwanted partitions of older dates to save on query latency. ... View more

We use beeline to access hive. To connect we have two connection strings : hiveserver2 and hiveserver2-hive2(interactive). We want to block some users from accessing Interactive connection string and restrict them to hiveserver2. Hive-Interactive doesn't support user impersonation in HDP 2.6.5, Since there is no impersonation we can't restrict users in Ranger. Is there any way to do this in HDP 2.6.5? We don't want to upgrade the cluster. ... View more

Guys, We use beeline to access hive. To connect we have two connection strings : hiveserver2 and hiveserver2-hive2(interactive). We want to block some users from accessing Interactive connection string and restrict them to hiveserver2. Hive-Interactive doesn't support user impersonation in HDP 2.6.5, Since there is no impersonation we can't restrict users in Ranger. Is there any way to do this in HDP 2.6.5? We don't want to upgrade the cluster.   ... View more

Hi Support Team,   How to configure HAProxy  HiveServer2 LoadBalancer.   Can you please provide the configuration to implement HAProxy HiveServer2 LoadBalancer.   ... View more