Azure Data Lake U-SQL July Updates

As part of the Azure Data Lake Analytics and U-SQL July refresh released earlier this month, we released a couple of new features, are deprecating some confusing syntax and fixed several bugs:

• Breaking Changes
  • Start of Deprecation of {col:*} File Set pattern
• Major U-SQL Bug Fixes
  • Space encoding in file paths are fixed
  • Data corruption due to non-determinism during writing into a U-SQL table is fixed
• New U-SQL capabilities
  • PRESORT on REDUCE is now supported to provide the ability to do custom ordered aggregators/reducers
  • U-SQL now supports adding and removing columns on U-SQL tables with ALTER TABLE ADD/DROP COLUMN
  • U-SQL now supports referencing custom assembly objects such as C# user-defined functions inside DECLARE statement
  • U-SQL now supports a USING directive that allows shortening U-SQL custom code object references
  • Visual Studio ADL Tool Provides Local Failed Vertex Debug for Self-service Debugging

You can find more details with examples in the release notes on our github site.