[HIVE-27482] Minor issues in array_intersect udf

• Type: Sub-task
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 4.0.0-beta-1
• Labels: pull-request-available
• Assignee: Taraka Rama Rao Lethavadla
• Reporter: Taraka Rama Rao Lethavadla
• Created: 05/Jul/23 14:47
• Updated: 15/Aug/23 06:33
• Resolved: 13/Jul/23 08:02

Description

1. SELECT array(1,2,3),array_intersect(array(1, 2, 3),array(1,3,4)); gives wrong output

[1,3] [1,3]

instead of 

[1,2,3][1,3]

2.  SELECT array_intersect(array(),array()); should give empty array instead of NULL

3.  Error handling when elements of array are not comparable

These fixes were already present on array_except udf whose implementation is identical to array_intersect, Ref: https://github.com/apache/hive/pull/4090

 

Issue Links

• links to: GitHub Pull Request #4469