Nulls and nothing RRS feed

  • Question

  • Are there any consolidated guidelines on proper implementation of data with nulls across different formats in ADLS? Thinking about Parquet, Tabular Text, CSV, Avro, and USQL compatible formats. Thanks in advance.

    Monday, April 9, 2018 10:44 PM

All replies

  • When you are trying to load from input and if you expect NULL for a particular field, you can add question mark next to data type like below:

    @log = Extract date string,

    count int?,

    username string

    This says that the variable count is nullable. String are nullable by default

    Please let me know, if you have any other questions
    Thursday, May 3, 2018 7:57 PM