gpdb
gpdb copied to clipboard
Replace SCATTER BY 1 with column name
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