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

Reply via email to