You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@asterixdb.apache.org by "Michael J. Carey (Jira)" <ji...@apache.org> on 2022/02/09 07:46:00 UTC

[jira] [Created] (ASTERIXDB-3013) Would be nice to eliminate unnecessary joins of related flat views

Michael J. Carey created ASTERIXDB-3013:
-------------------------------------------

             Summary: Would be nice to eliminate unnecessary joins of related flat views
                 Key: ASTERIXDB-3013
                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-3013
             Project: Apache AsterixDB
          Issue Type: Improvement
          Components: COMP - Compiler
    Affects Versions: 0.9.7
            Reporter: Michael J. Carey
             Fix For: 0.9.8
         Attachments: doncdata.sqlpp, doncdataviews.sqlpp.txt

The query plan for the following query against flat view has an unnecessary join that would be good to eliminate!  (This might be a good getting-acquainted project for a person wanting to learn about the query rewriting aspect of the SQL++ compiler.)

USE DonCData; 
SELECT o.*, i.*
FROM orders_view o, items_view i
WHERE o.orderno = i.orderno;

The SQL++ materials to set up the dataverse and its datasets [^doncdata.sqlpp] and views [^doncdataviews.sqlpp.txt]are attached.



--
This message was sent by Atlassian Jira
(v8.20.1#820001)