[ https://issues.apache.org/jira/browse/PHOENIX-1661?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16311309#comment-16311309 ]
Wen-Hsiu,Chang commented on PHOENIX-1661: ----------------------------------------- [~lovegn28] and I are in the same group. And we wrote a get_json_object function below. Please take a look. [^PHOENIX-1661-00.patch] > 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 Taylor > Assignee: LeiWang > 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 (v6.4.14#64029)