mercredi 6 juillet 2016

Importing Mysql CSV to PostgreSQL

I am trying to migrate CSV files that i generate from MySQL to AWS Redshift(PostgreSql). The query that generates CSV Files from Mysql is:

select * INTO OUTFILE 'filename' FIELDS TERMINATED BY 't'

and that is generating the output in the form of:

1559744 WIFI    123.63.13.93    conversation_list   page_load   0.16    success {"NetworkClass":"WIFI"} android_app     2016-06-15 00:00:00 c700b6e04077489 3.1_wo___ct_cd__gmmt_cst__  4.4.2

But while loading into Redshift I face the following error:

Missing newline: Unexpected character 0x57 found at location 7`.

The query that I am using to load the CSV file is:

copy table_name FROM 's3://mybucket'    
credentials 'aws_access_key_id=XXXXXXXXX;aws_secret_access_key=XXXXXXXX' 
delimiter AS 't'

Thanks

Aucun commentaire:

Enregistrer un commentaire