You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by pzwpzw <pe...@icloud.com.INVALID> on 2023/06/19 04:02:51 UTC
Support Graph Query In Calcite
Hi everyone, I have noticed that the SQL 2023 have proposed the Graph Property Query support. http://peter.eisentraut.org/blog/2023/04/04/sql-2023-is-finished-here-is-whats-newwhich we can combine the graph query "Match" statement with the sql.And also the ISO/GQL have proposed the GQL query. We have implement the SQL extend which can combine SQL with the ISO/GQL query in our open source stream graph engine TuGraph-Analytics(https://github.com/TuGraph-family/tugraph-analytics) based on calcite which can combine the SQL process with the graph query in one streaming engine. We can see the syntax here: https://github.com/TuGraph-family/tugraph-analytics/blob/master/docs/docs-en/application-development/dsl/overview.mdSo I would like to know if the Calcite community plans to support graph query language in the future. If possible, we would like to contribute our graph query extension to the community.Thanks.
Re: Support Graph Query In Calcite
Posted by Julian Hyde <jh...@gmail.com>.
I’ll reiterate what Stamatis said: log Jira tickets. Most of us know only vaguely what a graph query is. A well-written Jira case (describing the problem, with a couple of good SQL examples) will educate the people who would be reviewing the PR.
> On Jun 20, 2023, at 10:42 PM, pzwpzw <pe...@icloud.com.INVALID> wrote:
>
> Thanks for your reply.
> Currently we have implement a sub-set of the ISO/GQL draft with some our extension. It is widely used in the AntGroup. And the project is also released as an open source project: https://github.com/TuGraph-family/tugraph-analytics.
> I'm going to investigate the way Babel parser and the calcite adapter work and choose a better contribution way.
> Thanks.
>
>> 2023年6月20日下午6:40，Stamatis Zampetakis <za...@gmail.com> 写道：
>>
>>
>> Hello,
>>
>> We definitely welcome contributions that could improve the graph query
>> capabilities in Calcite. If something is part of the SQL standard then
>> it can be contributed to the core SQL parser of Calcite. If it is not
>> standard but still widely accepted/used it should probably land in the
>> babel parser. In every other case, we have the adapters and we can
>> accept new ones if necessary.
>>
>> In general smaller contributions are easier to review and merge so if
>> you can divide your work into smaller parts and create JIRA tickets
>> for each we can reason about them individually.
>>
>> Other than that the following threads/topics may be somewhat relevant
>> to what you are doing.
>>
>> * https://lists.apache.org/thread/q3yx5tmoxzwwh1n8x4oct0vfxcfpcjwg
>> * https://lists.apache.org/thread/oohfsp1ddyytn8v13btv21trwkbl5y2f
>> * https://issues.apache.org/jira/browse/CALCITE-3679
>> * https://calcite.apache.org/docs/reference.html#match_recognize
>>
>> Best,
>> Stamatis
>>
>> On Mon, Jun 19, 2023 at 6:03 AM pzwpzw
>> <pe...@icloud.com.invalid> wrote:
>>>
>>> Hi everyone, I have noticed that the SQL 2023 have proposed the Graph Property Query support. http://peter.eisentraut.org/blog/2023/04/04/sql-2023-is-finished-here-is-whats-new
>>> which we can combine the graph query "Match" statement with the sql.
>>>
>>> And also the ISO/GQL have proposed the GQL query. We have implement the SQL extend which can combine SQL with the ISO/GQL query in our open source stream graph engine TuGraph-Analytics(https://github.com/TuGraph-family/tugraph-analytics) based on calcite which can combine the SQL process with the graph query in one streaming engine. We can see the syntax here: https://github.com/TuGraph-family/tugraph-analytics/blob/master/docs/docs-en/application-development/dsl/overview.md
>>>
>>> So I would like to know if the Calcite community plans to support graph query language in the future. If possible, we would like to contribute our graph query extension to the community.
>>>
>>> Thanks.
>
回复：Re: Support Graph Query In Calcite
Posted by pzwpzw <pe...@icloud.com.INVALID>.
Thanks for your reply. Currently we have implement a sub-set of the ISO/GQL draft with some our extension. It is widely used in the AntGroup. And the project is also released as an open source project: https://github.com/TuGraph-family/tugraph-analytics.I'm going to investigate the way Babel parser and the calcite adapter work and choose a better contribution way.Thanks.2023年6月20日下午6:40，Stamatis Zampetakis <za...@gmail.com> 写道：Hello,We definitely welcome contributions that could improve the graph querycapabilities in Calcite. If something is part of the SQL standard thenit can be contributed to the core SQL parser of Calcite. If it is notstandard but still widely accepted/used it should probably land in thebabel parser. In every other case, we have the adapters and we canaccept new ones if necessary.In general smaller contributions are easier to review and merge so ifyou can divide your work into smaller parts and create JIRA ticketsfor each we can reason about them individually.Other than that the following threads/topics may be somewhat relevantto what you are doing.* https://lists.apache.org/thread/q3yx5tmoxzwwh1n8x4oct0vfxcfpcjwg* https://lists.apache.org/thread/oohfsp1ddyytn8v13btv21trwkbl5y2f* https://issues.apache.org/jira/browse/CALCITE-3679* https://calcite.apache.org/docs/reference.html#match_recognizeBest,StamatisOn Mon, Jun 19, 2023 at 6:03 AM pzwpzw<pe...@icloud.com.invalid> wrote:Hi everyone, I have noticed that the SQL 2023 have proposed the Graph Property Query support. http://peter.eisentraut.org/blog/2023/04/04/sql-2023-is-finished-here-is-whats-newwhich we can combine the graph query "Match" statement with the sql.And also the ISO/GQL have proposed the GQL query. We have implement the SQL extend which can combine SQL with the ISO/GQL query in our open source stream graph engine TuGraph-Analytics(https://github.com/TuGraph-family/tugraph-analytics) based on calcite which can combine the SQL process with the graph query in one streaming engine. We can see the syntax here: https://github.com/TuGraph-family/tugraph-analytics/blob/master/docs/docs-en/application-development/dsl/overview.mdSo I would like to know if the Calcite community plans to support graph query language in the future. If possible, we would like to contribute our graph query extension to the community.Thanks.
Re: Support Graph Query In Calcite
Posted by Stamatis Zampetakis <za...@gmail.com>.
Hello,
We definitely welcome contributions that could improve the graph query
capabilities in Calcite. If something is part of the SQL standard then
it can be contributed to the core SQL parser of Calcite. If it is not
standard but still widely accepted/used it should probably land in the
babel parser. In every other case, we have the adapters and we can
accept new ones if necessary.
In general smaller contributions are easier to review and merge so if
you can divide your work into smaller parts and create JIRA tickets
for each we can reason about them individually.
Other than that the following threads/topics may be somewhat relevant
to what you are doing.
* https://lists.apache.org/thread/q3yx5tmoxzwwh1n8x4oct0vfxcfpcjwg
* https://lists.apache.org/thread/oohfsp1ddyytn8v13btv21trwkbl5y2f
* https://issues.apache.org/jira/browse/CALCITE-3679
* https://calcite.apache.org/docs/reference.html#match_recognize
Best,
Stamatis
On Mon, Jun 19, 2023 at 6:03 AM pzwpzw
<pe...@icloud.com.invalid> wrote:
>
> Hi everyone, I have noticed that the SQL 2023 have proposed the Graph Property Query support. http://peter.eisentraut.org/blog/2023/04/04/sql-2023-is-finished-here-is-whats-new
> which we can combine the graph query "Match" statement with the sql.
>
> And also the ISO/GQL have proposed the GQL query. We have implement the SQL extend which can combine SQL with the ISO/GQL query in our open source stream graph engine TuGraph-Analytics(https://github.com/TuGraph-family/tugraph-analytics) based on calcite which can combine the SQL process with the graph query in one streaming engine. We can see the syntax here: https://github.com/TuGraph-family/tugraph-analytics/blob/master/docs/docs-en/application-development/dsl/overview.md
>
> So I would like to know if the Calcite community plans to support graph query language in the future. If possible, we would like to contribute our graph query extension to the community.
>
> Thanks.