Usql script getting error for ?. operator in where clause RRS feed

  • Question

  • does u-sql doesn't support ?.  operator. 

    i have a where clause where if value is not null, i have to convert to uppercase. 

    i tried in left join of table1 and table2

    WHERE table1.col1?.ToUpper() != table2.Col2?.Toupper()

    it was failing, so finally i have to change it to

    WHERE (table1.col1 == null? null : table1.col1.ToUpper()) != (table2.col1 == null? null : table2.col1.ToUpper())

    MSDN says u-sql supports all C# operators (except few, and ?. is not mentioned in non-supported list)



    Monday, October 16, 2017 9:41 PM


  • U-SQL uses a slightly older version of the C# language that didn't yet have the .? operator. In the future U-SQL will support this syntax.
    Wednesday, October 25, 2017 10:07 PM