gpdb icon indicating copy to clipboard operation
gpdb copied to clipboard

Replace SCATTER BY 1 with column name

Open xuebinsu opened this issue 1 year ago • 5 comments

In Table-Value Expressions, SCATTER BY 1 will redistribute the data by constant number 1 instead of the first column. However, the example in the doc implies that SCATTER BY 1 will set the distribution key to the first column, which is not true.

This patch fixes this by changing the SCATTER BY 1 to SCATTER BY <column_name> in the example of the doc to show how to redistribute data by a column.

Here are some reminders before you submit the pull request

  • [ ] Add tests for the change
  • [ ] Document changes
  • [ ] Communicate in the mailing list if needed
  • [ ] Pass make installcheck
  • [ ] Review a PR in return to support the community

xuebinsu avatar Jan 08 '24 06:01 xuebinsu