How to check null values in JSON property in stream analytics?

Question

I am Passing the following Json input from Eventhub to Stream Analytics.

{"meter_totalcycleenergy":null,"Test2": 20}, {"meter_totalcycleenergy":40,"Test2":20}

But the job is failing stating the error.

Encountered error trying to write 1 event(s): Cannot convert from property 'meter_totalcycleenergy' of type 'System.String' to column 'meter_totalcycleenergy' of type 'System.Single'.

Error Image How to handle such conditions.

I think Json nulls are not exactly SQL NULLs, so what would be the proper way to check for null values in a query?

Datatype of meter_totalcycleenergy is float in my database.

Adding a IS NOT NULL will works

shree
– shree

2022-03-14 06:33:40 +00:00
Commented Mar 14, 2022 at 6:33 — shree
– shree, Commented Mar 14, 2022 at 6:33

Hyder S M · Accepted Answer · 2019-03-08 21:07:19Z

1

You can use is not null. For eg:

select *
from input
where meter_totalcycleenergy is not null

answered Mar 8, 2019 at 21:07

Hyder S M

1155 bronze badges

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

Collectives™ on Stack Overflow

How to check null values in JSON property in stream analytics?

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