The Group By Grouping Sets, Cube and Rollup work on SQL Server, but they don't appear to be supported yet on the Azure SQL Data Warehouse. The same goes with some Ordered Analytics that use the keywords "Rows Unbounded Preceding". I also noticed there was no Unique Clustered Indexes on the SQL Azure Data Warehouse along with Primary and Foreign Key constraints. Is this just going to be in the first release or is there another reason?
Why does Group by Grouping Sets work on SQL Server and not on the Azure SQL Data Warehouse?
627 views Asked by Thomas Coffing At
2
There are 2 answers
Related Questions in SQL
- SQL schema for a fill-in-the-blank exercise
- Hibernate: JOIN inheritance question - why the need for two left joins
- What's supposed to be the problem in this query?
- Compare fields in two tables
- How to change woocomerce or full wordpress currency with value from USD to AUD
- Dynamic query creation with Array like implementation
- SQL query to get student enrolled in this month in a course - Moodle
- SQL LAG() function returning 0 for every row despite available previous rows
- Convert C# DateTime.Ticks to Bigquery DateTime Format
- Use row values from another table to select them as columns and establish relations between them (pivot table)
- SQL: Generate combination table based on source and destination column from same table
- how to use system's environnement variables in sql script
- PHP fetchAll on JOIN
- Multitable joining in Sql
- How to display name starting from 'z' by using BETWEEN cmd only?
Related Questions in AZURE
- How to update to the latest external Git in Azure Web App?
- I need an azure product that executes my intensive ffmpeg command then dies, and i only get charged for the delta. Any Tips?
- Inject AsyncCollector into a service
- mutual tls authentication between app service and function app
- Azure Application Insights Not Displaying Custom Logs for Azure Functions with .NET 8
- Application settings for production deployment slot in Azure App Services
- Encountered an error (ServiceUnavailable) from host runtime on Azure Function App
- Implementing Incremental consent when using both application and delegated permissions
- Invalid format for email address in WordPress on Azure app service
- Producer Batching Service Bus Vs Kafka
- Integrating Angular External IP with ClusterIP of .NET microservices on AKS
- Difficulty creating a data pipeline with Fabric Datafactory using REST
- Azure Batch for Excel VBA
- How to authenticate only Local and Guest users in Azure AD B2C and add custom claims in token?
- Azure Scale Sets and Parallel Jobs
Related Questions in AZURE-SYNAPSE
- Microsoft Fabric components and data replication
- Parmeter values not resolving in ADF
- Azure Synapse Link for Dataverse - Tables from F&O - only available via Spark pool for Delta Lake?
- Reading Unstructured Text from the entire file in Azure Data Factory
- Fetch non-structured data in Synapse for Cosmos DB NoSQL?
- Unable to load data from on prem to Synapse using polybase/Copy Method
- Azure Function time running increase after each run
- Unable to Read Synapse LakeDB tables from PowerBI
- Synapse pipeline - extract year and country from a filename in a wildcard path
- REST call in Copy Activity under Azure Synapse / ADF
- SQL Tranformations in view or stored procedure?
- Azure Synapse data via API
- Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 1 - When reading table in SQL
- Cannot setup credentials to run Azure Batch custom from Synapse pipeline
- Recursive CTE showing all levels of ragged-hierarchy BOMs
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Azure SQL Data Warehouse is a scale out MPP version of SQL Server. Azure SQL Data Warehouse just entered preview yesterday (learn more here http://aka.ms/sqldw) so features like Primary and Foreign Key constraints and ROW_NUMBER() OVER (UNBOUNDED PRECEDING... will be added as the service moves to general availability.
Azure SQLDW does support ROW_NUMBER() OVER (PARTITION BY...) today. This applies to other window aggregate functions like SUM() OVER().
You can view the list of supported syntax on the Azure SQL Data Warehouse documentation site: https://azure.microsoft.com/documentation/articles/sql-data-warehouse-overview-reference/