[jira] [Created] (ASTERIXDB-3016) Failure in hash groupby: Failed to insert a new buffer into the aggregate operator

["Dmitry Lychagin (Jira)" <ji...@apache.org>]

Dmitry Lychagin created ASTERIXDB-3016:
------------------------------------------

             Summary: Failure in hash groupby: Failed to insert a new buffer into the aggregate operator
                 Key: ASTERIXDB-3016
                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-3016
             Project: Apache AsterixDB
          Issue Type: Bug
          Components: RT - Runtime
    Affects Versions: 0.9.6
            Reporter: Dmitry Lychagin
            Assignee: Dmitry Lychagin
             Fix For: 0.9.8


Load the data as follows:
{noformat}
drop dataverse tpcds if exists;
create dataverse tpcds;
use tpcds;
create dataset item(i_item_sk string not unknown) open type primary key i_item_sk;
create dataset inventory(inv_date_sk string not unknown, inv_item_sk string not unknown,
  inv_warehouse_sk string not unknown) open type primary key inv_date_sk, inv_item_sk, inv_warehouse_sk;
{noformat}
{noformat}
use tpcds;
set `import-private-functions` `true`;
insert into item (select value object_remove(t, "table_name") from tpcds_datagen("item", 0.5) t);
insert into inventory (select value object_remove(t, "table_name") from tpcds_datagen("inventory", 0.5) t);
{noformat}
Run the following query:
{noformat}
SELECT  i.i_product_name, AVG(inv.inv_quantity_on_hand) qoh
FROM  inventory inv, item i
WHERE inv.inv_item_sk /*+hash-bcast*/ = i.i_item_sk
/*+ hash */ GROUP BY i.i_product_name
 ORDER BY qoh, i.i_product_name
LIMIT 1;
{noformat}
The query fails with:
{noformat}
org.apache.hyracks.api.exceptions.HyracksDataException: Failed to insert a new buffer into the aggregate operator!
        at org.apache.hyracks.dataflow.std.group.external.ExternalHashGroupBy.insert(ExternalHashGroupBy.java:57) ~[classes/:?]
        at org.apache.hyracks.dataflow.std.group.external.ExternalGroupWriteOperatorNodePushable.buildGroup(ExternalGroupWriteOperatorNodePushable.java:175) ~[classes/:?]
        at org.apache.hyracks.dataflow.std.group.external.ExternalGroupWriteOperatorNodePushable.doPass(ExternalGroupWriteOperatorNodePushable.java:146) ~[classes/:?]
        at org.apache.hyracks.dataflow.std.group.external.ExternalGroupWriteOperatorNodePushable.initialize(ExternalGroupWriteOperatorNodePushable.java:108) ~[classes/:?]
{noformat}
Also the test framework prints the following error:
{noformat}
java.lang.AssertionError: There are 7 leaked run files.
{noformat}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)