从亚马逊红移卸载表到S3的时候，我怎么让它只产生一个文件 [英] when unloading a table from amazon redshift to s3, how do I make it generate only one file

问题描述

当我卸载表从亚马逊红移到S3，它总是分割表分为两个部分，无论多么小桌子。我已经阅读了有关卸载的红移文档，但没有答案的其他比它说，有时它分割表（我从来没有见过它这样做）。我有两个问题：

When I unload a table from amazon redshift to S3, it always splits the table into two parts no matter how small the table. I have read the redshift documentation regarding unloading, but no answers other than it says sometimes it splits the table (I've never seen it not do that). I have two questions:

• 有没有人每次看到在其中创建只有一个文件的情况？

• Has anybody every seen a case where only one file is created?

有没有办法强制红移卸载到一个文件？

Is there a way to force redshift to unload into a single file?

推荐答案

亚马逊最近增加了对使用的并行关在UNLOAD语句。请注意，您仍然可以结束了一个以上的文件，如果它是大于6.2GB。

Amazon recently added support for unloading to a single file by using PARALLEL OFF in the UNLOAD statement. Note that you still can end up with more than one file if it is bigger than 6.2GB.

这篇关于从亚马逊红移卸载表到S3的时候，我怎么让它只产生一个文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！