[HIVE-13910] [Ranger-Hive] select from a table is not working if used as <dbname.tablename>

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0
• Fix Version/s: 2.1.0
• Assignee: Pengcheng Xiong
• Reporter: Pengcheng Xiong
• Created: 01/Jun/16 22:12
• Updated: 21/Jun/16 15:06
• Resolved: 03/Jun/16 22:03

Description

set hive.mapred.mode=nonstrict;
set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest;

create database newdb;

use newdb;

create table masking_test as select cast(key as int) as key, value from default.src;

use default;

explain select * from newdb.masking_test;
select * from newdb.masking_test;

explain select * from newdb.masking_test where key > 0;
select * from newdb.masking_test where key > 0;