[jira] [Commented] (HIVE-2352) selecting no rows and overwriting a table creates empty file for nonbucketized table

["Ning Zhang (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-2352?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13080248#comment-13080248 ] 

Ning Zhang commented on HIVE-2352:
----------------------------------

Franklin, a simpler description of your fix would be: create empty files if and only if table is bucketed and hive.enforce.bucketing=true, right? 

> selecting no rows and overwriting a table creates empty file for nonbucketized table
> ------------------------------------------------------------------------------------
>
>                 Key: HIVE-2352
>                 URL: https://issues.apache.org/jira/browse/HIVE-2352
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Franklin Hu
>            Assignee: Franklin Hu
>            Priority: Minor
>         Attachments: hive-2352.1.patch
>
>
> create table t1 (key int, value string) stored as rcfile;
> insert overwrite table t1 select * from src where false;
> Creates an empty RCFile with no rows and size 151B. The file not should be created since there are no rows.
> Fix:
> If bucketing IS NOT enforced:
>   Create empty files in neither bucketed nor non-bucketed tables
> If bucketing IS enforced:
>   Do not create empty files in non-bucketed tables
>   Create BUCKET_COUNT number of empty files for bucketed tables

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira