Tips for SQL developers
Lots of people come to U-SQL from SQL and ask how U-SQL accomplishes things they are familiar with in SQL. A great example in creating an uppercase string.
Given, what we' ve covered so far A SQL developer will expect to write the following in U-SQL
@output = SELECT UPPER( Region ) AS NewRegion FROM @searchlog;
Unfortunately, said developer will be disappointed to find out that U-SQL has no
UPPER() method. The C# developer, on the other hand, knows what to do: use the string type's intrinsic
@output = SELECT Region.ToUpper() AS NewRegion FROM @searchlog;