Anne Yu created SENTRY-919:
------------------------------

             Summary: Add tests cases: HDFS Sentry sync test case where all 
caps databases and tables are used
                 Key: SENTRY-919
                 URL: https://issues.apache.org/jira/browse/SENTRY-919
             Project: Sentry
          Issue Type: Bug
            Reporter: Anne Yu
            Assignee: Anne Yu


Add test cases to test: enable hdfs syncUp.

1. ensure permissions are the same and valid;
{code} 
use CARD_ACCT;
create table temp_table1 (testcol string);
drop table temp_table1;
use card_acct;
create table temp_table1 (testcol string);
{code}

2. ensure ACLs were correct for temp_table1 and TEMP_TABLE2/temp_table2;

{code}
use card_acct;
create table temp_table1 (testcol string);
create table TEMP_TABLE2 (testcol string);
grant all on temp_table1 to role test_role;
grant all on TEMP_TABLE2 to role hue_role;
(also tried with grant all on temp_table2 to role test_role)
{code}

3. ensure external table work fine;
{noformat}
1) Create two directories : /devl/src/ts2/acct/temp_table1 & 
/devl/src/ts2/acct/temp_table2 in HDFS.
2) login using beeline
3) use CARD_ACCT; (note the CAPS)
4) create a new table (say temp_table1) with location : 
/devl/src/ts2/acct/temp_table1
5) log out of beeline
6) check hdfs acls/perms for the /devl/src/ts2/acct/temp_table1 dir
7) login using beeline
8) use card_acct; (NOTE: make sure this is lower-caps)
9) create a new table (say temp_table2) with location : 
/devl/src/ts2/acct/temp_table2
10) log out
11) check hdfs acls/perms for the /devl/src/ts2/acct/temp_table2 dir
{noformat}



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

Reply via email to