本文介绍了无效操作:不支持 WITH RECURSIVE的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
当我在下面运行查询时,我收到消息:
When I'm running query below I get message:
[Amazon](500310) Invalid operation: WITH RECURSIVE is not supported;
谁能解释一下为什么递归函数不起作用?(我正在研究亚马逊红移)
Can someone explain me why recursive function doesn't work? (I'm working on amazon redshift)
WITH RECURSIVE r AS (
SELECT
1 AS i,
1 AS factorial
UNION
SELECT
i+1 AS i,
factorial * (i+1) as factorial
FROM r
WHERE i < 10
)
SELECT * FROM r;
推荐答案
Amazon Redshift 官方文档:不支持的 PostgreSQL 功能:
The official Amazon Redshift documentation: Unsupported PostgreSQL Features:
Amazon Redshift 不支持这些 PostgreSQL 功能.
...
...
- 递归公用表表达式
...
这篇关于无效操作:不支持 WITH RECURSIVE的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!