[jira] [Commented] (DRILL-8061) Add Impersonation Support for Phoenix

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-8061?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17469006#comment-17469006 ] 

ASF GitHub Bot commented on DRILL-8061:
---------------------------------------

vdiravka opened a new pull request #2422:
URL: https://github.com/apache/drill/pull/2422


   # [DRILL-8061](https://issues.apache.org/jira/browse/DRILL-8061): Add Impersonation Support for Phoenix
   
   ## Description
   
   Drill Hadoop User Impersonation for Apache Phoenix
   
   ## Documentation
   
   ### Impersonation
   Configurations :
   1. Enable [Drill User Impersonation](https://drill.apache.org/docs/configuring-user-impersonation/)
   2. Enable [PQS Impersonation](https://phoenix.apache.org/server.html#Impersonation)
   3. PQS URL:
      1. Provide `host` and `port` and Drill will generate the PQS URL with a doAs parameter of current session user
      2. Provide the `jdbcURL` with a `doAs` url param and `$user` placeholder as a value, for instance: 
         `jdbc:phoenix:thin:url=http://localhost:8765?doAs=$user`. In case Drill Impersonation is enabled, but `doAs=$user` 
         is missing the User Exception is thrown.
   
   ## Testing
   Added IT test cases for the kerberized `hadoop-minikdc` Phoenix + Drill cluster. 
   Tests run for 3 clients: 
   * the first has all permission
   * Impersonated, but don't have an permissions to access the tables
   * not impersonated by admin
   
   Draft until all test cases pass


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@drill.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


> Add Impersonation Support for Phoenix
> -------------------------------------
>
>                 Key: DRILL-8061
>                 URL: https://issues.apache.org/jira/browse/DRILL-8061
>             Project: Apache Drill
>          Issue Type: Sub-task
>          Components: Storage - Other
>            Reporter: Cong Luo
>            Assignee: Vitalii Diravka
>            Priority: Major
>             Fix For: 1.20.0
>
>
> *Discussion:*
>  * [https://github.com/apache/drill/issues/2296]
> *Documentation:*
>  * [https://phoenix.apache.org/server.html#Impersonation] 
>  * [https://drill.apache.org/docs/configuring-user-impersonation]



--
This message was sent by Atlassian Jira
(v8.20.1#820001)