Ask Your Question

How do I impersonate a Hive user over JDBC?

asked 2017-12-11 12:16:05 -0500

metadaddy gravatar image

SDC supports the use of HDFS User and impersonation for writing to HDFS as a user other than the SDC service user sdc. Is there a similar concept for accessing the Hive Metastore? There is no _Hive User_ exposed in the SDC UI for the Metastore processor or destination. The JDBC URL seems to be used to pass a Hive principal when the Hadoop environment is Kerberized, but it seems that the SDC service user is still used and needs permissions to access the Hive Metastore and perform DDL operations.

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2017-12-11 12:21:03 -0500

metadaddy gravatar image

updated 2017-12-11 12:43:32 -0500

There is no standard for impersonation on JDBC - each driver has it's own mechanism. For example:

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-12-11 12:16:05 -0500

Seen: 1,810 times

Last updated: Dec 11 '17