Uploaded image for project: 'Tajo'
  1. Tajo
  2. TAJO-1406

Support WITH clause without RECURSIVE

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: In Progress
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
      None

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                seungunchoe Seungun Choe
                Reporter:
                dongjoon Dongjoon Hyun
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated: