Uploaded image for project: 'Help-Coaches-Desk'
  1. Help-Coaches-Desk
  2. HELC-877

FIWARE.Request.Coach.CreatiFI.General Support #355: Not possible to create table from select

    Details

    • Type: extRequest
    • Status: Closed
    • Priority: Major
    • Resolution: Done
    • Component/s: CreatiFI
    • Labels:
      None

      Description

      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.

      _______________________________________________
      Fiware-creatifi-coaching mailing list
      Fiware-creatifi-coaching@lists.fi-ware.org
      https://lists.fi-ware.org/listinfo/fiware-creatifi-coaching

      [Created via e-mail received from: Xavier Carol Rossell <xavier.carol@i2cat.net>]

        Activity

        Hide
        fw.ext.user FW External User added a comment -

        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@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.
        >

        _______________________________________________
        Fiware-creatifi-coaching mailing list
        Fiware-creatifi-coaching@lists.fi-ware.org
        https://lists.fi-ware.org/listinfo/fiware-creatifi-coaching

        Show
        fw.ext.user FW External User added a comment - 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@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. > _______________________________________________ Fiware-creatifi-coaching mailing list Fiware-creatifi-coaching@lists.fi-ware.org https://lists.fi-ware.org/listinfo/fiware-creatifi-coaching
        Hide
        silviocretti Silvio Cretti added a comment -

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

        Show
        silviocretti Silvio Cretti added a comment - The user reports that the problem has been solved. This ticket can be closed.

          People

          • Assignee:
            silviocretti Silvio Cretti
            Reporter:
            fw.ext.user FW External User
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: