Is there a way to insert data into InfoBright tables using LOAD DATA style like from file
LOAD DATA INFILE '/usr/tmp/file2.txt'
INTO TABLE test_table1
FIELDS TERMINATED BY ',' ENCLOSED BY '"';
mysql> select * from test_table1;
+------+-------------------+-----------+
| id | textfield | numerical |
+------+-------------------+-----------+
| 1 | one, two or three | 1234 |
| 1 | one, two or three | 1234 |
+------+-------------------+-----------+
2 rows in set (0.00 sec)
Yes, you can (EDIT: but only for external data)
In fact, if you're using Infobright's Community Edition, this is one of the only ways to get data into an Infobright table. Infobright Community Edition does not support DML which would allow for
INSERT
commands.Infobright actually has a lot of good documentation and samples on their site and on their forums.
EDIT: An update per your comment (Assuming Community Edition, again)
If you want to get data from one table in InfoBright into another, you'll need to re-import it from an external data source.