Big Data Analytics
Microsoft's Azure Data Lake is now generally available, but what does it do, and how does it work? Here's a tour around the service's tooling and capabilities, to help you understand it and get productive with it, quickly.
Now you can click the "Query a TSV file" option. Once you do, a full fledged U-SQL script will come up.
U-SQL is a dialect of the popular Structured Query Language that you can use with ADLA to query data in ADLS. This particular U-SQL script pulls data out of a TSV file using U-SQL's EXTRACT command, and it pushes the result of the query into another TSV file using the OUTPUT command.
Notice the U-SQL editor, even though it's embedded in the Azure portal, features color syntax highlighting. There's even better editor support in Visual Studio, which we'll see. But this isn't bad for the browser!
Clicking "Submit Job" (highlighted) at the top will execute the query. We'll explore that in a bit.
Caption by: Andrew Brust
Join Discussion