Hive：动态分区

debugcn 发表于 Dev

超级

我正在尝试实现动态分区以更新最近 30 个分区中的日期：

set hive.exec.dynamic.partition=true;
insert overwrite tmp_ol.user_status_aggre partition(`day`)
select 
uuid,
uv+(case when b.uuid is not null then 1 else 0 end) as uv,
`date` as `day`
from 
(select uuid,uv,`date` from user_status_aggre where `day` between `2017-05-15` and `2017-05-22`) a
left join 
(select uuid from tabledemo where `day`='2017-05-22') b
on a.uuid=b.uuid

但我收到一个错误：

FAILED: ParseException line 1:17 cannot recognize input near 'tmp_ol' '.' 'user_status_aggre' in destination specification

创建表的查询如下：

create table tmp_ol.user_status_aggre (
uuid string,
uv string,
`date` date)
PARTITIONED BY (`day` string)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001'
STORED AS textfile;

我想知道动态分区是否不能应用于自身..感谢您的帮助。

萨蒂什·库马尔·雷迪

试试下面的一个：

SET hive.exec.dynamic.partition=true;
INSERT
    overwrite TABLE tmp_ol.user_status_aggre partition
    (
        day 
    )
SELECT
    uuid,
    uv+(
        CASE
            WHEN b.uuid IS NOT NULL
            THEN 1
            ELSE 0
        END) AS uv,
    date   AS day
FROM
    (
        SELECT
            uuid,
            uv,
            date
        FROM
            user_status_aggre
        WHERE
            day BETWEEN '2017-05-15' AND '2017-05-22') a
LEFT JOIN
    (
        SELECT
            uuid
        FROM
            tabledemo
        WHERE
            day='2017-05-22') b
ON
    a.uuid=b.uuid

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。