 |
  |
Contributed by Calpont, InfiniDB Community Edition is an open source, scale-up analytics database engine for your data warehousing, business intelligence and read-intensive application needs. Enabled via MySQLTM and purpose-built for an analytical workload with column-oriented technology at its core, the multi-threaded capabilities of InfiniDB Community Edition fully encompass query, transactional support and bulk load operations. Â So come on in, grab a download and get started.
|
|
|
Yes. MySQL supplies the load data infile command to load data into database tables. This command/utility is supported by InfiniDB and may be used, although it is not as fast as using the InfiniDB bulk load utility, cpimport.Â
As an example, for the following table:
The following file:Â
[root@qaftest7 local]# more t3.tst
1,2
2,3
3,4
May be loaded using the following:Â
mysql> load data infile '/usr/local/t3.tst' into table t3 fields terminated by ',';
Query OK, 3 rows affected (0.96 sec)
