[MDEV-12446] SUGGESTION: LOAD DATA INFILE with Multiple CSV simultaneous import Created: 2017-04-05  Updated: 2017-05-24

Status: Open
Project: MariaDB Server
Component/s: Server
Fix Version/s: None

Type: Task Priority: Minor
Reporter: Juan Telleria Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: SQL


 Description   

Hi!

I would like to suggest that LOAD DATA INFILE support a MULTIPLE=YES|NO clause, which allows multiple CSV import.

For example, If we have 100 CSV called myfile01.csv, myfile02.csv, [...], myfile03.csv, by adding previous clause within load data infile syntax we would be able to import all those CSV which have the same data structure simultaneously.

In fact, that would be a major advantage in comparison with other RDBMS, as it would be the only one supporting such behavior.

At this moment, this behavior can also be achieved by using Connectors, but the point is to do it all in MariaDB itself.

Thank you!
Juan



 Comments   
Comment by Sergei Golubchik [ 2017-05-24 ]

you can do it with a Connect engine or (may be) with a stored procedure that repeatedly executes LOAD DATA for all your tables.

Generated at Thu Feb 08 07:57:47 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.