[ https://issues.apache.org/jira/browse/HIVE-17415?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Deepak Jaiswal reassigned HIVE-17415: ------------------------------------- > 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)