[jira] [Created] (DRILL-4646) Make Hive impersonation work consistently under two modes for INFORMATION_SCHEMA query

["Jinfeng Ni (JIRA)" <ji...@apache.org>]

Jinfeng Ni created DRILL-4646:
---------------------------------

             Summary: Make Hive impersonation work consistently under two modes for INFORMATION_SCHEMA query
                 Key: DRILL-4646
                 URL: https://issues.apache.org/jira/browse/DRILL-4646
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Jinfeng Ni


Per the discussion of DRILL-4577, for INFORMATION_SCHEMA query 

{code}
select TABLE_CATALOG, TABLE_SCHEMA , TABLE_NAME, TABLE_TYPE from
INFORMATION_SCHEMA.`TABLES` 
...
{code}

Drill's current behavior under Storage-based and Sql-standard impersonation is different. 
1. Under storage-based mode, the above query will only return the tables the user has access.
2. Under sql-standard mode, the above query will return tables the user does not have access.

Either Drill should correct the behavior of sql-standard mode, or Drill should do something to make the two modes behavior consistently.





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)