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

Subquery inside a view will have the object in the subquery as the direct input

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.0.1
    • Fix Version/s: 2.2.0
    • Component/s: Views
    • Labels:
      None

      Description

      Here is the repro steps.

      create table t1(col string);
      create view v1 as select * from t1;
      create view dataview as select * from  (select * from v1) v2;
      select * from dataview;
      

      If hive is configured with authorization hook like Sentry, it will require the access not only for dataview but also for v1, which should not be required.
      The subquery seems to not carry insideview property from the parent query.

        Attachments

        1. HIVE-14805.2.patch
          18 kB
          Aihua Xu
        2. HIVE-14805.1.patch
          3 kB
          Aihua Xu

          Issue Links

            Activity

              People

              • Assignee:
                aihuaxu Aihua Xu
                Reporter:
                aihuaxu Aihua Xu
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: