calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Mior <mm...@uwaterloo.ca>
Subject Re: Google Summer of Code 2018
Date Tue, 27 Feb 2018 15:20:22 GMT
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
mmior@apache.org

2018-02-26 19:09 GMT-05:00 Chunhui Shi <cshi@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 <jhyde@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 <mmior@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
> > mmior@apache.org
> >
> > 2018-02-26 14:46 GMT-05:00 Julian Hyde <jhyde@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 <mmior@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
> >>> mmior@apache.org
> >>
> >>
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message