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

Paul Yang commented on HIVE-1439:
---------------------------------

This is actually supported with ALTER TABLE table_name CLUSTERED BY (col_name, 
col_name, ...) [SORTED BY (col_name, ...)] INTO num_buckets BUCKETS. However 
that command doesn't support turning off bucketing. Will file a JIRA for that.

> Alter the number of buckets for a table
> ---------------------------------------
>
>                 Key: HIVE-1439
>                 URL: https://issues.apache.org/jira/browse/HIVE-1439
>             Project: Hadoop Hive
>          Issue Type: New Feature
>    Affects Versions: 0.6.0, 0.7.0
>            Reporter: Paul Yang
>            Assignee: Paul Yang
>             Fix For: 0.6.0
>
>
> Add an alter table command to change the number of buckets for a table.
> e.g.
> {code}
> ALTER TABLE mytabl SET NUMBUCKETS 64;
> {code}

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to