How to block Hive CLI access?

[#1]

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

[#2 · Accepted solution]

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

[#3]

@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

[#4]

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

[#5]

I appreciate all the feedback.

[#6]

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