Affects Version/s: 1.17.0
Fix Version/s: None
Component/s: Functions - Drill
AS drill doesn't allow to GROUP BY nor DISTINCT nor ORDER BY complex type, it may appears as a solution to use any_value aggregate function to do some works.
But some problems appears:
With a dataset of 223664 rows like:
With the own UDF function to_string that only do
Sometimes the error can be different (details in attachment): java.lang.IndexOutOfBoundsException: index: 1634787136, length: 7629168 (expected: range(0, 8388608))
And before producing the error, the output show some results like below
And this result is not correct because field Tags is empty although this is never the case in the source file.
So maybe there is a problem with the aggregate function any_value.