Comments - ColumnStore Bulk Data Loading
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
How do I tell cpimport the column names/ordering in the file I want to import from? I don't see any mention of this anywhere
The file order needs to match the order of columns in the create table. I added some clarification around this at the start. If your file doesn't match this then you'll need to update your data extraction or ETL logic.
And to figure out the order of columns I have to do something like this query?
select column_name from information_schema.columnstore_columns where table_schema = '<database>' and table_name = '<table>' order by column_position
That would work or simpler would be show create table <table-name> to dump out the create table sql if you don't already have that to hand.