Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-17415

Hit error "SemanticException View xxx is corresponding to LIMIT, rather than a SelectOperator." in Hive queries

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 3.0.0
    • None
    • None

    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;

      Attachments

        1. HIVE-17415.1.patch
          6 kB
          Deepak Jaiswal
        2. HIVE-17415.2.patch
          7 kB
          Deepak Jaiswal

        Activity

          People

            djaiswal Deepak Jaiswal
            djaiswal Deepak Jaiswal
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: