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)
Restricted Application added subscribers: Matanya, Aklapper. · View Herald TranscriptAug 25 2015, 5:29 PM

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

@Wwes no need. This was a misconfiguration on our part. https://gerrit.wikimedia.org/r/233987 fixes that

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

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

akosiaris closed this task as Resolved.Aug 26 2015, 6:24 PM
akosiaris claimed this task.

This has been merged. access is fine now, resolving