Ask Your Question
0

Hive metadata processor: Reason:Provided Subject must contain a KerberosPrincipal

asked 2019-05-24 00:34:11 -0500

PaulZ gravatar image

Hello,

The JDBC connection string which works in beeline does not work in the hive metadata processor.

The error is "HIVE_22 - Cannot make connection with default hive database starting with URL....... Reason: Provided Subject must contain a KerberosPrincipal"

Any clues on what could cause this?

Thank you, Paul

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
1

answered 2019-05-24 01:41:50 -0500

rishi gravatar image

updated 2019-05-24 01:45:53 -0500

metadaddy gravatar image

@PaulZ,

From the error, it looks like the client ( which is sdc in this case), doesn't have a valid identity/ticket, to present to the kerberized hive server.

Could you please check that the following Kerberos properties in the sdc.properties file are properly defined. and can you perform kinit and obtain the valid ticket. i.e

~grep kerberos sdc.properties     
kerberos.client.enabled=true    
kerberos.client.principal=sdc/_HOST@EXAMPLE.COM   
kerberos.client.keytab=sdc.keytab 

# kinit -kt sdc.keytab <principal_name>

See https://streamsets.com/documentation/...

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-05-24 00:34:11 -0500

Seen: 41 times

Last updated: May 24