我有一个使用 Spectrum 表的 CTE 查询。当我尝试将 CTE 与自身结合时:
WITH foo AS (
SELECT col1
FROM spectrum.bar
)
SELECT * FROM foo UNION ALL
SELECT * FROM foo;
我收到以下错误:
[XX000][500310] [Amazon](500310) Invalid operation: Relation "spectrum_foo_58abe8db83a3e" already exists Details: ----------------------------------------------- error: Relation "spectrum_foo_58abe8db83a3e" already exists code: 13 ..
这是一个已知问题和/或有什么方法可以解决它(不涉及为每个联合粘贴原始查询)?