TPC-H q8 and q9 Illegal State Exception

br1ghtyang / asterixdb

Automatically exported from code.google.com/p/asterixdb

0 stars 0 forks source link

TPC-H q8 and q9 Illegal State Exception #558

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago

To reproduce the issue, run the tpch q8 or the tpch q9 in the web interface on 
SF=1 with 3 nodes, the default configuration, and one IO device.

After attempting to run either query, the user will get the following error 
message "Could not write frame 
(AbstractOneInputOneOutputOneFramePushRuntime.appendToFrameFromTupleBuilder). 
[IllegalStateException]".  The fixed version of q8 is attached.  Thanks in 
advance for the help.

Original issue reported on code.google.com by cmcintyr...@gmail.com on 8 Jul 2013 at 9:43

Attachments:

q8.aql.txt

GoogleCodeExporter commented 8 years ago

Original comment by westm...@gmail.com on 8 Jul 2013 at 9:47

Changed title: tpc-h q8 and q9 Illegal State Exception

GoogleCodeExporter commented 8 years ago

Original comment by westm...@gmail.com on 19 Jul 2013 at 4:36

Changed title: TPC-H q8 and q9 Illegal State Exception

GoogleCodeExporter commented 8 years ago

[deleted comment]

GoogleCodeExporter commented 8 years ago

I've reduced q8 and q9 to q8_mod.aql and q9_mod.aql (both attached), and they 
get the same error when run under the same conditions as the original queries.  
Running subqueries of the attached queries does not produce the error.

Original comment by cmcintyr...@gmail.com on 29 Jul 2013 at 6:34

Attachments:

GoogleCodeExporter commented 8 years ago

Here are the optimized logical plans for q08, q09, q08_mod, and q09_mod.

Original comment by cmcintyr...@gmail.com on 29 Jul 2013 at 6:36

Attachments:

GoogleCodeExporter commented 8 years ago

This is in the plan for q8:

unnest $$9 <- function-call: asterix:scan-collection, Args:[%0->$$62]
-- UNNEST  |PARTITIONED|
  exchange 
  -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
    group by ([]) decor ([]) {
              aggregate [$$62] <- [function-call: asterix:listify, Args:[function-call: asterix:closed-record-constructor, Args:[AString: {o_orderdate}, %0->$$136, AString: {l_partkey}, %0->$$140, AString: {l_discount}, %0->$$141, AString: {l_extendedprice}, %0->$$142, AString: {l_suppkey}, %0->$$143]]]
              -- AGGREGATE  |LOCAL|
                select (function-call: algebricks:not, Args:[function-call: algebricks:is-null, Args:[%0->$$124]])
                -- STREAM_SELECT  |LOCAL|
                  nested tuple source
                  -- NESTED_TUPLE_SOURCE  |LOCAL|
           }
    -- PRE_CLUSTERED_GROUP_BY[]  |PARTITIONED|
      exchange 

It seems that the unnest should cancel the groupby with listify.

Original comment by westm...@gmail.com on 29 Jul 2013 at 10:24

GoogleCodeExporter commented 8 years ago

Original comment by westm...@gmail.com on 2 Aug 2013 at 5:55

Added labels: Priority-Critical
Removed labels: Priority-Medium

GoogleCodeExporter commented 8 years ago

asterixdb: yingyi/asterix_fix
hyracks: yingyi/fullstack_fix

Original comment by buyingyi@gmail.com on 7 Aug 2013 at 8:05

Changed state: FixedInBranch

GoogleCodeExporter commented 8 years ago

Original comment by buyingyi@gmail.com on 8 Aug 2013 at 5:37

Changed state: Fixed

GoogleCodeExporter commented 8 years ago

Original comment by westm...@gmail.com on 9 Aug 2013 at 6:04

Changed state: Verified