Jackie-Jiang commented on PR #12401: URL: https://github.com/apache/pinot/pull/12401#issuecomment-1954666322
We don't need to follow single-stage engine convention here. In multi-stage engine, we try to follow the standard SQL behavior, where encoding should be provided when converting binary to string. Alternatively, the input value can be directly declared as bytes, e.g. `X'80c062bf21bba70a9b404e969de0503750` (note the leading `X` which indicates the value is hex encoded bytes). Here are the PostgreSQL behavior for binary for reference: https://www.postgresql.org/docs/current/datatype-binary.html, https://www.postgresql.org/docs/current/functions-binarystring.html -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
