[
https://issues.apache.org/jira/browse/CALCITE-2266?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16574722#comment-16574722
]
Hongze Zhang edited comment on CALCITE-2266 at 8/9/18 11:57 AM:
----------------------------------------------------------------
The basic implementation code of this is ready now.
JSON functions part of SQL:2016 can be found at
[http://standards.iso.org/ittf/PubliclyAvailableStandards/c065143_ISO_IEC_TR_19075-5_2016.zip]
h4. Implemented Function List
JSON_EXISTS
JSON_VALUE
JSON_QUERY
JSON_OBJECT
JSON_OBJECTAGG
JSON_ARRAY
JSON_ARRAYAGG
IS JSON predicate
h4. New Reserved Keyword List
JSON_EXISTS
JSON_VALUE
JSON_QUERY
JSON_OBJECT
JSON_OBJECTAGG
JSON_ARRAY
JSON_ARRAYAGG
h4. Not Implemented Yet (might implemet in future versions)
1. JSON_TABLE function _(ISO_IEC_TR_19075-5_2016 - 5.3.4: JSON_TABLE)_
2. Encoding of JSON representation _(ISO_IEC_TR_19075-5_2016 - 5.2.1: JSON
value expression)_
3. <JSON output clause> _(ISO_IEC_TR_19075-5_2016 - 5.2.4: JSON output clause)_
4. <JSON query quotes behavior> in JSON_QUERY function
_(ISO_IEC_TR_19075-5_2016 - 5.3.3: JSON_QUERY)_
5. <JSON key uniqueness constraint> in JSON_OBJECT / JSON_OBJECTAGG / IS JSON
predicate _(ISO_IEC_TR_19075-5_2016 - 5.4.1: JSON_OBJECT / 5.4.2:
JSON_OBJECTAGG / 5.4.5: IS JSON predicate)_
6. <JSON array constructor by query> in JSON_ARRAY function
_(ISO_IEC_TR_19075-5_2016 - 5.4.3: JSON_ARRAY)_
7. <JSON array aggregate order by clause> in JSON_ARRAYAGG function
_(ISO_IEC_TR_19075-5_2016 - 5.4.4: JSON_ARRAYAGG)_
was (Author: zhztheplayer):
The basic implementation code of this is ready now.
JSON functions part of SQL:2016 can be found at
[http://standards.iso.org/ittf/PubliclyAvailableStandards/c065143_ISO_IEC_TR_19075-5_2016.zip|http://standards.iso.org/ittf/PubliclyAvailableStandards/c065143_ISO_IEC_TR_19075-5_2016.zip]
h4. Implemented Function List
JSON_EXISTS
JSON_VALUE
JSON_QUERY
JSON_OBJECT
JSON_OBJECTAGG
JSON_ARRAY
JSON_ARRAYAGG
IS JSON predicate
h4. New Reserved Keyword List
JSON_EXISTS
JSON_VALUE
JSON_QUERY
JSON_OBJECT
JSON_OBJECTAGG
JSON_ARRAY
JSON_ARRAYAGG
h4. Not Implemented Yet (might implemet in future versions)
1. JSON_TABLE function
2. Encoding of JSON representation (ISO_IEC_TR_19075-5_2016 - 5.2.1: JSON value
expression)
3. <JSON output clause> (ISO_IEC_TR_19075-5_2016 - 5.2.4: JSON output clause)
4. <JSON query quotes behavior> in JSON_QUERY function (ISO_IEC_TR_19075-5_2016
- 5.3.3: JSON_QUERY)
5. <JSON key uniqueness constraint> in JSON_OBJECT / JSON_OBJECTAGG / IS JSON
predicate (ISO_IEC_TR_19075-5_2016 - 5.4.1: JSON_OBJECT / 5.4.2: JSON_OBJECTAGG
/ 5.4.5: IS JSON predicate)
6. <JSON array constructor by query> in JSON_ARRAY function
(ISO_IEC_TR_19075-5_2016 - 5.4.3: JSON_ARRAY)
7. <JSON array aggregate order by clause> in JSON_ARRAYAGG function
(ISO_IEC_TR_19075-5_2016 - 5.4.4: JSON_ARRAYAGG)
> Implement SQL 2016 JSON functions
> ---------------------------------
>
> Key: CALCITE-2266
> URL: https://issues.apache.org/jira/browse/CALCITE-2266
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Reporter: Michael Mior
> Priority: Major
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
