InfoBright - load data from one table to another

1.3k Views Asked by At

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)
    
1

There are 1 best solutions below

4
On

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.