You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2015/07/11 15:42:04 UTC
[jira] [Commented] (PHOENIX-628) Support native JSON data type
[ 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 <te...@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 <te...@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 <te...@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 <te...@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 <ex...@gmail.com>
Date: 2015-07-11T09:37:09Z
First Version
commit 229939099154042af98b24839cfb483624400fb0
Author: Andy <ex...@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)