Share via

Cube, Rollup and Grouping Set support for Azure openrowset BULK option

Suraj Shashidhar 45 Reputation points
2025-02-03T12:33:46.2466667+00:00

Using Cube/Tollup or Grouping sets on Azure SQL with BULK Openrowset results in below error. Are these grouping supported for bulk openrowset?

request to perform an external distributed computation has failed with error "assertion failed: physicalplan::extractplan should only be called after optimization is complete."

Azure SQL Database
Accepted answer
  1. Mahesh Kurva 2,670 Reputation points Microsoft Vendor
    2025-02-04T11:29:41.61+00:00

    Hi @Suraj Shashidhar,

    I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others "I'll repost your solution in case you'd like to accept the answer.

    Issue:

    Using Cube/Tollup or Grouping sets on Azure SQL with BULK Openrowset results in below error. Are these grouping supported for bulk openrowset?

    request to perform an external distributed computation has failed with error "assertion failed: physicalplan::extractplan should only be called after optimization is complete."

    Solution:

    Under the Synapse Analytics service and discovered that certain GROUP BY options, such as CUBE, ROLLUP, and GROUPING SETS, are not fully supported in the serverless SQL pool within Azure Synapse Analytics. This means that if you're working with advanced aggregation methods like these, they may not function as expected in the serverless environment.

    This limitation is documented in the official Microsoft Learn documentation.

    If I missed anything please let me know and I'd be happy to add it to my answer, or feel free to comment below with any additional information.

    If you have any other questions, please let me know. Thank you again for your time and patience throughout this issue.

    Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Suraj Shashidhar 45 Reputation points
    2025-02-04T10:27:00.31+00:00

    Hello @Erland Sommarskog ,

    I asked the same question with Synapse Analytics tag and it seems like GROUP BY OPTIONS are not completely supported in serverless sql. There is also no comprehensive list of functionality not supported in serverless sql pool.

    https://learn.microsoft.com/en-us/answers/questions/2154214/aggregate-functions-supported-for-cube-rollup-and

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.