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:48:00 UTC
[jira] [Updated] (ASTERIXDB-3013) Would be nice to eliminate unnecessary joins of related flat views
[ https://issues.apache.org/jira/browse/ASTERIXDB-3013?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Michael J. Carey updated ASTERIXDB-3013:
----------------------------------------
Description:
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.
It seems like the join could be eliminated by matching the join condition against the PK and FK information in the view definitions (and trusting it to be correct).
was:
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.
> 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.
> It seems like the join could be eliminated by matching the join condition against the PK and FK information in the view definitions (and trusting it to be correct).
--
This message was sent by Atlassian Jira
(v8.20.1#820001)