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?