无效操作:不支持 WITH RECURSIVE

本文介绍了无效操作:不支持 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 功能. ... ...- 递归公用表表达式 ...

These PostgreSQL features are not supported in Amazon Redshift. ... ... - Recursive common table expressions ...