You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by "monicaluodialpad (via GitHub)" <gi...@apache.org> on 2023/05/31 15:13:25 UTC

[GitHub] [pinot] monicaluodialpad opened a new issue, #10824: Getting `java.lang.NullPointerException` for a query.

monicaluodialpad opened a new issue, #10824:
URL: https://github.com/apache/pinot/issues/10824

   Getting
   ```
   ProcessingException(errorCode:150, message:SQLParsingError:
   java.lang.NullPointerException: _Fields.STRING_VALUE
   	at java.base/java.util.Objects.requireNonNull(Objects.java:246)
   	at org.apache.pinot.common.request.Literal.setStringValue(Literal.java:601)
   	at org.apache.pinot.common.utils.request.RequestUtils.getLiteralExpression(RequestUtils.java:124)
   	at org.apache.pinot.sql.parsers.CalciteSqlParser.toExpression(CalciteSqlParser.java:676))
   ```
   when I wanted to try some non-aggregated functions
   ```
   SELECT CASE WHEN "some_field" IS NOT NULL THEN "some_field" ELSE NULL END AS "some_alias"
   FROM "dx_sessions"
   ```
   The type of "some_field" can be String, Int, Float, List etc.


-- 
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-unsubscribe@pinot.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org

Re: [I] Getting `java.lang.NullPointerException` for a query. [pinot]

Posted by "monicaluodialpad (via GitHub)" <gi...@apache.org>.
monicaluodialpad commented on issue #10824:
URL: https://github.com/apache/pinot/issues/10824#issuecomment-1751436092

   Closing this as it is working on pinot 1.0.0


-- 
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-unsubscribe@pinot.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org

Re: [I] Getting `java.lang.NullPointerException` for a query. [pinot]

Posted by "monicaluodialpad (via GitHub)" <gi...@apache.org>.
monicaluodialpad closed issue #10824: Getting `java.lang.NullPointerException` for a query.
URL: https://github.com/apache/pinot/issues/10824


-- 
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-unsubscribe@pinot.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org

[GitHub] [pinot] shenyu0127 commented on issue #10824: Getting `java.lang.NullPointerException` for a query.

Posted by "shenyu0127 (via GitHub)" <gi...@apache.org>.
shenyu0127 commented on issue #10824:
URL: https://github.com/apache/pinot/issues/10824#issuecomment-1571264325

   If you run a Pinot that is built on HEAD, you will not get this error.
   
   Details:
   - You were running a Pinot that is a few months old. (The line 601 of `Literal.java` is `Objects.requireNonNull` means it is before https://github.com/apache/pinot/pull/10217).
   - I tested your query using a Pinot built on HEAD and it worked. You may need to add `OPTION(enableNullHandling=true)` in the query.


-- 
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-unsubscribe@pinot.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org

[GitHub] [pinot] shenyu0127 commented on issue #10824: Getting `java.lang.NullPointerException` for a query.

Posted by "shenyu0127 (via GitHub)" <gi...@apache.org>.
shenyu0127 commented on issue #10824:
URL: https://github.com/apache/pinot/issues/10824#issuecomment-1574625387

   - If you put a `;` after your `SET` statement, your query will be parsed correctly.
   - Your query will not work in v0.12.1.
      - The `IS NOT NULL` feature is added in https://github.com/apache/pinot/pull/10594, which is not included in v0.12.1. 
      - If you build a Pinot from source on HEAD (https://docs.pinot.apache.org/basics/getting-started/running-pinot-locally), your query will work. Or you can wait for the next Pinot release to include this feature.


-- 
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-unsubscribe@pinot.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org

[GitHub] [pinot] Jackie-Jiang commented on issue #10824: Getting `java.lang.NullPointerException` for a query.

Posted by "Jackie-Jiang (via GitHub)" <gi...@apache.org>.
Jackie-Jiang commented on issue #10824:
URL: https://github.com/apache/pinot/issues/10824#issuecomment-1571177519

   @shenyu0127 Can you please take a look?


-- 
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-unsubscribe@pinot.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org

[GitHub] [pinot] monicaluodialpad commented on issue #10824: Getting `java.lang.NullPointerException` for a query.

Posted by "monicaluodialpad (via GitHub)" <gi...@apache.org>.
monicaluodialpad commented on issue #10824:
URL: https://github.com/apache/pinot/issues/10824#issuecomment-1574591699

   @shenyu0127 Thank you for your reply
   * May I ask the full query example with `OPTION(enableNullHandling=true)`? We have turned it on in table configuration. Is it good enought?
   * Is the latest version of pinot 0.12.1 ? Unfortunately I still get the error.


-- 
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-unsubscribe@pinot.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org