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

Hive default authorization does not allow cross-database create table

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.2.1
    • None
    • Authorization
    • None

    Description

      hive> use default;
      OK
      hive> create table jhseu.test_table1 (a int);
      Authorization failed:No privilege 'Create' found for outputs

      { database:default}

      . Use SHOW GRANT to get more details.
      15/12/17 16:26:09 ERROR ql.Driver: Authorization failed:No privilege 'Create' found for outputs

      { database:default}

      . Use SHOW GRANT to get more details.
      hive> use jhseu;
      OK
      hive> create table jhseu.test_table1 (a int);
      OK

      Create table authorization checks against the table you're currently using, but it only should check against the destination.

      Attachments

        Activity

          People

            Unassigned Unassigned
            vomjom Jonathan Hseu
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated: