[
https://issues.apache.org/jira/browse/PHOENIX-628?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14582991#comment-14582991
]
ASF GitHub Bot commented on PHOENIX-628:
----------------------------------------
GitHub user petercdc opened a pull request:
https://github.com/apache/phoenix/pull/88
PHOENIX-628 Support native JSON data type
This pull request has following changes:
1. JSON Operator : "->" "->>" "#>" "#>>"
2. 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 json
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/phoenix/pull/88.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 #88
----
commit db4432fa76d4229ad4939c995a0a374004a2a1ff
Author: LiChiachi <[email protected]>
Date: 2015-04-24T11:05:34Z
This patch can support json operation
operator '->>' can be run
commit 415b5257d6b3b6e4347f72fedae626e8e0364443
Author: Andy <[email protected]>
Date: 2015-04-30T08:54:04Z
Add json operation (first ver)
commit 3294fccf2d9a5c53ac51e81722a202fdae7ce977
Author: LiChiachi <[email protected]>
Date: 2015-05-19T05:19:23Z
Create Json Point Expression
commit 960e0e4eb9001ddbdd83a02cffa2ca04ea061cc4
Author: LiChiachi <[email protected]>
Date: 2015-05-19T07:03:58Z
Append ExpressionType and can be run
commit 9c4f02475aa9fa41426f474e320ad34de66d205a
Author: LiChiachi <[email protected]>
Date: 2015-05-19T07:25:41Z
Use Byte String to get or put Json Structure
commit 2c214ba9590b81f83454b417892fb2fa9dc80c10
Author: Andy <[email protected]>
Date: 2015-05-19T10:30:53Z
Merge branch 'jsonOperatorFromChiachi' into json
Conflicts:
phoenix-assembly/src/build/components-major-client.xml
phoenix-assembly/src/build/server.xml
phoenix-core/pom.xml
phoenix-core/src/main/antlr3/PhoenixSQL.g
phoenix-core/src/main/java/org/apache/phoenix/compile/ExpressionCompiler.java
phoenix-core/src/main/java/org/apache/phoenix/expression/ExpressionType.java
phoenix-core/src/main/java/org/apache/phoenix/expression/visitor/BaseExpressionVisitor.java
phoenix-core/src/main/java/org/apache/phoenix/expression/visitor/CloneExpressionVisitor.java
phoenix-core/src/main/java/org/apache/phoenix/expression/visitor/ExpressionVisitor.java
phoenix-core/src/main/java/org/apache/phoenix/expression/visitor/StatelessTraverseAllExpressionVisitor.java
phoenix-core/src/main/java/org/apache/phoenix/expression/visitor/StatelessTraverseNoExpressionVisitor.java
phoenix-core/src/main/java/org/apache/phoenix/parse/JsonPathAsElementParseNode.java
phoenix-core/src/main/java/org/apache/phoenix/parse/JsonPathAsTextParseNode.java
phoenix-core/src/main/java/org/apache/phoenix/parse/JsonPointAsElementParseNode.java
phoenix-core/src/main/java/org/apache/phoenix/parse/JsonPointAsTextParseNode.java
phoenix-core/src/main/java/org/apache/phoenix/parse/JsonSingleKeySearchParseNode.java
phoenix-core/src/main/java/org/apache/phoenix/parse/ParseNodeFactory.java
commit 5257535902ebc430239c9a07464845ab163ef0ff
Author: Andy <[email protected]>
Date: 2015-05-19T10:35:22Z
Add JSON Operation
commit 09fae4aad2bf875225a68ac04ec0feb4fb618337
Author: LiChiachi <[email protected]>
Date: 2015-05-21T08:48:43Z
Merge branch 'jsonOperator' into jsonForGooYoi
Conflicts:
phoenix-core/src/main/java/org/apache/phoenix/compile/ExpressionCompiler.java
phoenix-core/src/main/java/org/apache/phoenix/expression/ExpressionType.java
phoenix-core/src/main/java/org/apache/phoenix/expression/visitor/BaseExpressionVisitor.java
phoenix-core/src/main/java/org/apache/phoenix/expression/visitor/CloneExpressionVisitor.java
phoenix-core/src/main/java/org/apache/phoenix/expression/visitor/ExpressionVisitor.java
phoenix-core/src/main/java/org/apache/phoenix/expression/visitor/StatelessTraverseAllExpressionVisitor.java
phoenix-core/src/main/java/org/apache/phoenix/expression/visitor/StatelessTraverseNoExpressionVisitor.java
commit d16e731d37649bf562e1b1977b42c75f00555d4b
Author: LiChiachi <[email protected]>
Date: 2015-05-21T08:52:52Z
debug for '->' operator
commit efdf95dd14955c5329fb7f631e647387a8ca3e93
Author: LiChiachi <[email protected]>
Date: 2015-05-25T02:41:25Z
all operation can be executed.
commit a24bf459b315c476129fb41734a18ef9e794f84f
Author: Andy <[email protected]>
Date: 2015-05-27T08:35:05Z
Add JSON opeation(fix bug)
commit 9acfaa3aab8a038b23390505737897acf38c3852
Author: LiChiachi <[email protected]>
Date: 2015-05-27T11:35:56Z
Merge branch 'jsonToBeMerge' into jsonMain
commit 4e500eff05844efac8f209482f03bfa54b4ce9d7
Author: LiChiachi <[email protected]>
Date: 2015-05-29T04:43:16Z
Create JSON operation JUNIT test.
commit af6a2ec0ab7d3c74275fe7ee28a6f33e82ccd1b1
Author: LiChiachi <[email protected]>
Date: 2015-05-29T05:56:19Z
Update JUNIT test
commit 453576bc906374a25418cf408f43b43ba7b2ef10
Author: Andy <[email protected]>
Date: 2015-06-01T01:07:23Z
JSON operation(fix bug)
commit c46f0e905cb55f500fc8d1b7a371c93fc68fad60
Author: Andy <[email protected]>
Date: 2015-06-01T01:58:04Z
Merge branch 'jsonToBeMerge' into json
commit 194deace60e5fe1144a945e5faac82a6212dec8a
Author: Andy <[email protected]>
Date: 2015-06-12T05:28:05Z
fix JSON operation 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)
