Skip to content

InfluxQLQueryApiImpl cannot cast JsonNull #808

Description

Hi,
I'm trying to use queryJSON method of InfluxQLQueryApi.
If I have null values resulting from my query, the library fires an exception because of the cast forced to String.

As we can see from line 337 of the class:

JsonArray jvals = sobj.get("values").getAsJsonArray();
                    if (jvals != null) {
                        for(JsonElement jval : jvals) {
                            List<Object> values = new ArrayList();
                            JsonArray jae = jval.getAsJsonArray();
                            int index = 0;

                            for(JsonElement je : jae) {
                                List<String> columnKeys = new ArrayList(serie.getColumns().keySet());
                                if (this.extractor != null) {
                                    String stringVal = je.getAsString();
                                    Object ov = this.extractor.extractValue((String)columnKeys.get(index), stringVal, id, serie.getName());
                                    values.add(ov);
                                } else {
                                    values.add(je.getAsString());
                                }

                                ++index;
                            }

                            Objects.requireNonNull(serie);
                            serie.addRecord(new InfluxQLQueryResult.Series.Record(serie, values.toArray()));
                        }
                    }

When it gets the null value, the instruction String stringVal = je.getAsString(); fires the exception.

Am I doing something wrong?

Activity

NguyenHoangSon96 commented on Jan 20, 2025

@NguyenHoangSon96
Contributor

HI @leonardo-belotti-aiknow
Can you capture the exception? I need more info
Any chance that the null is the "je" 🤔

leonardo-belotti-aiknow commented on Jan 29, 2025

@leonardo-belotti-aiknow
Author

Hi @NguyenHoangSon96
sorry for late reply.

Confirming je contains "null", the exception is:

java.lang.UnsupportedOperationException: JsonNull

But how can I manage "null" values occurrences?

NguyenHoangSon96 commented on Feb 3, 2025

@NguyenHoangSon96
Contributor

Hi @NguyenHoangSon96 sorry for late reply.

Confirming je contains "null", the exception is:

java.lang.UnsupportedOperationException: JsonNull

But how can I manage "null" values occurrences?

HI @leonardo-belotti-aiknow
No problem
Regarding of this issue
I don't think it comes from the influx client library
Maybe you should check null for "je" variable or something 🤷‍♂️
A full stack trace error capture will be helpful

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Labels

No labels
No labels

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions