Skip to content

Getting select privileges error via pyhs2 but not getting it while accessing directly from hive #68

@MyPythonGitHub

Description

@MyPythonGitHub

Hi,
I am getting a peculiar error. While trying to access a table via pyhs2, I am getting the following error: pyhs2.error.Pyhs2Exception: 'Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [user] does not have [SELECT] privilege on [db/tablename]'

      However, when I am trying to access the same table directly through hive via executing the query "select count(*) from db.tablename", I amn't getting any error. The username is the same in both the attempts. Please can you let me know why amn't I able to access the table using pyhs2. Is there any specific permission / privilege which pyhs2 is seeking for ?

Cheers

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions