[TAJO-1406] Support WITH clause without RECURSIVE

• Type: New Feature
• Status: In Progress
• Priority: Major
• Resolution: Unresolved
• Component/s: Planner/Optimizer, SQL Parser
• Assignee: Seungun Choe
• Reporter: Dongjoon Hyun
• Created: 16/Mar/15 22:24
• Updated: 17/Aug/15 02:01

Description

WITH clause is widely used expression in SQL language, for e.g., TPC-DS Q1, Q2, Q4, Q5, Q11, Q14, Q23, Q24, Q30, Q31, Q33, Q39, Q47, Q51, Q54, Q56, Q57, Q58, Q59, Q60, Q64, Q74, Q75, Q77, Q78, Q80, Q81, Q83, Q95, Q97.

Refer the following queries in http://www.postgresql.org/docs/9.4/static/queries-with.html.

WITH regional_sales AS (
        SELECT region, SUM(amount) AS total_sales
        FROM orders
        GROUP BY region
     ), top_regions AS (
        SELECT region
        FROM regional_sales
        WHERE total_sales > (SELECT SUM(total_sales)/10 FROM regional_sales)
     )
SELECT region,
       product,
       SUM(quantity) AS product_units,
       SUM(amount) AS product_sales
FROM orders
WHERE region IN (SELECT region FROM top_regions)
GROUP BY region, product;

In this issue, WITH RECURSIVE does not support. It should be handled as a separate issue.

Issue Links

• duplicates: TAJO-1770 WITH clause should be supported