Cloudera Community

Announcements
Celebrating as our community reaches 100,000 members! Thank you!
pelasne
user rank
Explorer

Re: What is the "hive" password?

by Explorer in Support Questions
‎12-29-2015 03:14 PM
‎12-29-2015 03:14 PM
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. ... View more

Re: Permission Denied for user=hive on LOAD DATA I...

by Explorer in Support Questions
‎12-28-2015 08:12 PM
1 Kudo
‎12-28-2015 08:12 PM
1 Kudo
Thanks, granting permission for all users from /tmp up through /data worked fine. I am confused why the tutorial from http://hortonworks.com/hadoop-tutorial/hello-world... specifies only changing the permissions on the file if more than that is required. ... View more

Re: What is the "hive" password?

by Explorer in Support Questions
‎12-28-2015 07:37 PM
‎12-28-2015 07:37 PM
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 ... View more

What is the "hive" password?

by Explorer in Support Questions
‎12-28-2015 03:43 PM
1 Kudo
‎12-28-2015 03:43 PM
1 Kudo
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"). ... View more

Permission Denied for user=hive on LOAD DATA INPAT...

by Explorer in Support Questions
‎12-28-2015 03:33 PM
1 Kudo
‎12-28-2015 03:33 PM
1 Kudo
When trying to go through the tutorials on http://hortonworks.com/hadoop-tutorial/hello-world... I get a permission denied error when trying to LOAD DATA INPATH '/tmp/admin/data/trucks.csv' OVERWRITE INTO TABLE trucks_stage; This is using a brand new sandbox 2.3.2 instance in Azure. I did give the trucks.csv file WRITE permission for all 3. I am logged into Ambari as "admin". It appears the operation is running as "hive", which makes sense since that shows as the service account. LOG SNIPPET: INFO : Loading data to table default.trucks_stage from hdfs://sandbox.hortonworks.com:8020/tmp/admin/data/trucks.csv ERROR : Failed with exception Unable to move source hdfs://sandbox.hortonworks.com:8020/tmp/admin/data/trucks.csv to destination hdfs://sandbox.hortonworks.com:8020/apps/hive/warehouse/trucks_stage/trucks.csv org.apache.hadoop.hive.ql.metadata.HiveException: Unable to move source hdfs://sandbox.hortonworks.com:8020/tmp/admin/data/trucks.csv to destination hdfs://sandbox.hortonworks.com:8020/apps/hive/warehouse/trucks_stage/trucks.csv ... Caused by: org.apache.hadoop.security.AccessControlException: Permission denied: user=hive, access=WRITE, inode="/tmp/admin/data/trucks.csv":admin:hdfs:drwxr-xr-x ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎12-29-2015 03:12 PM
Community Statistics
Member Since ‎12-28-2015 03:00 PM
Last Visited ‎12-29-2015 03:12 PM
Posts 5
Kudos received 3