itschrispeck commented on issue #14433: URL: https://github.com/apache/pinot/issues/14433#issuecomment-2477467201
Current behavior is that the value is an empty string e.g. `select col1 from tbl where col1 is not null` gives: ``` "resultTable": { "dataSchema": { "columnNames": [ "col1" ], "columnDataTypes": [ "STRING" ] }, "rows": [ [ "" ], ... } ``` Conversely, `is null` does not match any docs. I'd also prefer avoiding a new config, I wasn't sure if this should be considered a bug since changing the behavior would be backwards incompatible. -- 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