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