Polybase scale-out maximum compute node

sakuraime 2,321 Reputation points
2021-09-13T05:49:14.34+00:00

what's the Polybase scale-out maximum number of compute node?

I know each compute node has max 8 readers.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,756 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Seeya Xi-MSFT 16,441 Reputation points
    2021-09-17T08:38:40.307+00:00

    Hi @sakuraime ,

    This is the official doc: https://learn.microsoft.com/en-us/sql/relational-databases/polybase/polybase-scale-out-groups?view=sql-server-ver15

    so what's the max number of computing nodes . ?

    At present, Microsoft has not given an answer to this question. I will update the process if there is any follow-up.

    any the headnode can also have max 8 readers against the partitioned table ?

    Yes. Each node in a PolyBase scale-out group can spin up to 8 readers to read external data. And each reader is assigned one partition to read in the external table.

    Best regards,
    Seeya

    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.