无法覆盖 Hive 表中的分区

Question

我正在尝试覆盖表的某个分区。我的查询很大，但是我设法找到了一个重现错误的最小代码。当我尝试运行此操作时：

INSERT OVERWRITE TABLE sbx.calls_out PARTITION (date_call) 
SELECT
    z.corp,
    z.time_call,
    z.comp,
    z.serv
    z.date_call
FROM (
    SELECT
        'a' as corp,
        1 as time_call,
        'b' as comp,
        '20190625' as date_call,
        'c' as serv
) AS z;

这返回以下错误：

Failed to recognize predicate '.'. Failed rule: 'regularBody' in statement

但是，如果我运行完全相同的代码，但是使用另一个表，则可以正常运行。这背后的原因是什么？

Answer 1

您缺少 , z.date_call 列，添加,并再次运行语句。

INSERT OVERWRITE TABLE sbx.calls_out PARTITION (date_call) 
SELECT
    z.corp,
    z.time_call,
    z.comp,
    z.serv,
    z.date_call
FROM (
    SELECT
        'a' as corp,
        1 as time_call,
        'b' as comp,
        '20190625' as date_call,
        'c' as serv
) AS z;