Geek Answers Handbook

Why is Group by Grouping Sets running on SQL Server and not in the Azure SQL Data Warehouse?

Grouping by groups, cubes, and rollups runs on SQL Server, but they are not yet supported in the Azure SQL Data Warehouse. The same thing happens with some well-ordered analysts who use the "Rows Unbounded Preceding" keywords. I also noticed that Azure SQL Data Warehouse lacks unique clustered indexes, as well as primary and foreign key restrictions. Will it be the first release or is there another reason?

+4
source share
1 answer

Azure SQL Data Warehouse is a large-scale version of SQL Server for MPP. Azure SQL Data Warehouse just introduced a preview yesterday (more details here http://aka.ms/sqldw ), so features like primary and foreign key restrictions and ROW_NUMBER () OVER (UNBOUNDED PRECEDING ... will be added when the service goes to general availability.

Azure SQLDW today supports ROW_NUMBER () OVER (PARTITION BY ...). This applies to other aggregate window functions, such as SUM () OVER ().

You can view a list of supported syntaxes on the Azure SQL Data Warehouse documentation site: https://azure.microsoft.com/documentation/articles/sql-data-warehouse-overview-reference/

+2
source

More articles:


All Articles