[
https://issues.apache.org/jira/browse/HIVE-21615?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16818177#comment-16818177
]
Alan Gates commented on HIVE-21615:
-----------------------------------
These new functions include:
IS [NOT] JSON - a predicate for testing whether a string type is valid JSON
JSON_VALUE - takes a JSON string, applies a JSON path expression to it, and
produces a SQL type
JSON_QUERY - takes a JSON string, applies a JSON path expression to it, and
produces a JSON fragment
JSON_TABLE - treat an input as JSON and define a table using a series of JSON
path expressions
JSON_EXISTS - tests whether a JSON path expression produces a result when
applied to a JSON string
and JSON object constructors JSON_OBJECT, JSON_OBJECTAGG, JSON_ARRAY, and
JSON_ARRAYAGG.
> Implement SQL:2016 JSON functions
> ---------------------------------
>
> Key: HIVE-21615
> URL: https://issues.apache.org/jira/browse/HIVE-21615
> Project: Hive
> Issue Type: New Feature
> Components: UDF
> Affects Versions: 4.0.0
> Reporter: Alan Gates
> Assignee: Alan Gates
> Priority: Major
>
> SQL:2016 specifies several new functions for processing JSON in SQL. Hive
> should implement these functions.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
