[jira] [Created] (SENTRY-747) Create a view by unioning tables, grant select then select from view encounter errors (1.5.0 only)

[Anne Yu (JIRA)]

Anne Yu created SENTRY-747:
------------------------------

             Summary: Create a view by unioning tables, grant select then 
select from view encounter errors (1.5.0 only)
                 Key: SENTRY-747
                 URL: https://issues.apache.org/jira/browse/SENTRY-747
             Project: Sentry
          Issue Type: Bug
    Affects Versions: 1.5.0
            Reporter: Anne Yu
             Fix For: 1.5.0


cc [~sravya]. This issue shows after column level privilege.

{code}
CREATE TABLE test_complex_view_table (userid VARCHAR(64), link STRING, source 
STRING) PARTITIONED BY (datestamp STRING) CLUSTERED BY (userid) INTO 256 
BUCKETS STORED AS ORC;

CREATE TABLE test_complex_view_table_2 (userid VARCHAR(64), name VARCHAR(64), 
age INT, gpa DECIMAL(3, 2)) CLUSTERED BY (age) INTO 2 BUCKETS STORED AS ORC;

CREATE TABLE test_user_info (userid VARCHAR(64), name STRING, address STRING, 
tel STRING);

CREATE VIEW test_complex_view AS SELECT u.userid, u.name, u.address, res.uid 
FROM (SELECT t1.userid AS uid FROM test_complex_view_table t1 UNION ALL SELECT 
t2.userid AS uid FROM test_complex_view_table_2 t2 ) res JOIN test_user_info u 
ON (u.userid = res.uid);

Required privileges for this query: 
Server=server1->Db=test_complex_view_database->Table=test_complex_view_table->Column=userid->action=select;
{code}



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