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