Member since
12-28-2015
5
Posts
3
Kudos Received
0
Solutions
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
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
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
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
Labels:
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:
- Labels:
-
Apache Hive