[MCOL-1297] Control distribution order on dbroot / segment level Created: 2018-03-23  Updated: 2021-10-11  Resolved: 2021-01-17

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: None
Fix Version/s: N/A

Type: New Feature Priority: Major
Reporter: Richard Stracke Assignee: Todd Stoffel (Inactive)
Resolution: Won't Do Votes: 4
Labels: None

Issue Links:
Relates
relates to MCOL-3579 Manually set distribution key Closed
relates to MCOL-4217 ColumnStore Partitioning Closed

 Description   

Usual the distribution of storing data is not under control of the user.

Data will be loaded in the order of loading.
The only possiblitiy to control a bit, is to use mode 2 or 3 with cpimport for a certain PM.

Sometimes it can make sense to have control over the distribution process.

Similar to
-P List of PMs ex: -P 1,2,3. Default is all PMs.

-D  List if DBroot ex -D 1,2,3 Default is all DBroots. If a certain PM is not defined, PM1 will be  used.
 
-S List of Segments ex -S 1,2,3 Default is all Segments. If a certain PM is not defined, PM1 will be  used.

The same options should be possible for the bulk API
createBulkInsert(const std::string &db, const
std::string &table,
uint8_t
mode, uint16_t pm)

Add uint16_t dbroot  and uint16_t segment
 
createBulkInsert(const std::string &db, const
std::string &table,
uint8_t
mode, uint16_t pm, uint16_t dbroot, uint_16_t segment)

dbroot = 0 no preference. Otherwise the only the handed over dbroot will be filled.
If pm = 0, PM1 will be choosen.

segment = 0 no preference. Otherwise the only the handed over segment will be filled.
If pm = 0, PM1 will be choosen.

If batch data is greater then free space in specified available, the next in number will be taken.



 Comments   
Comment by patrice [ 2018-09-13 ]

Would be a nice feature

Generated at Thu Feb 08 02:27:41 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.