Eugene Koifman created HIVE-5094:
------------------------------------

             Summary: [WebHCat] updating table permission have no effect
                 Key: HIVE-5094
                 URL: https://issues.apache.org/jira/browse/HIVE-5094
             Project: Hive
          Issue Type: Bug
          Components: HCatalog
    Affects Versions: 0.12.0
            Reporter: Eugene Koifman


curl -i -X DELETE  
'http://localhost:50111/templeton/v1/ddl/database/default/table/test_table?user.name=ekoifman&ifExists=true'

curl -i -X PUT -HContent-type:application/json \
   -d '{ "comment":"test comment", "columns": [ { "name": "int", "type": 
"string", "comment":"1st column comment" }, {"name":"int2", "type":"int"} ], 
"forma\
t": { "storedAs": "rcfile" } }' \
    
'http://localhost:50111/templeton/v1/ddl/database/default/table/test_table?user.name=ekoifman&ifExists=true'

curl -i -X GET 
'http://localhost:50111/templeton/v1/ddl/database/default/table/test_table?user.name=ekoifman&format=extended'

This returns
{"minFileSize":0,"totalNumberFiles":0,"location":"hdfs://localhost:9000/user/hive/warehouse/test_table","outputFormat":"org.apache.hadoop.hive.ql.io.RCFileOutputFormat","lastAccessTime":0,"lastUpdateTime":1376513774995,"columns":[{"name":"int","comment":"from
 deserializer","type":"string"},{"name":"int2","comment":"from 
deserializer","type":"int"}],"maxFileSize":0,"partitioned":false,"owner":"ekoifman","inputFormat":"org.apache.hadoop.hive.ql.io.RCFileInputFormat","totalFileSize":0,"database":"default","table":"test_table","group":"supergroup","permission":"rwxr-xr-x"}


curl -i -X POST -HContent-type:application/json \
-d rename=test_table2 -d permissions='rwx------' \
'http://localhost:50111/templeton/v1/ddl/database/default/table/test_table?user.name=ekoifman'


curl -i -X GET 
'http://localhost:50111/templeton/v1/ddl/database/default/table/test_table2?user.name=ekoifman&format=extended'

This returns:

{"minFileSize":0,"totalNumberFiles":0,"location":"hdfs://localhost:9000/user/hive/warehouse/test_table2","outputFormat":"org.apache.hadoop.hive.ql.io.RCFileOutputFormat","lastAccessTime":0,"lastUpdateTime":1376513774995,"columns":[{"name":"int","comment":"from
 deserializer","type":"string"},{"name":"int2","comment":"from 
deserializer","type":"int"}],"maxFileSize":0,"partitioned":false,"owner":"ekoifman","inputFormat":"org.apache.hadoop.hive.ql.io.RCFileInputFormat","totalFileSize":0,"database":"default","table":"test_table2","group":"supergroup","permission":"rwxr-xr-x"}

So the table name is changed but permissions are not.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Reply via email to