Share via

Polybase scale-out maximum compute node

sakuraime 2,351 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 | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories


1 answer

Sort by: Most helpful
  1. Seeya Xi-MSFT 16,756 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.

    Was this answer helpful?


Your answer

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