You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Steven Phillips (JIRA)" <ji...@apache.org> on 2015/06/26 02:52:04 UTC

[jira] [Updated] (DRILL-3381) Add option to distribute partition keys in CTAS

     [ https://issues.apache.org/jira/browse/DRILL-3381?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Phillips updated DRILL-3381:
-----------------------------------
    Attachment: DRILL-3381.patch

> Add option to distribute partition keys in CTAS
> -----------------------------------------------
>
>                 Key: DRILL-3381
>                 URL: https://issues.apache.org/jira/browse/DRILL-3381
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Steven Phillips
>         Attachments: DRILL-3381.patch
>
>
> The current implementation does not redistribute, which would tend to result in a lot of extra files. Specifically, the number of files will be larger by a factor equal to the number of fragments in the final stage of the query. On even a moderately sized cluster, this number could easily be in the thousands, so a table with a 100 different partitions would end up with hundreds of thousands of files.
> To allow a workaround for this situation, we should add an option to include an extra distribution, so that all the rows for any given partition are written from the same writer.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)