[TRAFODION-402] LP Bug: 1336450 - Salted HBase table should be hash2 partitioned to facilitate co-partitioned joins

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 0.8 (pre-incubation)
• Component/s: sql-cmp
• Labels: performance
• External issue URL: https://bugs.launchpad.net/bugs/1336450
• Assignee: Qifan Chen
• Reporter: Qifan Chen
• Created: 22/Jul/15 18:15
• Updated: 31/Aug/15 04:19
• Resolved: 31/Aug/15 04:04

Description

Currently salted HBase tables are range partitioned, which requires extra exchange nodes directly above the Hbase scans to randomly re-partition the data, and disables co-partitioned hash joins.

If such tables can bedescribed by HASH2 partitioning function, the above two disadvantages will be removed.