Could I ask any of you who are on Hive v0.14 to check if such CTAS syntax
works?
Many thanks!
On Thu, Nov 6, 2014 at 10:32 AM, Maciek wrote:
> What I'm referring to is CTAS statement and as per documentation it
> doesn't seem to work (Hive 0.13).
> I'm setting:
>
> SET hive.exec.dynamic.partitio
What I'm referring to is CTAS statement and as per documentation it doesn't
seem to work (Hive 0.13).
I'm setting:
SET hive.exec.dynamic.partition=true;
SET hive.exec.dynamic.partition.mode=nonstrict;
and
CREATE TABLE dropme(key int, value string) PARTITIONED BY (yr int, mth int)
AS
SELECT 2 key,
The following worked for me:
> CREATE TABLE dropme(key int, value string) PARTITIONED BY (yr int, mth
int);
> SET hive.exec.dynamic.partition.mode=nonstrict
> INSERT INTO TABLE dropme PARTITION(yr,mth)
SELECT stack(1,
2, 'val', 2014, 5) AS
(key, value, yr, mth) FROM singlerow;
Note that you nee
