在apache drill中，我们如何使用CTE with子句执行递归查询？
Apache Drill不支持递归查询。使用说明部分：
Drill can only reference a table defined by a WITH clause subquery in the scope of the SELECT query that the WITH clause begins. For example, you can reference such a table in the FROM clause of a subquery in the SELECT list, WHERE clause, or HAVING clause. You cannot use a WITH clause in a subquery and reference its table in the FROM clause of the main query or another subquery.
尝试在不递归的情况下重写查询。还有一个关于开发邮件列表的讨论，它可能有有用的建议或解决方案。