[HIVE-26883] Revert "HIVE-21872 Bucketed tables that load data from data/files/auto_sortmerge_join should be tagged as 'bucketing_version'='1'"

• Type: Sub-task
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 3.2.0
• Labels: pull-request-available
• Target Version/s: 3.2.0
• Assignee: Aman Raj
• Reporter: Aman Raj
• Created: 21/Dec/22 13:14
• Updated: 23/Dec/22 11:38
• Resolved: 23/Dec/22 11:33

Description

Tests are failing with the following errors:
Client Execution succeeded but contained differences (error code = 1) after executing auto_sortmerge_join_12.q
3d2
< TBLPROPERTIES('bucketing_version'='1')
9d7
< TBLPROPERTIES('bucketing_version'='1')
31d28
< TBLPROPERTIES('bucketing_version'='1')
36d32
< TBLPROPERTIES('bucketing_version'='1')
108d103
< TBLPROPERTIES('bucketing_version'='1')
114d108
< TBLPROPERTIES('bucketing_version'='1')
249c243
< bucketing_version 1
—
> bucketing_version 2
299c293
< bucketing_version 1
—
> bucketing_version 2
378c372
< bucketing_version 1
—
> bucketing_version 2
456c450
< bucketing_version 1
—
> bucketing_version 2
 
 
Since this commit was already reverted in branch-3.1 we can revert this in branch-3 to make it 3.1 compatible.

Issue Links

• is related to: HIVE-21872 Bucketed tables that load data from data/files/auto_sortmerge_join should be tagged as 'bucketing_version'='1'
• links to: GitHub Pull Request #3889