Uploaded image for project: 'Hue (READ ONLY)'
  1. Hue (READ ONLY)
  2. HUE-5608

[editor] Display table column list if user does not have access to table but has some column level access

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 3.11.0
    • Fix Version/s: 4.0.0
    • Component/s: con.hive
    • Labels:
      None

      Description

      Give user access to a column of a table, but no access to the table itself, SELECT column_name FROM table works in beeline, but Hue fails to display the list of columns the user have access to in the Hue Hive Editor page.

      By checking the Hue log, it showed the Hue runs the following command:

      DESCRIBE FORMATTED `test`.`test_table`
      {/code}
      
      and failed with error:
      
      

      FAILED: SemanticException No valid privileges\n User yshi does not have privileges for DESCTABLE
      The required privileges:
      Server=server1->Db=test->Table=test_table->action=insert;
      Server=server1->Db=test->Table=test_table->action=select;

      {/code}

      It is understood that it is by design that DESC FORMATTED requires TABLE level privilege, so Hue has to update accordingly for this.

        Attachments

          Activity

            People

            • Assignee:
              romain Romain Rigaux
              Reporter:
              ericlin Eric Lin
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: