Step 2: Modify drill-override.conf

For secure and non-secure clusters, modify <DRILL_HOME>/conf/drill-override.conf on each Drill node to enable impersonation in Drill, and set the maximum number of chained user hops that Drill allows.
Add the following configuration properties to the drill.exec block in drill-override.conf:
drill.exec: {
 cluster-id: "<drill_cluster_name>",
 zk.connect: "<hostname>:5181,<hostname>:5181,<hostname>:5181"
 impersonation: {
       enabled: true,
       max_chained_user_hops: 3