[IMPALA-7611] Support index range in JSON path of JSON functions

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Backend
• Labels: json
• Epic Color: ghx-label-5
• Assignee: Unassigned
• Reporter: Quanlong Huang
• Created: 23/Sep/18 04:23
• Updated: 26/Oct/22 14:27

Description

In JSON functions like get_json_object, JSON path is used to extract the json values. We should
support range syntax like [2 to 7] and keyword `last` in the JSON path.

Hive has not supported it yet but MySQL does since 8.0.2. See https://dev.mysql.com/worklog/task/?id=9831 and https://github.com/mysql/mysql-server/commit/9f4678a