Array_agg() does not work

[Ken]

I am using

Build
25.2.0-202410241428100111-a963b970
Edition
Community Edition
Build Time
10/24/2024 14:33:07
Change Hash
a963b9700065580085db55774de40257e6ea70cd
Change Time
10/24/2024 14:27:52

When I ran this SQL

with data as (

select 1 as some_col
UNION ALL

select 2
)

select array_agg(some_col) from data

I got this error

IllegalArgumentException: Error: detected inconsistent fixedBlocks in hashtable after unsuccessful batch extention

[quangbilly79]

@Ken

with data as (

select 1 as some_col
UNION ALL

select 2
)

select array_agg(some_col) from data

Mine still works fine (24.3.2 Community Edition + Yarn Engine)

[balaji.ramaswamy]

@Ken Mine works too on 26.0.2. Does it always happen? Can you try and upgrade and retry? Can we also get the job profile of the failed job?