facebookincubator / velox

A C++ vectorized database acceleration library aimed to optimizing query engines and data processing systems.
https://velox-lib.io/
Apache License 2.0
3.28k stars 1.08k forks source link

checksum agg fails: PrestoHasher.cpp:357 ... Vector type: BIGINT != initialized type: INTERVAL DAY TO SECOND #10210

Open mbasmanova opened 2 weeks ago

mbasmanova commented 2 weeks ago

Bug description

https://github.com/facebookincubator/velox/actions/runs/9522147066/job/26251627440?pr=10202

I20240614 14:08:52.780838   585 AggregationFuzzerBase.cpp:410] Executing query plan: 
-- Aggregation[3][FINAL [g0] a0 := checksum("a0")] -> g0:ARRAY<INTEGER>, a0:VARBINARY
  -- LocalPartition[2][REPARTITION HASH(g0)] -> g0:ARRAY<INTEGER>, a0:BIGINT
    -- Aggregation[1][PARTIAL [g0] a0 := checksum(ROW["c0"])] -> g0:ARRAY<INTEGER>, a0:BIGINT
      -- TableScan[0][table: hive_table] -> c0:MAP<TIMESTAMP,INTERVAL DAY TO SECOND>, g0:ARRAY<INTEGER>
E20240614 14:08:52.783638  3824 Exceptions.h:67] Line: /__w/velox/velox/velox/velox/functions/prestosql/aggregates/PrestoHasher.cpp:357, Function:hash, Expression
Error is : 
E20240614 14:05:56.807744   585 Exceptions.h:67] Line: /__w/velox/velox/velox/velox/exec/fuzzer/PrestoQueryRunner.cpp:900, Function:fetchNext, Expression: response.status_code == 200 (0 vs. 200) GET from http://127.0.0.1:8080/v1/statement/queued/20240614_210555_00002_8mg5i/2?slug=x870161fcc51341288009412767326477&binaryResults=true failed: Operation timed out after 1001 milliseconds with 0 bytes received, Source: RUNTIME, ErrorCode: INVALID_STATE
E20240614 14:06:20.881053   585 Exceptions.h:67] Line: /__w/velox/velox/velox/velox/exec/fuzzer/PrestoQueryRunner.cpp:900, Function:fetchNext, Expression: response.status_code == 200 (0 vs. 200) GET from http://127.0.0.1:8080/v1/statement/queued/20240614_210619_00022_8mg5i/2?slug=x147560916c4f476ca4da32af5d592cb1&binaryResults=true failed: Operation timed out after 1000 milliseconds with 0 bytes received, Source: RUNTIME, ErrorCode: INVALID_STATE
E20240614 14:08:52.783638  3824 Exceptions.h:67] Line: /__w/velox/velox/velox/velox/functions/prestosql/aggregates/PrestoHasher.cpp:357, Function:hash, Expression: *vector->type() == *type_ Vector type: BIGINT != initialized type: INTERVAL DAY TO SECOND, Source: RUNTIME, ErrorCode: INVALID_STATE
E20240614 14:08:52.784004  3823 Exceptions.h:67] Line: /__w/velox/velox/velox/velox/functions/prestosql/aggregates/PrestoHasher.cpp:357, Function:hash, Expression: *vector->type() == *type_ Vector type: BIGINT != initialized type: INTERVAL DAY TO SECOND, Source: RUNTIME, ErrorCode: INVALID_STATE

System information

n/a

Relevant logs

No response

mbasmanova commented 2 weeks ago

CC: @kgpai @kagamiori

kgpai commented 2 weeks ago

presto-sot-aggregate-fuzzer-failure-artifacts.zip Find attached zip that contains the plan node to reproduce the error.

kgpai commented 2 weeks ago

Use AggregationFuzzerTest to reproduce and fix : https://facebookincubator.github.io/velox/develop/testing/fuzzer.html#how-to-run .