question Re: What is the "hive" password? in Archives of Support Questions (Read Only)

What is the "hive" password?

pelasne — Fri, 16 Sep 2022 09:54:52 GMT

In http://hortonworks.com/hadoop-tutorial/hello-world... it mentions that you could run the queries via the shell. I am using an Azure sandbox 2.3.2 and I can login using my username/password. However, when I "su hive" it will not accept any of the passwords I could think to try ("hive", "admin", "hadoop").

Re: What is the "hive" password?

deepesh1 — Tue, 29 Dec 2015 01:10:39 GMT

You should be able to bring up hive shell as the login user (without su as hive) by typing hive at the terminal prompt.

Re: What is the "hive" password?

pardeep_kumar — Tue, 29 Dec 2015 02:23:19 GMT

@Peter Lasne All Service accounts i.e. hive, hdfs, mapred etc. are kind of password-less with auto generated and auto changed hash passwords i.e. managed accounts. You can login to these users from a sudo user account or as root user by doing "su - hive" or "sudo su - hive" and so on based on root or sudo user account.

On other hand, to bring up hive shell, you don't need to login as hive as @Deepesh said. You can bring up hive shell by typing hive at terminal prompt.

Re: What is the "hive" password?

pelasne — Tue, 29 Dec 2015 03:37:04 GMT

Thanks. "sudo su - hive" worked. However, I cannot just use my account because it throws a permissions error. If you happened to see my other threads I am getting some permissions errors there too, but all I did was install the sandbox, shouldn't that already be configured with the appropriate permissions?

Logging initialized using configuration in file:/etc/hive/2.3.2.0-2950/0/hive-log4j.properties

Exception in thread "main" java.lang.RuntimeException: org.apache.hadoop.security.AccessControlException: Permission denied: user=plasne, access=WRITE, inode="/user/plasne":hdfs:hdfs:drwxr-xr-x

Re: What is the "hive" password?

pelasne — Tue, 29 Dec 2015 23:14:24 GMT

In case this helps with the tutorial, I believe the permission error went away after I created a /user directory for my account in HDFS. I was using the Azure sandbox 2.3.2 so my username was something I keyed in when creating the VM.

Re: What is the "hive" password?

vetriaec — Wed, 28 Dec 2016 13:50:49 GMT

@Vetrivel S

I think your path "/user/plasne" in HDFS dont have write permission.

Kindly try to give write permission for respective path, suppose you are in Ubuntu

"hadoop fs -chmod g+w /user/plasne" without quotes in terminal

then start your hive