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

[Xavier Carol Rossell]

Hi,

The user reports that the problem has been solved.
This ticket can be closed.

Thanks.

2015-07-13 9:18 GMT+02:00 Xavier Carol Rossell <xavier.carol at i2cat.net>:

> 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/988b9584/attachment.html>