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: [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]
