[
https://issues.apache.org/jira/browse/PHOENIX-1661?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14641858#comment-14641858
]
ASF GitHub Bot commented on PHOENIX-1661:
-----------------------------------------
GitHub user ictwanglei opened a pull request:
https://github.com/apache/phoenix/pull/102
PHOENIX-1661 Implement built-in functions for JSON
Add some built-in functions for JSON : JsonArrayElementsFunction.java
JsonArrayLengthFunction.java JsonEachFunction.java JsonObjectKeysFunction.java
JsonPopulateRecordFunction.java JsonPopulateRecordSetFunction.java.
ArrayToJsonFunction.java
Add end2end test files.
Modify file PhoenixJson.java to which I added some helper methods.
@JamesRTaylor @twdsilva @AakashPradeep
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/ictwanglei/phoenix json
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/phoenix/pull/102.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 #102
----
commit 26383070e5980697a0de1193c069692a8107b7c2
Author: ictwanglei <[email protected]>
Date: 2015-03-21T15:32:40Z
Create ArrayToJsonFunction.java
add a function to support "ArrayToJson" function as a build-in function for
JSON
commit 2c63494f99267fbcd0b7e52be76a1dc0154e306a
Author: ictwanglei <[email protected]>
Date: 2015-03-21T15:34:57Z
Create ArrayToJsonFunctionTest.java
a simple test for testing ArrayToJsonFunction
commit 241f4c3186a9f70f057e9196f962a0ed1b2f593b
Author: ictwanglei <[email protected]>
Date: 2015-06-28T11:26:56Z
Delete ArrayToJsonFunctionTest.java
commit f66ba90f92a667405759fceaf1ee74c27ef1d1c8
Author: ictwanglei <[email protected]>
Date: 2015-06-28T11:35:37Z
Create JsonFunctionTest.java
commit 7f2a6cf0c3d56b563a528036844dd5096f98ab6a
Author: ictwanglei <[email protected]>
Date: 2015-06-28T11:53:44Z
PHOENIX-1661
Implement built-in functions for JSON
commit db5c9e1cfbb1f3145a992efef13a8dca7cee0ec7
Author: ictwanglei <[email protected]>
Date: 2015-06-28T11:54:53Z
Delete ArrayToJsonFunction.java
commit a02b954453ff67220c08801e0eafd1c23bdd4b9c
Author: ictwanglei <[email protected]>
Date: 2015-06-28T11:55:10Z
Rename ArrayToJsonFunction1.java to ArrayToJsonFunction.java
commit eb76667b0c61ea646a63c1b46b41f418c6b43239
Author: ictwanglei <[email protected]>
Date: 2015-06-28T11:55:33Z
Update ArrayToJsonFunction.java
commit 6546bc5fb0620b954e31e54e0c71671c54a8f9dc
Author: ictwanglei <[email protected]>
Date: 2015-06-28T11:56:50Z
PHOENIX-1661 Implement built-in functions for JSON
commit 6bb8b116db3dd46434f2020a0ca2f46545b0ac05
Author: ictwanglei <[email protected]>
Date: 2015-06-28T11:58:22Z
PHOENIX-1661 Implement built-in functions for JSON
commit 3782d70ce1c0fedbcea48e3df968564311c06a2a
Author: ictwanglei <[email protected]>
Date: 2015-06-28T11:59:25Z
PHOENIX-1661 Implement built-in functions for JSON
commit 5ff61520d2aa351ea4dab18ec131c74f34b1b463
Author: ictwanglei <[email protected]>
Date: 2015-06-28T12:00:08Z
PHOENIX-1661 Implement built-in functions for JSON
commit d21c22b3697b64b920cc22a33e32d76b2b8eb074
Author: ictwanglei <[email protected]>
Date: 2015-06-28T12:01:14Z
PHOENIX-1661 Implement built-in functions for JSON
commit 541697d72d27a809cb8172efd58d83960b79f362
Author: ictwanglei <[email protected]>
Date: 2015-06-28T12:01:50Z
PHOENIX-1661 Implement built-in functions for JSON
commit 7e0dbaf950b4292bf673bb64367e57085ada25f8
Author: ictwanglei <[email protected]>
Date: 2015-06-28T12:03:16Z
PHOENIX-1661 Implement built-in functions for JSON
commit 331e09b9df48611421830b3c52afc80fd75099d5
Author: ictwanglei <[email protected]>
Date: 2015-06-28T12:09:54Z
PHOENIX-1661 Implement built-in functions for JSON
PHOENIX-1661 Implement built-in functions for JSON
commit 9f2c22df19c3a9cacd8a942f9c57baedcbc1f697
Author: ictwanglei <[email protected]>
Date: 2015-06-29T03:28:22Z
Merge branch 'master' into json
Conflicts:
phoenix-core/src/main/java/org/apache/phoenix/schema/json/PhoenixJson.java
commit 1646b8ac56b5bfdbdf637dbdbd47499219ee53b3
Author: ictwanglei <[email protected]>
Date: 2015-06-29T03:35:04Z
Merge branch 'json'
commit c8eb37c5e2a9df5b35bc92a169deba56f25599fe
Author: ictwanglei <[email protected]>
Date: 2015-06-30T11:35:16Z
1 add apache license
2 add some javadocs and commemts in the code
3 define variables only at the place where it is used
4 use StringBuilder replace "+" operator
5 rename some method name in PhoenixJson
6 change some helper methods level in JsonFunctionTest
commit d99e8b613a92c855e6997211ded3e4e2f390db57
Author: ictwanglei <[email protected]>
Date: 2015-07-01T00:59:53Z
add apache license
commit 684ed5264aabaad8afc8a261e09cabeacf214ee1
Author: ictwanglei <[email protected]>
Date: 2015-07-20T03:51:28Z
fix bugs
add End2End Test
commit 5c3359c02725f6833c51a8fe1cf9f3a3551e6414
Author: ictwanglei <[email protected]>
Date: 2015-07-24T08:07:13Z
Merge pull request #2 from ictwanglei/master
merge master branch
commit dfad2949604de1035899398f026a1dc351490b20
Author: ictwanglei <[email protected]>
Date: 2015-07-26T03:22:53Z
add end2end test files
add SQLExceptionCode
fix bugs
commit 63f0d923300e1d8a6337b908b4bed6b11d30ce20
Author: ictwanglei <[email protected]>
Date: 2015-07-26T03:44:22Z
delete JsonFunctionTest.java
----
> 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
> Labels: JSON, Java, SQL, gsoc2015, mentor
> Attachments: 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.3.4#6332)
