如何将RedShift上的表卸载到单个CSV文件? [英] How to unload a table on RedShift to a single CSV file?

问题描述

我想将表从Amazon RedShift迁移到MySQL，但是使用卸载"将生成多个数据文件，这些数据文件很难直接导入MySQL.

I want to migrate a table from Amazon RedShift to MySQL, but using "unload" will generate multiple data files which are hard to imported into MySQL directly.

有什么方法可以将表卸载到单个CSV文件中，以便我可以将其直接导入到MySQL中?

Is there any approach to unload the table to a single CSV file so that I can import it to MySQL directly?

推荐答案

要发送到单个文件，请使用并行关闭

In order to send to a single file use parallel off

unload ('select * from venue')
to 's3://mybucket/tickit/unload/venue_' credentials 
'aws_access_key_id=<access-key-id>;aws_secret_access_key=<secret-access-key>'
parallel off;

我还建议使用Gzip，以使该文件更小以供下载.

Also I recommend using Gzip, to make that file even smaller for download.

unload ('select * from venue')
to 's3://mybucket/tickit/unload/venue_' credentials 
'aws_access_key_id=<access-key-id>;aws_secret_access_key=<secret-access-key>'
parallel off
gzip;

这篇关于如何将RedShift上的表卸载到单个CSV文件?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！