You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues-all@impala.apache.org by "ZhuMinghui (Jira)" <ji...@apache.org> on 2022/10/26 14:28:01 UTC

[jira] [Commented] (IMPALA-7611) Support index range in JSON path of JSON functions

    [ https://issues.apache.org/jira/browse/IMPALA-7611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17624505#comment-17624505 ] 

ZhuMinghui commented on IMPALA-7611:
------------------------------------

Why are characters not supported, like ['name']?

> Support index range in JSON path of JSON functions
> --------------------------------------------------
>
>                 Key: IMPALA-7611
>                 URL: https://issues.apache.org/jira/browse/IMPALA-7611
>             Project: IMPALA
>          Issue Type: New Feature
>          Components: Backend
>            Reporter: Quanlong Huang
>            Priority: Major
>              Labels: json
>
> 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



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org