BulkLoad with Composite Primary Key
Posted by: Joseph Lawler
Date: June 30, 2020 02:58PM

Is there some trick to bulkloading a table that has a composite primary key?

Scenario is this: Using Visual Studio C# I am able to do a bulk load when the primary key is set to a single Auto-increment column (ID). Works fine and useful for early testing. Table size in test exceeds 100M rows so bulk load is a requirement.

The actual Primary key is a composite of two columns that are both not null and the combination of which will always be unique (guaranteed due to the data creation algorithm).

Yet when I try to load the table with the composite primary key defined, bulk load only loads a single row with both elements of the primary key zeroed out. Huh.

I've verified:
- data going in - the values in the key columns are always completed.
- Table definition in MySQL. Keys are correctly listed as part of primary
- everything works fine if I use the Unique non-composite ID key.

I have no use for the Unique ID column so a primary key or index there seems completely unecessary.

Any ideas?

Options: ReplyQuote

Written By
BulkLoad with Composite Primary Key
June 30, 2020 02:58PM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.