question

sakuraime avatar image
0 Votes"
sakuraime asked sakuraime commented

Polybase scale-out maximum compute node

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

I know each compute node has max 8 readers.

sql-server-general
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @sakuraime,

Microsoft has not specified the maximum number of computing nodes for the time being, but it should be able to meet daily needs.
You can have 0 to multiple compute nodes. When you have no compute nodes specified, the head node will also act as a compute node.

Best regards,
Seeya

0 Votes 0 ·
sakuraime avatar image sakuraime SeeyaXi-msft ·

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

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

0 Votes 0 ·

1 Answer

SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered sakuraime commented

Hi @sakuraime,

This is the official doc: https://docs.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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

thanks. let me know what's the maximum compute nodes ...thanks

0 Votes 0 ·