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

["Michael J. Carey (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/ASTERIXDB-3013?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

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

    Assignee: Dmitry Lychagin

> 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
>            Assignee: Dmitry Lychagin
>            Priority: Major
>             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)