[ https://issues.apache.org/jira/browse/ASTERIXDB-2913?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Michael J. Carey updated ASTERIXDB-2913: ---------------------------------------- Description: Consider the following query using the Don Chamberlin book data: USE DonCData; WITH flat_orders AS (SELECT orderno, custid, order_date, ship_date FROM orders), flat_items AS (SELECT o.orderno, i.* FROM orders o, o.items i) SELECT fo.*, fi.* FROM flat_orders fo, flat_items fi WHERE fo.orderno = fi.orderno; Right now this query leads to two scans of orders - one for flat_orders and one for flat_items - followed by a join of the two. > Need "break up to make up" rewrite rule for unnested data > --------------------------------------------------------- > > Key: ASTERIXDB-2913 > URL: https://issues.apache.org/jira/browse/ASTERIXDB-2913 > Project: Apache AsterixDB > Issue Type: Bug > Reporter: Michael J. Carey > Priority: Major > > Consider the following query using the Don Chamberlin book data: > USE DonCData; > WITH flat_orders AS (SELECT orderno, custid, order_date, ship_date FROM > orders), > flat_items AS (SELECT o.orderno, i.* FROM orders o, o.items i) > SELECT fo.*, fi.* FROM flat_orders fo, flat_items fi > WHERE fo.orderno = fi.orderno; > Right now this query leads to two scans of orders - one for flat_orders and > one for flat_items - followed by a join of the two. -- This message was sent by Atlassian Jira (v8.3.4#803005)