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

[Deepak Jaiswal (JIRA)]

Deepak Jaiswal created HIVE-17415:
-------------------------------------

             Summary: Hit error "SemanticException View xxx is corresponding to 
LIMIT, rather than a SelectOperator." in Hive queries
                 Key: HIVE-17415
                 URL: https://issues.apache.org/jira/browse/HIVE-17415
             Project: Hive
          Issue Type: Bug
            Reporter: Deepak Jaiswal
            Assignee: Deepak Jaiswal


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;



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)