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

        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open In Progress In Progress
        41m 39s 1 Silvio Cretti 13/Jul/15 10:00 AM
        In Progress In Progress Answered Answered
        2s 1 Silvio Cretti 13/Jul/15 10:00 AM
        Answered Answered Closed Closed
        2s 1 Silvio Cretti 13/Jul/15 10:00 AM

          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: