Does CREATE TABLE support nullable types?

in analytics query, when create table, specify field of type float.

if json empty field (""), converting float fails, , job not process data.

how specify in create table field nullable float?

or proper way submit field treated null.

this fail when job running. when test query uploaded data, not error.

all fields nullable, not need specify explicitly in create table statement.

but how float field in json ("")?

do have mixture of strings , numbers in json like:

{ "value" : 42.0 } { "value" : "42.0" }

you may want add explicit cast in query.

sql server engine.

Microsoft Azure > Azure Stream Analytics

Gain