[
https://issues.apache.org/jira/browse/HIVE-5094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Eugene Koifman updated HIVE-5094:
---------------------------------
Description:
Here is a sequence of commands to run to reproduce the issue
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.
was:
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.
> [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
>
> Here is a sequence of commands to run to reproduce the issue
> 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
