Ask Your Question
0

hive metadata processor validation error - Reason: Provided Subject must contain a KerberosPrincipal

asked 2018-11-01 20:36:26 -0600

rasubramanian gravatar image

Hi,

We have a kerberized cloudera hadoop cluster which uses sentry for authorization.

I'm trying to create a simple pipeline to get the CDC from an oracle table and write it to hive.

hive metadata processor is throwing a validation error:

HIVE_22 - Cannot make connection with default hive database starting with URL: jdbc:hive2://xxxxxxxx.xxxxxx-us.com:10000/default;principal=hive/_HOST@HADOOP. Reason: Provided Subject must contain a KerberosPrincipal

Please let me know what could be missing.

Thanks, Ramesh

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
1

answered 2018-11-05 09:56:17 -0600

kirti gravatar image

Here is a great reference for connection URL: https://ask.streamsets.com/question/7...

Also, just to double check: Is your connection URL suffix exactly like default;principal=hive/_HOST@HADOOP ? Reason is:generally it will be something like default;principal=hive/hive-server2-h... where of course, your substitution will be according to your kerberos principal. This should be the exact principal that one can see from CM web UI.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-11-01 20:36:26 -0600

Seen: 20 times

Last updated: Nov 05