You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Teruyoshi Zenmyo (JIRA)" <ji...@apache.org> on 2013/12/12 15:14:07 UTC

[jira] [Created] (HIVE-6022) Load statements with incorrect order of partitions put input files to unreadable places

Teruyoshi Zenmyo created HIVE-6022:
--------------------------------------

             Summary: Load statements with incorrect order of partitions put input files to unreadable places
                 Key: HIVE-6022
                 URL: https://issues.apache.org/jira/browse/HIVE-6022
             Project: Hive
          Issue Type: Bug
          Components: Query Processor
            Reporter: Teruyoshi Zenmyo


Load statements with incorrect order of partitions put input files to incorrect paths. 

{code}
CREATE TABLE test_parts (c1 string, c2 int) PARTITIONED BY (p1 string,p2 string);
LOAD DATA LOCAL INPATH '/opt/hive/examples/files/kv1.txt' OVERWRITE INTO TABLE test_parts PARTITION (p2='p1', p1='p2')"
{code}

The input file is located as below and the data is not readable.
{code}
% find /user/hive/warehouse/test_parts/
/user/hive/warehouse/test_parts/
/user/hive/warehouse/test_parts//p1=p2
/user/hive/warehouse/test_parts//p1=p2/p2=p1
/user/hive/warehouse/test_parts//p2=p1
/user/hive/warehouse/test_parts//p2=p1/p1=p2
/user/hive/warehouse/test_parts//p2=p1/p1=p2/.kv1.txt.crc
/user/hive/warehouse/test_parts//p2=p1/p1=p2/kv1.txt
{code}





--
This message was sent by Atlassian JIRA
(v6.1.4#6159)