Tera Data:缺少/无效的SQL语句(3810)

Question

我有这个简单的merge语句，但它在运行时失败了。

任何建议都是值得感谢的。

MERGE INTO HP.SampleAll as A 
USING ( 
        select ALIGNED
        from HP.Sample2
       ) as B
ON (A.md_nbr = B.md_nbr)
WHEN MATCHED THEN UPDATE
    SET ALIGNED = A.ALIGNED ;

Answer 1

错误3810表明该列不存在。

md_nbr不存在于您的子查询B中-因为您没有选择它。

也许一个解决方案是：

MERGE INTO HP.SampleAll as A 
USING ( 
        select ALIGNED, md_nbr
        from HP.Sample2
       ) as B
ON (A.md_nbr = B.md_nbr)
WHEN MATCHED THEN UPDATE
 SET ALIGNED = A.ALIGNED ;

或者仅仅是USING HP.Sample2 as B