hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vineet Garg (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-17415) Hit error "SemanticException View xxx is corresponding to LIMIT, rather than a SelectOperator." in Hive queries
Date Fri, 01 Sep 2017 04:43:00 GMT

     [ https://issues.apache.org/jira/browse/HIVE-17415?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Vineet Garg updated HIVE-17415:
-------------------------------
    Resolution: Fixed
        Status: Resolved  (was: Patch Available)

Pushed to master. Thanks [~djaiswal]

> 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
>         Attachments: HIVE-17415.1.patch, HIVE-17415.2.patch
>
>
> 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)

Mime
View raw message