[
https://issues.apache.org/jira/browse/HIVE-488?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12709224#action_12709224
]
Prasad Chakka commented on HIVE-488:
------------------------------------
a simple work around is to create the partition before doing insert overwrite
using query like below
alter table hive_test_dst add partition( pcol1='test_part', pcol2='test_part');
> 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
>
> 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.