When I use CTAS in drill, it always creates table that has default permission as mapr. How can I change the default permission to be the user who is running the query?
You need to enable PAM authentication or any other kind of authentication.
Here is the doc:
Configuring Plain Security - Apache Drill
Hi Sabamu L,
Have you checked and followed https://drill.apache.org/docs/configuring-user-impersonation/? Hope it is helpful.
Thank you, Cathy Liu. This document helped.
I am able to enable user-impersonation. It works when I use sqlline specifying the user in sqlline.
sqlline -u jdbc:drill:zk=localhost:5181 -n user01
I also followed Drill Workshop -- Impersonation | Open Knowledge Base document.
But when I used the web browser, I am not able to execute any queries. I'm getting the following error. In the browser, we can't login as any user. How does it work in the browser?
org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: IOException: Error getting user info for current user, anonymous [Error Id: e3c4810c-c145-4f5e-a3b1-e86efccd9065 on maprdemo:31010]
Hao Zhu, Any idea?
Retrieving data ...