[ https://issues.apache.org/jira/browse/HIVE-488?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12710573#action_12710573 ]
Ashish Thusoo commented on HIVE-488: ------------------------------------ Looks like this is a JIRA bug. +1 for the fix. > 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 > Components: Query Processor > Affects Versions: 0.4.0 > Reporter: Prasad Chakka > Assignee: Prasad Chakka > Attachments: hive-488.2.patch, hive-488.patch > > > 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.