You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Buntu Dev <bu...@gmail.com> on 2015/08/22 05:00:01 UTC
SemanticException Partition spec {p1=null, p2=null} contains
non-partition columns
I'm running into this error while doing a dynamic partition insert. Heres
how I created the table:
~~~~
CREATE TABLE `part_table`(
`c1` bigint,
`c2` bigint,
`c3` bigint)
PARTITIONED BY (p1 string, `p2` string)
STORED AS PARQUET;
~~~~
Here is the insert table:
~~~~
SET hive.exec.dynamic.partition = true;
SET hive.exec.dynamic.partition.mode = nonstrict;
insert overwrite table part_table partition(p1, p2)
select c1 as c1,
c2 as c2,
c3 as c3,
regexp_replace(date_col, '-', '') as p1,
p2 as p2
from src_table;
~~~~
I'm using Hive 1.1.0 on CDH 5.4.2. Can anyone let me know what else is
missing?
Thanks!