2 回答
- 最新
- 投票最多
- 评论最多
0
Hi,
Currently Redshift MERGE statements do not allow for the source table to be a view, subquery, or CTE (created by a WITH statement). If you need to perform some filtering on the source table before applying the MERGE you will need to create a permanent or temporary table to be used as the source.
Alternatively you can use UPDATE and INSERT statements.
-1
I would just use a WITH clause before the merge to filter the source table before the merge.
相关内容
- AWS 官方已更新 3 年前
- AWS 官方已更新 2 年前
- AWS 官方已更新 2 年前