[
https://issues.apache.org/jira/browse/PHOENIX-1661?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ranganath Govardhanagiri resolved PHOENIX-1661.
-----------------------------------------------
Resolution: Resolved
As per the JSON ISO standard document the 4 query functions defined are :
JSON_VALUE, JSON_QUERY, JSON_EXISTS and JSON_TABLE.
Following ISO standard, we have created PRs to implement those. We have also
chosen BSON as the data store format for its proven efficiency and use in
MongDB.
Resolving this as won't fix. Please let me know if you have any concerns.
> Implement built-in functions for JSON
> -------------------------------------
>
> Key: PHOENIX-1661
> URL: https://issues.apache.org/jira/browse/PHOENIX-1661
> Project: Phoenix
> Issue Type: Sub-task
> Reporter: James R. Taylor
> Assignee: LeiWang
> Priority: Major
> Labels: JSON, Java, SQL, gsoc2015, mentor
> Attachments: Implement built-in functions for JSON.pdf,
> PHOENIX-1661-00.patch, PHOENIX-1661.patch,
> PhoenixJSONSpecification-First-Draft.pdf
>
>
> Take a look at the JSON built-in functions that are implemented in Postgres
> (http://www.postgresql.org/docs/9.3/static/functions-json.html) and implement
> the same for Phoenix in Java following this guide:
> http://phoenix-hbase.blogspot.com/2013/04/how-to-add-your-own-built-in-function.html
> Examples of functions include ARRAY_TO_JSON, ROW_TO_JSON, TO_JSON, etc. The
> implementation of these built-in functions will be impacted by how JSON is
> stored in Phoenix. See PHOENIX-628. An initial implementation could work off
> of a simple text-based JSON representation and then when a native JSON type
> is implemented, they could be reworked to be more efficient.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
