Versions Compared

Old Version 26

changes.mady.by.user Lefty Leverenz

Saved on

compared with

New Version 27

changes.mady.by.user Thejas Nair

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: highlighting the need for 'set role admin'

...

  • hive.server2.enable.doAs to false.
  • hive.users.in.admin.role to the list of comma-separated users who need to be added to admin role. Note that a user who belongs to the admin role needs to run the "set role" command before getting the privileges of the admin role, as this role is not in current roles by default.

Start HiveServer2 with the following additional command-line options:

...

  • ISO 9075 Part 1 Framework sections 4.2.6, 4.6.11
  • ISO 9075 Part 2 Foundation sections 4.35 and 12

Troubleshooting

  • The user is in hive.users.in.admin.role in hive-site.xml, but I still get the error that user is not an admin. What could be wrong ?
    • Ensure that you have restarted hive server2 after config change and that you have hiveserver2 command line options as described above.
    • Ensure that you have run a 'set role admin;' command to get the admin role.