Skip to content

Cannot group-by MV column with transformation in projection #10838

@egalpin

Description

@egalpin

Assuming that myMVdateTimeCol is an MV column of type LONG, the following will fail with a NullPointerException (root cause: ProjectionOperator is used rather than GroupByOperator, where ProjectionOperator which eventually causes a call to FixedByteMVMutableForwardIndex#readDictIds which throws UnsupportedOperationException from the default impl on the MutableForwardIndex interface).

SELECT 
  TODATETIME("myMVdateTimeCol", 'e:HH:mm:ss', 'UTC') as myTransformedVal,
  count(1) as _count
FROM 
  myTable 
GROUP BY 
  myTransformedVal

However, if the same query is executed without TODATETIME in the projection, it succeeds.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions