[HIVE-17415] Hit error "SemanticException View xxx is corresponding to LIMIT, rather than a SelectOperator." in Hive queries

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0.0
• Assignee: Deepak Jaiswal
• Reporter: Deepak Jaiswal
• Created: 30/Aug/17 21:56
• Updated: 22/May/18 23:14
• Resolved: 01/Sep/17 04:42

Description

Hit error "SemanticException View xxx is corresponding to LIMIT, rather than a SelectOperator." in Hive queries when a user creates a view with limits

set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.DefaultHiveAuthorizationProvider;

create table my_passwd (
username string,
uid int);

insert into my_passwd values
("Dev1", 1),
("Dev2", 2),
("Dev3", 3),
("Dev4", 4),
("Dev5", 5),
("Dev6", 6);

create view my_passwd_vw as select * from my_passwd limit 3;

set hive.security.authorization.enabled=true;
grant select on table my_passwd to user hive_test_user;
grant select on table my_passwd_vw to user hive_test_user;

select * from my_passwd_vw;