U-SQL datatype in IN clause


  • I am trying to pass a parameter to U-SQL for use in an IN clause, but keep getting type errors either just by using U-SQL commands or when trying to pass String[] List<String> SqlArray etc from a C# function

    DECLARE EXTERNAL @PortfolioFilter string = "13,27,29,30,31";

            @result ="SELECT .....

            FROM @input WHERE PortfolioId IN (@PortfolioFilter.Split(','));

    Error:Error compiling C# code: "Operator '==' cannot be applied to operands of type 'string' and 'string[]'"

    What types are supported in this part of the query?

    Monday, January 2, 2017 11:56 AM

All replies