[Fiware-creatifi-coaching] [CreatiFI Helsinki Hub] General Support #355: Not possible to create table from select

[Xavier Carol Rossell]

Hi,

A user is having trouble accessing the global instance of Cosmos. Here it
is his report:

"CREATE TABLE mick_viewers_count AS SELECT account, COUNT as count FROM
mick_viewers GROUP BY account;
After running for about 2 mins (map/reduce job) fails with:

Failed with exception org.apache.hadoop.security.AccessControlException:
Permission denied: user=mick, access=EXECUTE,
inode="/user/hive":hive:hive:drwxr-----
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.MoveTask"

Thanks in advance,
Xavier Carol.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.fiware.org/private/fiware-creatifi-coaching/attachments/20150713/0bca0bd3/attachment.html>