gistfile1.txt

    SELECT * INTO OUTFILE '/tmp/sales.csv' FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n' FROM cloud.sales WHERE 1;


    LOAD DATA INFILE '/tmp/sales.csv' INTO TABLE sales CHARACTER SET UTF8 FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"';


User must have the "FILE" permission set.

CREATE TABLE sales (
id int,
period smallint,
month int,
year int,
isrc_code varchar(255),
upc_code varchar(255),
track_name varchar(255),
album_name varchar(255),
artists varchar(255),
country_sale_value_id int,
platform_sale_value_id int,
transfer_type_sale_value_id int,
quantity int,
parent_beneficiary_net_receipts float,
percentage float,
ringtone_publishing float,
publishing float,
mech_administrative_fee float,
total_amount float,
beneficiary_id int,
created_at datetime,
updated_at datetime,
net_receipts float,
sale_month date
) engine=infinidb DEFAULT CHARSET=utf8;

http://diethardsteiner.blogspot.com/2011/01/pentaho-data-integration-and-infinidb_01.html

Installation :

http://www.infinidb.org/resources/getting-started

Télécharger les .deb et les installer tous les 3 avec "dpkg -i"