loading into a partition with more than one partition column fails if the 
partition is not created before.
----------------------------------------------------------------------------------------------------------

                 Key: HIVE-488
                 URL: https://issues.apache.org/jira/browse/HIVE-488
             Project: Hadoop Hive
          Issue Type: Bug
            Reporter: Prasad Chakka
            Assignee: Prasad Chakka


Following test fails on HDFS cluster but not on local file system.

drop table hive_test_src;
drop table hive_test_dst;
create table hive_test_src ( col1 string ) stored as textfile ;
load data local inpath '../data/files/test.dat' overwrite into table 
hive_test_src ;
create table hive_test_dst ( col1 string ) partitioned by ( pcol1 string , 
pcol2 string) stored as sequencefile;
insert overwrite table hive_test_dst partition ( pcol1='test_part', 
pcol2='test_part') select col1 from hive_test_src ;
select * from hive_test_dst where pcol1='test_part' and pcol2='test_part'; -- 
returns zero rows.
drop table hive_test_src;
drop table hive_test_dst;

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to