[jira] [Created] (TAJO-1406) Support WITH clause without RECURSIVE

["Dongjoon Hyun (JIRA)" <ji...@apache.org>]

Dongjoon Hyun created TAJO-1406:
-----------------------------------

             Summary: Support WITH clause without RECURSIVE
                 Key: TAJO-1406
                 URL: https://issues.apache.org/jira/browse/TAJO-1406
             Project: Tajo
          Issue Type: Bug
          Components: parser, planner/optimizer
            Reporter: Dongjoon Hyun


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.

{code:sql}
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;
{code}

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



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)