Re: HS2: Permission denied for my own table?

2019-04-17 Thread Dan Horne
Are you using SQL Authorisation? If you create tables using the hive cli, you won't be able to select the table from a connection to the hive server. On Thu, 18 Apr 2019 at 04:34, Alan Gates wrote: > See >

Re: HS2: Permission denied for my own table?

2019-04-17 Thread Kaidi Zhao
I checked that the impersonation setting is correct. Also not using SQL authentication. Side note: looks like HS2 really wants to read the table's folder using user "hive" (just the folder) before it does anything else for the actual files. In the setup as describe above, I can query the table

Re: Hive metastore service

2019-04-17 Thread Odon Copon
Hi, I don't know if I am not understanding properly the design, but, isn't there supposed to be a Hive metastore service that Hive server uses to access the metastore db? On Tue, 16 Apr 2019, 22:26 Mich Talebzadeh, wrote: > Try this > > Assuming that you are talking about Hive Thrift server > >

Re: Hive metastore service

2019-04-17 Thread Odon Copon
Thanks Shawn, Yeah, I was talking about that. In that documentation didn't see any authentication so was wondering if there were options to protect it. But doesn't seem as you said. Thanks On Wed, 17 Apr 2019, 13:21 Shawn Weeks, wrote: > I think they misunderstood, your talking about this >

RE: Hive metastore service

2019-04-17 Thread Shawn Weeks
I think they misunderstood, your talking about this https://cwiki.apache.org/confluence/display/Hive/AdminManual+Metastore+Administration. As far as I know the only authentication it supports is Kerberos. Thanks Shawn From: Odon Copon Sent: Wednesday, April 17, 2019 3:16 AM To:

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

2019-04-17 Thread Suresh Kumar Sethuramaswamy
Did you try making a cron entry of kinit off keytab? It should work. On Tue, Apr 16, 2019, 4:06 PM 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

Re: HS2: Permission denied for my own table?

2019-04-17 Thread Alan Gates
See https://cwiki.apache.org/confluence/display/Hive/Setting+up+HiveServer2#SettingUpHiveServer2-Impersonation Alan. On Tue, Apr 16, 2019 at 10:03 PM Kaidi Zhao wrote: > Hello! > > Did I miss anything here or it is an known issue? Hive 1.2.1, hadoop > 2.7.x, kerberos, impersonation. > > Using