shamim8888 / asterixdb

Automatically exported from code.google.com/p/asterixdb
0 stars 0 forks source link

aggregation query generates a listify in the optimized plan #827

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
Reproduction:
==============

Run the following query (I also attached the DDL in defs.aql and a small 
dataset named part-m-0000).

use dataverse kereno;

//Query 8 
//========
let $list_time := for $i in dataset page_views return $i.timespent
let $list_rev := for $i in dataset page_views return $i.estimated_revenue
return {
"sum_timespent": sum($list_time),
"avg": avg($list_rev)
}

The plan shows (I also attached the full plan, see L8.txt):
            aggregate [$$6] <- [function-call: asterix:listify, Args:[%0->$$5]]
              -- AGGREGATE  |UNPARTITIONED|

Original issue reported on code.google.com by ker...@gmail.com on 20 Nov 2014 at 1:59

Attachments:

GoogleCodeExporter commented 9 years ago
When "complaining" about a listify, please also add notes on what query plan 
you are expecting from what you wrote.  Thx!

Original comment by dtab...@gmail.com on 20 Nov 2014 at 6:48

GoogleCodeExporter commented 9 years ago

Original comment by buyingyi@gmail.com on 3 Dec 2014 at 6:01

GoogleCodeExporter commented 9 years ago

Original comment by buyingyi@gmail.com on 4 Dec 2014 at 9:28