You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@drill.apache.org by Santosh Kulkarni <sa...@gmail.com> on 2016/07/04 02:00:50 UTC

Drill on Kerberos (Hive Storage plugin)

Hi,

Drill query gives the following error for Hive storage plugin.

show databases;

Error: SYSTEM ERROR: GSSException: No valid credentials provided (Mechanism
Level: Failed to find any Kerberos tgt)
This worked before.

After renewing the Kerberos connection using kinit -R command, query shows
results. Tried few hours later and it gave the same error again.

By default the system generates the user ticket. Ensured the ticket is not
expired  using klist -e.

Hive works fine without any issues for the same query.

Any pointers how to fix this issue?

Thanks,

Santosh

Re: Drill on Kerberos (Hive Storage plugin)

Posted by Sudheesh Katkam <sk...@maprtech.com>.

Can you share the Hive storage plugin configuration?

Thank you,
Sudheesh

> On Jul 3, 2016, at 7:00 PM, Santosh Kulkarni <sa...@gmail.com> wrote:
> 
> Hi,
> 
> Drill query gives the following error for Hive storage plugin.
> 
> show databases;
> 
> Error: SYSTEM ERROR: GSSException: No valid credentials provided (Mechanism
> Level: Failed to find any Kerberos tgt)
> This worked before.
> 
> After renewing the Kerberos connection using kinit -R command, query shows
> results. Tried few hours later and it gave the same error again.
> 
> By default the system generates the user ticket. Ensured the ticket is not
> expired  using klist -e.
> 
> Hive works fine without any issues for the same query.
> 
> Any pointers how to fix this issue?
> 
> Thanks,
> 
> Santosh