A new SQL based language for Azure: U-SQL

Posted: (EET/GMT+2)

 

Microsoft Big Data analysis on the Azure platform is progressing, and lately Microsoft announced the availability of the Data Lake functionality. There's also an announcement about a new SQL-like programming and query language called U-SQL that allows you to query various data sources using familiar syntax and commands.

Here is an example working the CSV files and tweet calculations:

@t = EXTRACT date string,
             time string,
             author string,
             tweet string
     FROM "/input/MyTwitterHistory.csv"
     USING Extractors.Csv();

@res = SELECT author, COUNT(*) AS tweetcount
       FROM @t
       GROUP BY author;

OUTPUT @res TO "/output/MyTwitterAnalysis.csv"
ORDER BY tweetcount DESC
USING Outputters.Csv();

I'd guess U-SQL based project types would soon be available in Visual Studio. Perhaps as an update to the Azure tooling in Visual Studio?