maria-discuss team mailing list archive

[AskMonty KB <noreply@xxxxxxxxxxxx>]

Hello,

A new question has been asked in "CONNECT" by danielkrysiak:
--------------------------------
Hi,

I have data in CSV files. Partitioned inside a directory, one file per day, alive (constantly written to, insert at the end). I want to load them on-line (not once a day). Normally I would write peace of code, that remembers the last file and place, so it can easily go back and continue. But the Connect engine looks like a great ready solution for this kind of thing. I'm just not sure about:

1. I can't use indexes, because the file is changed all the time. Can I somehow make sure the data will be visible in a "connect table" always in the same order?

2. About "Multiple File Tables". Whats the order of data inside them?

3. What about simple file format change: add column at the end. Will data from older files be visible in "Multiple File Table" as null?
--------------------------------

To view or answer this question please visit: http://mariadb.com/kb/en/loading-csv-files/