[jira] [Created] (HIVE-14050) Hive attempts to 'chgrp' files on s3a://

["Sean Roberts (JIRA)" <ji...@apache.org>]

Sean Roberts created HIVE-14050:
-----------------------------------

             Summary: Hive attempts to 'chgrp' files on s3a://
                 Key: HIVE-14050
                 URL: https://issues.apache.org/jira/browse/HIVE-14050
             Project: Hive
          Issue Type: Bug
    Affects Versions: 1.2.1
            Reporter: Sean Roberts
            Assignee: Chris Nauroth


When inserting to a table on s3a://, Hive attempts to `chgrp` the files but files in s3a:// do not have group ownership.

{code}
hive> insert into INVENTORY select * from INVENTORY_Q1_2006;
-chgrp: '' does not match expected pattern for group
Usage: hadoop fs [generic options] -chgrp [-R] GROUP PATH...
{code}

Full output of the query here:
{code}
hive> insert into INVENTORY select * from INVENTORY_Q1_2006;
-chgrp: '' does not match expected pattern for group
Usage: hadoop fs [generic options] -chgrp [-R] GROUP PATH...
Query ID = admin_20160617201151_5f953fbe-acde-4774-9ad7-06cffc76dd72
Total jobs = 1
Launching Job 1 out of 1

Status: Running (Executing on YARN cluster with App id application_1466165341299_0011)

--------------------------------------------------------------------------------
        VERTICES      STATUS  TOTAL  COMPLETED  RUNNING  PENDING  FAILED  KILLED
--------------------------------------------------------------------------------
Map 1 ..........   SUCCEEDED      1          1        0        0       0       0
--------------------------------------------------------------------------------
VERTICES: 01/01  [==========================>>] 100%  ELAPSED TIME: 8.71 s
--------------------------------------------------------------------------------
Loading data to table mydb.inventory
-chgrp: '' does not match expected pattern for group
Usage: hadoop fs [generic options] -chgrp [-R] GROUP PATH...
Table mydb.inventory stats: [numFiles=12, numRows=6020352, totalSize=25250706, rawDataSize=96325632]
OK
Time taken: 19.123 seconds
{code}

The table:
{code}
CREATE TABLE IF NOT EXISTS inventory
   (
        MONTH_ID int,
        ITEM_ID int,
        BOH_QTY float,
        EOH_QTY float
   ) row format delimited fields terminated by '|' escaped by '\\' stored as ORC
LOCATION 's3a://mybucket/hive/warehouse/mydb.db/inventory'
tblproperties ("orc.compress"="SNAPPY");
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)