Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
MIME-Version: 1.0
Date: Fri, 21 Aug 2015 20:00:01 -0700
Message-ID: 
 <CA+CA-8sthKNCOj_bX_7EbDU-eTLXrA8K3XczeJ2Osj+jY+Td5Q@mail.gmail.com>
Subject: SemanticException Partition spec {p1=null, p2=null} contains
 non-partition columns
From: Buntu Dev <buntudev@gmail.com>
To: user@hive.apache.org
Content-Type: multipart/alternative; boundary=001a11c31f74987c89051ddd94cb

--001a11c31f74987c89051ddd94cb
Content-Type: text/plain; charset=UTF-8

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!

--001a11c31f74987c89051ddd94cb
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">I&#39;m running into this error while doing a dynamic part=
ition insert. Heres how I created the table:<div><br></div><div>~~~~</div><=
div><div>CREATE TABLE `part_table`(</div><div>=C2=A0 `c1` bigint,</div><div=
>=C2=A0 `c2` bigint,</div><div>=C2=A0 `c3` bigint)</div><div>PARTITIONED BY=
 (p1 string, `p2` string)</div><div>STORED AS PARQUET;</div></div><div><br>=
</div><div>~~~~</div><div><br></div><div>Here is the insert table:</div><di=
v><br></div><div>~~~~</div><div><div>SET hive.exec.dynamic.partition =3D tr=
ue;</div><div>SET hive.exec.dynamic.partition.mode =3D nonstrict;</div></di=
v><div><br></div><div><div>insert overwrite table part_table partition(p1, =
p2)</div><div>select c1 as c1,</div><div>=C2=A0 c2 as c2,</div><div>=C2=A0 =
c3 as c3,</div><div>=C2=A0 regexp_replace(date_col, &#39;-&#39;, &#39;&#39;=
) as p1,</div><div>=C2=A0 p2 as p2</div><div>from src_table;</div></div><di=
v>~~~~</div><div><br></div><div>I&#39;m using Hive 1.1.0 on CDH 5.4.2. Can =
anyone let me know what else is missing?</div><div><br></div><div>Thanks!</=
div></div>

--001a11c31f74987c89051ddd94cb--