[HIVE-10628] Incorrect result when vectorized native mapjoin is enabled using null safe operators <=>

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 1.2.0
• Fix Version/s: 1.2.1
• Component/s: Hive
• Assignee: Matt McCline
• Reporter: Matt McCline
• Created: 06/May/15 18:04
• Updated: 05/Jun/15 20:57
• Resolved: 20/May/15 00:14

Description

Incorrect results for this query:

select count(*) from store_sales ss join store_returns sr on (sr.sr_item_sk <=> ss.ss_item_sk and sr.sr_customer_sk <=> ss.ss_customer_sk and sr.sr_item_sk <=> ss.ss_item_sk) where ss.ss_net_paid > 1000;