Jackie-Jiang commented on issue #11543: URL: https://github.com/apache/pinot/issues/11543#issuecomment-1728653363
> Uff that is a very misleading parsing, specially given the fact that the server knows that this field is a string: shouldn't the schema play a role here? If I am filtering on a string column using a numeral that should be an error right? or even better the field being used as filter should be interpreted as a string. AFAIK, no DB can handle this because that is the standard way of parsing it. We can make pinot fail the query if it detects type mismatch (this might be the standard SQL behavior), but that is an incompatible change because I can imagine people might ingest numbers as string type, and filter string with number -- 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-unsubscr...@pinot.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org
