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

              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: