Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

How to block Hive CLI access?

avatar
Master 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

avatar
Super Guru

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

avatar
Super Guru

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

avatar

@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

avatar
Super Guru

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

avatar
Master Guru

I appreciate all the feedback.

avatar
Master Guru

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