在databricks中使用merge语句时出现以下错误：
MERGE INTO t1 USING t2 ON t1.[c1] = t2.[c1] AND t1.[c2] <> t2.[c2] WHEN MATCHED THEN UPDATE SET t1.[c1] = t2.[c2]
错误：sql语句中出错：parseexception:外部输入你能帮个忙吗？
vlf7wbxs1#
MERGE database.schema.tablename as t1 USING <the Query you want to run or the database.schema.tablename> as t2 ON (t1.[c1] = t2.[c1] AND t1.[c2] != t2.[c2]) WHEN MATCHED THEN UPDATE SET t1.[c1] = t2.[c2]
试试上面的建议
1条答案
按热度按时间vlf7wbxs1#
试试上面的建议