Page MenuHomePhabricator

Need access for smalyshev to hive queries on stat1002
Closed, ResolvedPublic

Description

I can access stat1002 but when I run a query like this:

select * from webrequest where year=2015 AND month=8 and day=24 AND uri_host='query.wikidata.org' limit 10;

I get this error:

Job Submission failed with exception 'org.apache.hadoop.security.AccessControlException(Permission denied: user=smalyshev, access=WRITE, inode="/user":hdfs:hadoop:drwxrwxr-x
	at org.apache.hadoop.hdfs.server.namenode.DefaultAuthorizationProvider.checkFsPermission(DefaultAuthorizationProvider.java:257)
	at org.apache.hadoop.hdfs.server.namenode.DefaultAuthorizationProvider.check(DefaultAuthorizationProvider.java:238)
etc..

Please add whichever permissions necessary so it can be queried.

Event Timeline

Smalyshev raised the priority of this task from to High.
Smalyshev updated the task description. (Show Details)

I will add my approval if required from the Ops side.

Change 233987 had a related patch set uploaded (by Alexandros Kosiaris):
Move smalyshev to analytics-privatedata-users group

https://gerrit.wikimedia.org/r/233987

Change 233987 merged by Alexandros Kosiaris:
Move smalyshev to analytics-privatedata-users group

https://gerrit.wikimedia.org/r/233987

akosiaris claimed this task.

This has been merged. access is fine now, resolving