[HIVE-26774] Implement array_slice UDF to get the subset of elements from an array (subarray)

• Type: Sub-task
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 4.0.0
• Component/s: Hive
• Labels: pull-request-available
• Assignee: Taraka Rama Rao Lethavadla
• Reporter: Taraka Rama Rao Lethavadla
• Created: 24/Nov/22 15:25
• Updated: 02/Feb/23 08:22
• Resolved: 02/Feb/23 08:22

Description

array_slice(array, start, length) - Returns the subset or range of elements from an array (subarray).

Example:
  

> SELECT array_slice(array(1, 2, 3,4), 2,2) FROM src LIMIT 1;
3,4

Returns empty list if start/length are out of range of the array

Issue Links

• links to: GitHub Pull Request #3893