If we are to be ambitious, and to give someone a real challenge -- implement this approach for Calcite: Multi-objective Parametric Query Optimization https://cacm.acm.org/magazines/2017/10/221322-multi-objective-parametric-query-optimization/fulltext
(I think Julian might have mentioned this once before in a different context. I might be wrong ...) On Tue, Feb 27, 2018 at 10:20 AM, Michael Mior <[email protected]> wrote: > 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 > [email protected] > > 2018-02-26 19:09 GMT-05:00 Chunhui Shi <[email protected]>: > > > 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 <[email protected]> > > 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 <[email protected]> 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 > > > [email protected] > > > > > > 2018-02-26 14:46 GMT-05:00 Julian Hyde <[email protected]>: > > > > > >> 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 <[email protected]> > 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 > > >>> [email protected] > > >> > > >> > > > > >
