View Data Loading
ICE includes a dedicated high-performance loader, that differs from the standard MySQL Loader. The Infobright Loader is designed for speed, but supports less load syntax than the MySQL Loader, and only supports variable length text formatted load files.
Import your data into an Infobright table by using the following load syntax (all other MySQL Loader syntax is not supported):
LOAD DATA INFILE '/full_path/file_name' INTO TABLE table_name
[FIELDS
[TERMINATED BY 'char']
[ENCLOSED BY 'char']
[ESCAPED 'char']
];
The data is committed when the load completes if AUTOCOMMIT is set to on. This is default setting, but you can make it explicit by setting:
Set AUTOCOMMIT=1;
If you want to check the data via select before committing, then set AUTOCOMMIT to off:
Set AUTOCOMMIT=0;
New data can be seen by the loading session even though its not committed. Complete the load using an explicit COMMIT:
COMMIT;
For testing purposes you can generate data using this community user’s data generation tool.
For more information on using the ICE Loader and details on the supported syntax, please click on the following link to download the Loading Data in ICE document:
