Is your feature request related to a problem or challenge?
A follow up from #18718
I added some high-level tests in a separate branch that exercise hashing union arrays through group by, distinct, aggregation queries
Once these 2 upstream PRs in arrow land get merged, we should follow up with a couple of integration tests:
Related: #18718 (comment)
cc @adriangb @Jefffrey
Describe the solution you'd like
No response
Describe alternatives you've considered
No response
Additional context
No response