Configuring Impersonation for JDBC Interpreters
For databases that use the JDBC interface and support inbound impersonation, you can configure impersonation to work without using sudo.
To do so, configure interpreter in the user interface to be instantiated Per
User in Isolated process, check User
Impersonate, and then configure the
default.proxy.user.property
property in the interpreter settings to contain
the corresponding property name to be used to set the user to impersonate in the JDBC
connection string.
See this table for a guide to the property you must set:
For | Set this property |
---|---|
Hive | default.proxy.user.property=hive.server2.proxy.user |
Drill | default.proxy.user.property=impersonation_target |