Support Questions
Find answers, ask questions, and share your expertise

How to block Hive CLI access?

Super Guru

Hive CLI will be depercated soon. Is there any way to block invoking hive CLI? this way forcing users to only use beeline.

1 ACCEPTED SOLUTION

Accepted Solutions

You could symbolic link the hive cli script/command to the beeline script command. This will ensure the "hive" command always executes "beeline".

Here is another solution: https://community.hortonworks.com/questions/10760/how-to-disable-hive-shell-for-all-users.html

View solution in original post

5 REPLIES 5

You could symbolic link the hive cli script/command to the beeline script command. This will ensure the "hive" command always executes "beeline".

Here is another solution: https://community.hortonworks.com/questions/10760/how-to-disable-hive-shell-for-all-users.html

View solution in original post

@Sunile Manjee

One way to accomplish this would be to change the permissions on the hive executable to remove read and execute access for group and other:

chmod 400 /usr/hdp/current/hive-client/bin/hive

Of course both of these options can be worked around by anyone with access and rights to the file system.

Super Guru

I appreciate all the feedback.

just use doAs=true make sure only hive can read the warehouse folder and you are done. Hive cli can start but not access anything