Will U-SQL support preprocessor like Local and external parameter(@@)

Question

Scope support preprocessor LOCAL and external parameter, I found it is very useful, but I couldn't find them in U-SQL.

Thanks.

Answer 1

While U-SQL evolved from SCOPE, there are many language feature differences. One of them is that we removed the preprocessing step that SCOPE had for security reasons (SQL-injection attacks).

U-SQL provides external parameters using the standard parameter/variable naming, e.g., @parameter. You can even default an external parameter (and document it in your script) with

DECLARE EXTERNAL @parameter = "default";