8 U-SQL for complex analytics

This chapter covers

  • Creating reusable data access objects with U-SQL views, table-valued functions, and tables

  • Staging data for reuse with U-SQL tables

  • Using window functions for aggregation queries

  • Adding custom inline C# functions to U-SQL scripts

In the last chapter, you learned how to create an Azure Data Lake Analytics (ADLA) account and how to build and run simple jobs. In this chapter, you’ll build on that knowledge by writing more complex queries. Because U-SQL scripts compile into C# programs, you can use many C# features within U-SQL expressions.

  • You’ll compare methods of structuring U-SQL for reuse, including creating indexed data stores in the U-SQL Catalog.

  • You’ll use C# language features ...

Get Azure Storage, Streaming, and Batch Analytics now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.