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

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.0.0
    • Component/s: None
    • Labels:
      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

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

              Dates

              • Created:
                Updated:
                Resolved: