[ 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.