[GitHub] [pinot] Jackie-Jiang commented on pull request #9078: Throw an exception when MV columns are the first order-by expression in selection order-by queries

[GitBox <gi...@apache.org>]

Jackie-Jiang commented on PR #9078:
URL: https://github.com/apache/pinot/pull/9078#issuecomment-1191760847

   Good catch!
   I'd suggest doing it slightly different which can handle more general cases:
   1. In `MinMaxValueBasedSelectionOrderByCombineOperator.MinMaxValueContext`, check if `dataSourceMetadata.isSingleValue()` and put `null` if it is not single valued so that we don't get exception
   2. In `SelectionOrderByOperator.getComparator()`, we have access to the actual metadata of the transformed result, and we may perform the check if we don't want MV to be ordered (currently it skips MV expressions, but IMO it is okay to throw exception to prevent unexpected behavior)


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org