sql - 错误：编译语句时出错：失败：ParseException 行 1:9 不匹配输入 'from' 期望 SET 在更新语句中的 'a' 附近

Question

我试图在没有设置表属性的情况下更新表 1，并且出现以下错误“不匹配的输入 'from' 期望 SET 靠近 'a'”

UPDATE a from table1 a ,(SELECT  
            DISTINCT SUBS SUB,
            Min(LINE) Over(PARTITION BY CONTRACT) LINE
        FROM 
            table1 K
        INNER JOIN 
        (
            SELECT
                CUSTOMER,
                FROM,
                TO,
                CONTRACT
            FROM
                Number_Change a
            JOIN 
                CONTRACTS b  ON a.CONTRACT=b.ID
        ) CH_SUB
        ON K.CUSTOMER = CH_SUB.CUSTOMER where (SUBO = Substr(FROM,4) OR SUBO = Substr(TO,4))
    )SRC 
     set  a.LINE = SRC.LINE,  TEC_UPDATE_DTTM = Current_Timestamp 
     WHERE SUBS = SUB;

标签： sqlhadoophivehiveql