[ https://issues.apache.org/jira/browse/PHOENIX-628?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14623395#comment-14623395 ]
ASF GitHub Bot commented on PHOENIX-628: ---------------------------------------- GitHub user petercdc opened a pull request: https://github.com/apache/phoenix/pull/99 PHOENIX-628 Support native JSON data type Adding following JSON operators: JSON data Operator : "->" "->>" "#>" "#>>" JSON Boolean Operactor : "?" "?|" "?&" "<@" "@>" For more detail about how to use these operators, Please See http://www.postgresql.org/docs/9.4/static/functions-json.html You can merge this pull request into a Git repository by running: $ git pull https://github.com/petercdc/phoenix jsoncdc Alternatively you can review and apply these changes as the patch at: https://github.com/apache/phoenix/pull/99.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #99 ---- commit a131aa3664d18a048a41b0dab9155d90b17103f5 Author: LiChiachi <t...@example.com> Date: 2015-07-01T10:55:39Z rebase from json brance (but just recreate new branch base on json branch) fixed: All ParseNode and Visiter , All ExpressionVisiter , PhoenixJson method to be used for Expression method Not fixed yet: Expression method exclusive JsonPonit Operator commit 8babfb5fba20d24a1c65b02fdd13075b0632d4fc Author: LiChiachi <t...@example.com> Date: 2015-07-02T08:48:36Z rebase on json branch (but create new branch base on json branch) fixed: All ParseNode and All ExpressionNode exclusive Superset and Subset not fixed yet: Type Checking for As Element Node , Superset and Subset Node commit 077d5f41da0c22bcafd9387df90c60ea0be659ed Author: LiChiachi <t...@example.com> Date: 2015-07-06T09:56:47Z rebase on json branch (but recreate new branch based on json branch) fixed: All ParseNode and ExpressionNode are done not fixed yet: TypeChecking for Skipping checking type on JsongetElementExpression commit 5b8a43e09202b04e3371ff8cfd8451b68baa2759 Author: LiChiachi <t...@example.com> Date: 2015-07-10T01:52:53Z rebase on json branch (but recreate new branch based on json branch) fix bug wronging with superset and subset node commit 7793e94cf27d4057b633b7c67234f6e451d5577c Author: Andy <ex2s62026...@gmail.com> Date: 2015-07-11T09:37:09Z First Version commit 229939099154042af98b24839cfb483624400fb0 Author: Andy <ex2s62026...@gmail.com> Date: 2015-07-11T11:15:14Z fix type checking bug ---- > Support native JSON data type > ----------------------------- > > Key: PHOENIX-628 > URL: https://issues.apache.org/jira/browse/PHOENIX-628 > Project: Phoenix > Issue Type: Task > Affects Versions: 4.4.0 > Reporter: James Taylor > Assignee: Aakash Pradeep > Labels: JSON, Java, SQL > Fix For: 5.0.0, 4.4.1 > > > MongoDB and PostGres do some interesting things with JSON. We should look at > adding similar support. For a detailed description, see JSONB support in > Postgres: > http://www.craigkerstiens.com/2014/03/24/Postgres-9.4-Looking-up > http://www.depesz.com/2014/03/25/waiting-for-9-4-introduce-jsonb-a-structured-format-for-storing-json/ > http://michael.otacoo.com/postgresql-2/manipulating-jsonb-data-with-key-unique/ -- This message was sent by Atlassian JIRA (v6.3.4#6332)