[ https://issues.apache.org/jira/browse/HIVE-12331?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15026048#comment-15026048 ]
Lefty Leverenz commented on HIVE-12331: --------------------------------------- Doc note: This removes *hive.enforce.bucketing* & *hive.enforce.sorting* from HiveConf.java, and changes the description of *hive.optimize.bucketingsorting* (created by HIVE-4240 in release 0.11.0 and not documented yet in the wiki) so Configuration Properties needs to be updated. * [Configuration Properties -- Query and DDL Execution | https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-QueryandDDLExecution] ** [Configuration Properties -- hive.enforce.bucketing | https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-hive.enforce.bucketing] ** [Configuration Properties -- hive.enforce.sorting | https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-hive.enforce.sorting] ** [Configuration Properties -- hive.optimize.bucketingsorting | https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-hive.optimize.bucketingsorting] (this link will work after the parameter has been documented) Other wikidocs that need updates because they mention the removed *hive.enforce.bucketing* parameter: * [Hive Transactions -- Configuration (annotate *hive.enforce.bucketing* with version information) | https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions#HiveTransactions-Configuration] * [Hive Transactions -- Configuration Values to Set for INSERT, UPDATE, DELETE (annotate *hive.enforce.bucketing* with version information) | https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions#HiveTransactions-ConfigurationValuestoSetforINSERT,UPDATE,DELETE] * [Bucketed Tables (3 instances of *hive.enforce.bucketing*) | https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL+BucketedTables] * [AdminManual Configuration -- Hive Configuration Variables (1 instance of *hive.enforce.bucketing*) | https://cwiki.apache.org/confluence/display/Hive/AdminManual+Configuration#AdminManualConfiguration-HiveConfigurationVariables] * [Configuration Properties -- Transactions and Compactor (*hive.enforce.bucketing* in list of parameters that need non-default values) | https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-TransactionsandCompactor] > Remove hive.enforce.bucketing & hive.enforce.sorting configs > ------------------------------------------------------------ > > Key: HIVE-12331 > URL: https://issues.apache.org/jira/browse/HIVE-12331 > Project: Hive > Issue Type: Improvement > Components: Configuration > Reporter: Ashutosh Chauhan > Assignee: Ashutosh Chauhan > Labels: TODOC2.0 > Fix For: 2.0.0 > > Attachments: HIVE-12331.1.patch, HIVE-12331.patch > > > If table is created as bucketed and/or sorted and this config is set to > false, you will insert data in wrong buckets and/or sort order and then if > you use these tables subsequently in BMJ or SMBJ you will get wrong results. -- This message was sent by Atlassian JIRA (v6.3.4#6332)