Re: Hive on Tez vs Impala

2019-04-16 Thread Edward Capriolo
I have changes jobs 3 times since tez was introduced. It is a true waste of compute resources and time that it was never patched in. So I either have to waste my time patching it in, waste my time running a side deployment, or not installing it and waste money having queries run longer on mr/spark

Hive metastore service

2019-04-16 Thread Odon Copon
Hi, would be possible to add authentication to the Thrift Hive metastore service? like user and password? I cannot find any documentation on how to protect this endpoint. Thanks.

Hive/ODBC, Tableau Server, and Kerberos auth

2019-04-16 Thread Mithun RK
Hello, chaps. I have a silly question regarding using Tableau Server with Hive/ODBC: As far as I know, the Hive ODBC (Simba) drivers provide no way to use a keytab to automatically kinit before attempting an HS2 connection. What is the recommended way for a user running Tableau Server to

RE: Hive/ODBC, Tableau Server, and Kerberos auth

2019-04-16 Thread Shawn Weeks
In my company the Windows Servers aren’t part of the same domain as the Hadoop Servers so we’ve been using Apache Knox to enable username/password auth to an Kerberos enabled Hive instance. This has been tested with the Hortonworks HDP 2.6.5 distribution of Hive and Tableau. Thanks Shawn

Re: Hive metastore service

2019-04-16 Thread Mich Talebzadeh
Try this Assuming that you are talking about Hive Thrift server beeline -u jdbc:hive2://rhes75:10099/default org.apache.hive.jdbc.HiveDriver *-n USERNAME -p PASSWORD* -i /home/hduser/dba/bin/add_jars.hql' HTH Dr Mich Talebzadeh LinkedIn *

HS2: Permission denied for my own table?

2019-04-16 Thread Kaidi Zhao
Hello! Did I miss anything here or it is an known issue? Hive 1.2.1, hadoop 2.7.x, kerberos, impersonation. Using hive client, create a hive db and hive table. I can select from this table correctly. In hdfs, change the table folder's permission to be 711. In hive client, I can still select from