You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "dataroaring (via GitHub)" <gi...@apache.org> on 2026/01/21 18:32:34 UTC
[PR] docs: add flexible partial column update support for Routine Load [doris-website]
dataroaring opened a new pull request, #3296:
URL: https://github.com/apache/doris-website/pull/3296
## Summary
This PR adds documentation for the new `unique_key_update_mode` property in Routine Load that enables flexible partial column updates, corresponding to [apache/doris#59896](https://github.com/apache/doris/pull/59896).
### Changes
- **partial-column-update.md**:
- Updated caution note to include Routine Load as a supported method
- Added complete Routine Load section with CREATE and ALTER syntax examples
- Added caution block for Routine Load-specific limitations
- **routine-load-manual.md**:
- Added `unique_key_update_mode` property to the job_properties table with all three modes documented
- Fixed `partial_columns` link to point to correct documentation
- Added complete "Flexible Partial Column Update" example with:
- Sample JSON data with different columns per row
- Table creation with required properties
- Routine Load job creation
- Expected results
### Feature Description
The `unique_key_update_mode` property supports three modes:
| Mode | Description |
|------|-------------|
| `UPSERT` | Default mode. Full row insert/update |
| `UPDATE_FIXED_COLUMNS` | Partial update where all rows update same columns (equivalent to `partial_columns=true`) |
| `UPDATE_FLEXIBLE_COLUMNS` | **New** - Each row can update different columns |
### Limitations for UPDATE_FLEXIBLE_COLUMNS
- JSON format only
- Cannot use `jsonpaths`, `fuzzy_parse`, `COLUMNS` clause, or `WHERE` clause
- Table must have `enable_unique_key_skip_bitmap_column=true`
## Test plan
- [ ] Verify documentation renders correctly
- [ ] Verify all links are working
- [ ] Review examples for accuracy
🤖 Generated with [Claude Code](https://claude.com/claude-code)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] docs: add flexible partial column update support for Routine Load [doris-website]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring merged PR #3296:
URL: https://github.com/apache/doris-website/pull/3296
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org