Hello,
This is my first time working with Impala and I'm getting very odd errors, which I cannot find the cause of. I am trying to follow the Impala tutorial in http://www.cloudera.com/content/cloudera-content/cloudera-docs/Impala/latest/Installing-and-Using-Im.... When I try to create my external table from the impala-shell it gives me the following error:
ERROR: MetaException: Got exception: org.apache.hadoop.security.AccessControlException Permission denied: user=impala, access=WRITE, inode="/user":hdfs:supergroup:drwxr-xr-x
I am going nuts trying to google this and have found several suggestions, but non of which seems to do anything for me.
My files are in a directory /user/data/table1
I did a hdfs dfs -chmod on just about everthing I could think of to 777 so everything should be writeable. I made the user and group impala:impala on all the data files and the directories. Yet, I am still getting this error. The error message doesn't tell me specifically what directory the problem is. I really wish that were the case, then I wouldn't need to bother anyone.
Any suggestions would be very helpful?
Do I need a specific directory?
Should my CSV files be chown to some other user?
Should I be running impala-shell as a different user than root, hdfs, impala (I've tried all 3)?
Should I have ran the Cloudera Install Manager as a different user?
P.S. I moved the CSV file into the directory using the hdfs dfs -put command just like the tutorial said. This seems like great stuff if I could just get it to work.
Thanks
Raj
