I would suggest creating a JIRA case to track this. It sounds like a basic implementation could be of reasonable scope for a GSoC project.
-- Michael Mior mm...@apache.org 2018-02-26 19:09 GMT-05:00 Chunhui Shi <c...@mapr.com>: > What about "SQL support for JavaScript Object Notation (JSON)"? > www.iso.org/standard/67367.html<http://www.iso.org/standard/67367.html>? > > There are two categories of JSON functions (8 functions) for query and for > constructor, some clauses like PLAN, etc are introduced in this standard. > > I did not see the supports in mainstream DBs(Oracle and Sql Server) > covering all of them, but IS JSON, JSON_QUERY and JSON_VALUE are both > implemented > > SQL server support > https://docs.microsoft.com/en-us/sql/relational-databases/ > json/validate-query-and-change-json-data-with-built- > in-functions-sql-server > > Oracle: > https://docs.oracle.com/database/121/ADXDB/json.htm#ADXDB6374 > > MySQL and Postgres have a lot functions to handle JSON, besides > JSON_OBJECT or one or two other functions, seems none of its function is > standardized. > https://dev.mysql.com/doc/refman/5.7/en/json-function-reference.html > > Postgres > <https://dev.mysql.com/doc/refman/5.7/en/json-function-reference.html> > https://www.postgresql.org/docs/current/static/functions-json.html > > > While I think the scope could be self contained, if it is not suitable for > this activity do we want to put this into Calcite roadmap? > > > Best, > > Chunhui > > ________________________________ > From: Julian Hyde <jh...@apache.org> > Sent: Monday, February 26, 2018 4:00:21 PM > To: dev > Subject: Re: Google Summer of Code 2018 > > Yes. > > > > On Feb 26, 2018, at 2:32 PM, Michael Mior <mm...@uwaterloo.ca> wrote: > > > > Thanks Julian! Would these be some good JIRAs to tag? > > > > https://urldefense.proofpoint.com/v2/url?u=https-3A__issues. > apache.org_jira_browse_CALCITE-2D1737&d=DwICAg&c=cskdkSMqhcnjZxdQVpwTXg&r= > 7bZjGOKpQi7qeyQ_xRpzEQ&m=LYUbb9SvNkKb5PpYzt7-eWRg5qGj9K6txN2zGGcqakg&s= > KXsK-qlYTOf5W1KDQmlqjA7CIj4_CtGlmWirBlPxopI&e= > > https://urldefense.proofpoint.com/v2/url?u=https-3A__issues. > apache.org_jira_browse_CALCITE-2D1861&d=DwICAg&c=cskdkSMqhcnjZxdQVpwTXg&r= > 7bZjGOKpQi7qeyQ_xRpzEQ&m=LYUbb9SvNkKb5PpYzt7-eWRg5qGj9K6txN2zGGcqakg&s= > 6xfRRfhSus-SrVHKvEIYKzcyAaEAUJBLdHbkqjUhrRk&e= > > https://urldefense.proofpoint.com/v2/url?u=https-3A__issues. > apache.org_jira_browse_CALCITE-2D2031&d=DwICAg&c=cskdkSMqhcnjZxdQVpwTXg&r= > 7bZjGOKpQi7qeyQ_xRpzEQ&m=LYUbb9SvNkKb5PpYzt7- > eWRg5qGj9K6txN2zGGcqakg&s=oLu_OiKf-cFe1RxcmAnv2CFW6QPGbpz5uYeiN5y3EMs&e= > > > > -- > > Michael Mior > > mm...@apache.org > > > > 2018-02-26 14:46 GMT-05:00 Julian Hyde <jh...@apache.org>: > > > >> Here are two areas that are self-contained and rewarding: > >> * Spatial functions > >> * Spark adapter > >> > >> Julian > >> > >> > >> > >>> On Feb 24, 2018, at 4:24 PM, Michael Mior <mm...@uwaterloo.ca> wrote: > >>> > >>> You have probably seen that Apache was accepted as an organization for > >> this > >>> year's GSoC. I thought I would see if anyone in the Calcite community > can > >>> think of any issues that would be a good fit. It's no guarantee we > would > >>> get someone to work on it, but it could be a good push to move some > >>> isolated bits of functionality forward that may not get much attention > >>> otherwise. > >>> > >>> -- > >>> Michael Mior > >>> mm...@apache.org > >> > >> > >