BigQuery Java API - Cannot Send Null For TableRow Value

Question

I am trying to set values on BigQuery table using java big query api but its throwing NullPointerException (java.lang.NullPointerException: null value in entry: popup=null ) every time I send the null value.

The null value should be completely acceptable since my Mode is NULLABLE on schema itself. I have bunch of other fields that have null value on them.

Any suggestion on this issue would be really helpful for me, I am stuck no where due to this.

Note : I may ignore and not set those fields having null values on them but that is not the solution I am looking for. My piece of code is below:

TableRow row = new TableRow();
                row.set("ip", "test");
                row.set("popup", null);

Graham Polley · Accepted Answer · 2017-04-13 03:26:42Z

4

Don't explicitly set the value to null. Simply ignore it. If it's not present in the payload to BigQuery, it will be set to null. You will not be able to set it to null anyway, because the API is checking for null parameters, and you can't change that behaviour.

So, do this instead:

TableRow row = new TableRow();
row.set("ip", "test");

answered Apr 13, 2017 at 3:26

Graham Polley

14.8k9 gold badges54 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

BigQuery Java API - Cannot Send Null For TableRow Value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related