You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by bluejoe <bl...@cnic.cn> on 2016/09/07 02:18:32 UTC
solr-sql: adapter for solr cloud
Hi, all
I am a Calcite user from China. Calcite is very powerful and the abstraction work is very prefect.
Now I am working on solr-sql project, which implements a Calcite adapter to provide sql interfaces for solr(see https://github.com/bluejoe2008/solr-sql). Can Calcite add links to my project on Web pages thus people who are looking for similar solutions can find it and give me more advices.
I am not sure it is ok to discuss such a topic in this mail, but I failed to find github issues system for Calcite.
Best regards,
Zhihong SHEN
———————————————
Zhihong SHEN, Ph. D., Senior Engineer
Big Data Application Service Technology Laboratory,
Computer Network Information Center, Chinese Academy of Sciences
office phone:+86-10-58812516
mobile：+86-13671116520
Re: solr-sql: adapter for solr cloud
Posted by Kevin Risden <co...@gmail.com>.
Thanks for the look Julian. I approved and merged the PR. I'm hoping to
work on the Calcite piece in the next 2-3 weeks leading up to Solr
Revolution. Any suggestions/improvements are appreciated.
Kevin Risden
On Thu, Sep 22, 2016 at 6:06 PM, Julian Hyde <jh...@apache.org> wrote:
> Thanks for sharing. I upgraded Solr (because 6.1.0-SNAPSHOT is no longer
> available at apache.org <http://apache.org/>) and everything works fine.
>
> I created a PR: https://github.com/risdenk/solr-calcite-example/pull/1 <
> https://github.com/risdenk/solr-calcite-example/pull/1>
>
> Julian
>
> > On Sep 20, 2016, at 3:29 PM, Kevin Risden <co...@gmail.com>
> wrote:
> >
> > Just wanted to throw this out there in case it is helpful and prompts any
> > ideas/improvements:
> >
> > I was attempting to integrate Apache Calcite into Apache Solr proper and
> > along the way created this repo for testing:
> >
> > https://github.com/risdenk/solr-calcite-example <
> https://github.com/risdenk/solr-calcite-example>
> >
> > It was originally meant for my testing of push down rules and tightly
> > integrating into Solr 6 parallel sql. The end goal was to integrate into
> > Apache Solr SQL handler. The relevant Solr JIRA is
> > https://issues.apache.org/jira/browse/SOLR-8593 <
> https://issues.apache.org/jira/browse/SOLR-8593>
> >
> > I haven't had a chance to get back to it in the past few months though.
> In
> > about a month, I am presenting on Solr JDBC at the Lucene/Solr Revolution
> > in Boston. I'm hoping to have time to cleanup the integration with
> Calcite
> > for a demo, but we will see based on time.
> >
> > Kevin Risden
> >
> > On Tue, Sep 6, 2016 at 9:41 PM, bluejoe <bluejoe@cnic.cn <mailto:
> bluejoe@cnic.cn>> wrote:
> >
> >> That's great!
> >> Thank you very much!
> >>
> >> Best regards,
> >> Zhihong SHEN
> >> ———————————————
> >> Zhihong SHEN, Ph. D., Senior Engineer
> >> Big Data Application Service Technology Laboratory,
> >> Computer Network Information Center, Chinese Academy of Sciences
> >> office phone:+86-10-58812516
> >> mobile：+86-13671116520
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >> 在 16/9/7 上午10:33，“Julian Hyde”<dev-return-3760-bluejoe=
> >> cnic.cn@calcite.apache.org <ma...@calcite.apache.org> 代表
> jhyde@apache.org <ma...@apache.org>> 写入:
> >>
> >>> This mailing list is the perfect place to discuss this. (For future
> >> reference, for issues we use Apache JIRA[1], not github issues.)
> >>>
> >>> We’d be happy to add a mention of your adapter to the site. It could go
> >> into the Adapters page[2]. Edit the source of that page[3] and create a
> >> pull request.
> >>>
> >>> And by the way, there is also a “powered by Calcite” page for companies
> >> and projects that use Calcite[4]. Anyone who wants to add their
> >> company/project should see instructions at the bottom of that page.
> >>>
> >>> Julian
> >>>
> >>> [1] https://issues.apache.org/jira/browse/CALCITE
> >>>
> >>> [2] https://calcite.apache.org/docs/adapter.html <
> >> https://calcite.apache.org/docs/adapter.html <
> https://calcite.apache.org/docs/adapter.html>>
> >>>
> >>> [3] https://github.com/apache/calcite/blob/master/site/_
> docs/adapter.md <https://github.com/apache/calcite/blob/master/site/_
> docs/adapter.md> <
> >> https://github.com/apache/calcite/blob/master/site/_docs/adapter.md <
> https://github.com/apache/calcite/blob/master/site/_docs/adapter.md>>
> >>>
> >>> [4] https://calcite.apache.org/docs/powered_by.html <
> https://calcite.apache.org/docs/powered_by.html> <
> >> https://calcite.apache.org/docs/powered_by.html <
> https://calcite.apache.org/docs/powered_by.html>>
> >>>
> >>>
> >>>> On Sep 6, 2016, at 7:18 PM, bluejoe <bl...@cnic.cn> wrote:
> >>>>
> >>>> Hi, all
> >>>>
> >>>> I am a Calcite user from China. Calcite is very powerful and the
> >> abstraction work is very prefect.
> >>>>
> >>>> Now I am working on solr-sql project, which implements a Calcite
> >> adapter to provide sql interfaces for solr(see https://github.com/
> >> bluejoe2008/solr-sql). Can Calcite add links to my project on Web pages
> >> thus people who are looking for similar solutions can find it and give
> me
> >> more advices.
> >>>>
> >>>> I am not sure it is ok to discuss such a topic in this mail, but I
> >> failed to find github issues system for Calcite.
> >>>>
> >>>> Best regards,
> >>>> Zhihong SHEN
> >>>> ———————————————
> >>>> Zhihong SHEN, Ph. D., Senior Engineer
> >>>> Big Data Application Service Technology Laboratory,
> >>>> Computer Network Information Center, Chinese Academy of Sciences
> >>>> office phone:+86-10-58812516
> >>>> mobile：+86-13671116520
>
>
Re: solr-sql: adapter for solr cloud
Posted by Julian Hyde <jh...@apache.org>.
Thanks for sharing. I upgraded Solr (because 6.1.0-SNAPSHOT is no longer available at apache.org <http://apache.org/>) and everything works fine.
I created a PR: https://github.com/risdenk/solr-calcite-example/pull/1 <https://github.com/risdenk/solr-calcite-example/pull/1>
Julian
> On Sep 20, 2016, at 3:29 PM, Kevin Risden <co...@gmail.com> wrote:
>
> Just wanted to throw this out there in case it is helpful and prompts any
> ideas/improvements:
>
> I was attempting to integrate Apache Calcite into Apache Solr proper and
> along the way created this repo for testing:
>
> https://github.com/risdenk/solr-calcite-example <https://github.com/risdenk/solr-calcite-example>
>
> It was originally meant for my testing of push down rules and tightly
> integrating into Solr 6 parallel sql. The end goal was to integrate into
> Apache Solr SQL handler. The relevant Solr JIRA is
> https://issues.apache.org/jira/browse/SOLR-8593 <https://issues.apache.org/jira/browse/SOLR-8593>
>
> I haven't had a chance to get back to it in the past few months though. In
> about a month, I am presenting on Solr JDBC at the Lucene/Solr Revolution
> in Boston. I'm hoping to have time to cleanup the integration with Calcite
> for a demo, but we will see based on time.
>
> Kevin Risden
>
> On Tue, Sep 6, 2016 at 9:41 PM, bluejoe <bluejoe@cnic.cn <ma...@cnic.cn>> wrote:
>
>> That's great!
>> Thank you very much!
>>
>> Best regards,
>> Zhihong SHEN
>> ———————————————
>> Zhihong SHEN, Ph. D., Senior Engineer
>> Big Data Application Service Technology Laboratory,
>> Computer Network Information Center, Chinese Academy of Sciences
>> office phone:+86-10-58812516
>> mobile：+86-13671116520
>>
>>
>>
>>
>>
>>
>>
>>
>> 在 16/9/7 上午10:33，“Julian Hyde”<dev-return-3760-bluejoe=
>> cnic.cn@calcite.apache.org <ma...@calcite.apache.org> 代表 jhyde@apache.org <ma...@apache.org>> 写入:
>>
>>> This mailing list is the perfect place to discuss this. (For future
>> reference, for issues we use Apache JIRA[1], not github issues.)
>>>
>>> We’d be happy to add a mention of your adapter to the site. It could go
>> into the Adapters page[2]. Edit the source of that page[3] and create a
>> pull request.
>>>
>>> And by the way, there is also a “powered by Calcite” page for companies
>> and projects that use Calcite[4]. Anyone who wants to add their
>> company/project should see instructions at the bottom of that page.
>>>
>>> Julian
>>>
>>> [1] https://issues.apache.org/jira/browse/CALCITE
>>>
>>> [2] https://calcite.apache.org/docs/adapter.html <
>> https://calcite.apache.org/docs/adapter.html <https://calcite.apache.org/docs/adapter.html>>
>>>
>>> [3] https://github.com/apache/calcite/blob/master/site/_docs/adapter.md <https://github.com/apache/calcite/blob/master/site/_docs/adapter.md> <
>> https://github.com/apache/calcite/blob/master/site/_docs/adapter.md <https://github.com/apache/calcite/blob/master/site/_docs/adapter.md>>
>>>
>>> [4] https://calcite.apache.org/docs/powered_by.html <https://calcite.apache.org/docs/powered_by.html> <
>> https://calcite.apache.org/docs/powered_by.html <https://calcite.apache.org/docs/powered_by.html>>
>>>
>>>
>>>> On Sep 6, 2016, at 7:18 PM, bluejoe <bl...@cnic.cn> wrote:
>>>>
>>>> Hi, all
>>>>
>>>> I am a Calcite user from China. Calcite is very powerful and the
>> abstraction work is very prefect.
>>>>
>>>> Now I am working on solr-sql project, which implements a Calcite
>> adapter to provide sql interfaces for solr(see https://github.com/
>> bluejoe2008/solr-sql). Can Calcite add links to my project on Web pages
>> thus people who are looking for similar solutions can find it and give me
>> more advices.
>>>>
>>>> I am not sure it is ok to discuss such a topic in this mail, but I
>> failed to find github issues system for Calcite.
>>>>
>>>> Best regards,
>>>> Zhihong SHEN
>>>> ———————————————
>>>> Zhihong SHEN, Ph. D., Senior Engineer
>>>> Big Data Application Service Technology Laboratory,
>>>> Computer Network Information Center, Chinese Academy of Sciences
>>>> office phone:+86-10-58812516
>>>> mobile：+86-13671116520
Re: solr-sql: adapter for solr cloud
Posted by Kevin Risden <co...@gmail.com>.
Just wanted to throw this out there in case it is helpful and prompts any
ideas/improvements:
I was attempting to integrate Apache Calcite into Apache Solr proper and
along the way created this repo for testing:
https://github.com/risdenk/solr-calcite-example
It was originally meant for my testing of push down rules and tightly
integrating into Solr 6 parallel sql. The end goal was to integrate into
Apache Solr SQL handler. The relevant Solr JIRA is
https://issues.apache.org/jira/browse/SOLR-8593
I haven't had a chance to get back to it in the past few months though. In
about a month, I am presenting on Solr JDBC at the Lucene/Solr Revolution
in Boston. I'm hoping to have time to cleanup the integration with Calcite
for a demo, but we will see based on time.
Kevin Risden
On Tue, Sep 6, 2016 at 9:41 PM, bluejoe <bl...@cnic.cn> wrote:
> That's great!
> Thank you very much!
>
> Best regards,
> Zhihong SHEN
> ———————————————
> Zhihong SHEN, Ph. D., Senior Engineer
> Big Data Application Service Technology Laboratory,
> Computer Network Information Center, Chinese Academy of Sciences
> office phone:+86-10-58812516
> mobile：+86-13671116520
>
>
>
>
>
>
>
>
> 在 16/9/7 上午10:33，“Julian Hyde”<dev-return-3760-bluejoe=
> cnic.cn@calcite.apache.org 代表 jhyde@apache.org> 写入:
>
> >This mailing list is the perfect place to discuss this. (For future
> reference, for issues we use Apache JIRA[1], not github issues.)
> >
> >We’d be happy to add a mention of your adapter to the site. It could go
> into the Adapters page[2]. Edit the source of that page[3] and create a
> pull request.
> >
> >And by the way, there is also a “powered by Calcite” page for companies
> and projects that use Calcite[4]. Anyone who wants to add their
> company/project should see instructions at the bottom of that page.
> >
> >Julian
> >
> >[1] https://issues.apache.org/jira/browse/CALCITE
> >
> >[2] https://calcite.apache.org/docs/adapter.html <
> https://calcite.apache.org/docs/adapter.html>
> >
> >[3] https://github.com/apache/calcite/blob/master/site/_docs/adapter.md <
> https://github.com/apache/calcite/blob/master/site/_docs/adapter.md>
> >
> >[4] https://calcite.apache.org/docs/powered_by.html <
> https://calcite.apache.org/docs/powered_by.html>
> >
> >
> >> On Sep 6, 2016, at 7:18 PM, bluejoe <bl...@cnic.cn> wrote:
> >>
> >> Hi, all
> >>
> >> I am a Calcite user from China. Calcite is very powerful and the
> abstraction work is very prefect.
> >>
> >> Now I am working on solr-sql project, which implements a Calcite
> adapter to provide sql interfaces for solr(see https://github.com/
> bluejoe2008/solr-sql). Can Calcite add links to my project on Web pages
> thus people who are looking for similar solutions can find it and give me
> more advices.
> >>
> >> I am not sure it is ok to discuss such a topic in this mail, but I
> failed to find github issues system for Calcite.
> >>
> >> Best regards,
> >> Zhihong SHEN
> >> ———————————————
> >> Zhihong SHEN, Ph. D., Senior Engineer
> >> Big Data Application Service Technology Laboratory,
> >> Computer Network Information Center, Chinese Academy of Sciences
> >> office phone:+86-10-58812516
> >> mobile：+86-13671116520
> >>
> >
>
>
>
Re: solr-sql: adapter for solr cloud
Posted by bluejoe <bl...@cnic.cn>.
That's great!
Thank you very much!
Best regards,
Zhihong SHEN
———————————————
Zhihong SHEN, Ph. D., Senior Engineer
Big Data Application Service Technology Laboratory,
Computer Network Information Center, Chinese Academy of Sciences
office phone:+86-10-58812516
mobile：+86-13671116520
在 16/9/7 上午10:33，“Julian Hyde”<dev-return-3760-bluejoe=cnic.cn@calcite.apache.org 代表 jhyde@apache.org> 写入:
>This mailing list is the perfect place to discuss this. (For future reference, for issues we use Apache JIRA[1], not github issues.)
>
>We’d be happy to add a mention of your adapter to the site. It could go into the Adapters page[2]. Edit the source of that page[3] and create a pull request.
>
>And by the way, there is also a “powered by Calcite” page for companies and projects that use Calcite[4]. Anyone who wants to add their company/project should see instructions at the bottom of that page.
>
>Julian
>
>[1] https://issues.apache.org/jira/browse/CALCITE
>
>[2] https://calcite.apache.org/docs/adapter.html <https://calcite.apache.org/docs/adapter.html>
>
>[3] https://github.com/apache/calcite/blob/master/site/_docs/adapter.md <https://github.com/apache/calcite/blob/master/site/_docs/adapter.md>
>
>[4] https://calcite.apache.org/docs/powered_by.html <https://calcite.apache.org/docs/powered_by.html>
>
>
>> On Sep 6, 2016, at 7:18 PM, bluejoe <bl...@cnic.cn> wrote:
>>
>> Hi, all
>>
>> I am a Calcite user from China. Calcite is very powerful and the abstraction work is very prefect.
>>
>> Now I am working on solr-sql project, which implements a Calcite adapter to provide sql interfaces for solr(see https://github.com/bluejoe2008/solr-sql). Can Calcite add links to my project on Web pages thus people who are looking for similar solutions can find it and give me more advices.
>>
>> I am not sure it is ok to discuss such a topic in this mail, but I failed to find github issues system for Calcite.
>>
>> Best regards,
>> Zhihong SHEN
>> ———————————————
>> Zhihong SHEN, Ph. D., Senior Engineer
>> Big Data Application Service Technology Laboratory,
>> Computer Network Information Center, Chinese Academy of Sciences
>> office phone:+86-10-58812516
>> mobile：+86-13671116520
>>
>
Re: solr-sql: adapter for solr cloud
Posted by Julian Hyde <jh...@apache.org>.
This mailing list is the perfect place to discuss this. (For future reference, for issues we use Apache JIRA[1], not github issues.)
We’d be happy to add a mention of your adapter to the site. It could go into the Adapters page[2]. Edit the source of that page[3] and create a pull request.
And by the way, there is also a “powered by Calcite” page for companies and projects that use Calcite[4]. Anyone who wants to add their company/project should see instructions at the bottom of that page.
Julian
[1] https://issues.apache.org/jira/browse/CALCITE
[2] https://calcite.apache.org/docs/adapter.html <https://calcite.apache.org/docs/adapter.html>
[3] https://github.com/apache/calcite/blob/master/site/_docs/adapter.md <https://github.com/apache/calcite/blob/master/site/_docs/adapter.md>
[4] https://calcite.apache.org/docs/powered_by.html <https://calcite.apache.org/docs/powered_by.html>
> On Sep 6, 2016, at 7:18 PM, bluejoe <bl...@cnic.cn> wrote:
>
> Hi, all
>
> I am a Calcite user from China. Calcite is very powerful and the abstraction work is very prefect.
>
> Now I am working on solr-sql project, which implements a Calcite adapter to provide sql interfaces for solr(see https://github.com/bluejoe2008/solr-sql). Can Calcite add links to my project on Web pages thus people who are looking for similar solutions can find it and give me more advices.
>
> I am not sure it is ok to discuss such a topic in this mail, but I failed to find github issues system for Calcite.
>
> Best regards,
> Zhihong SHEN
> ———————————————
> Zhihong SHEN, Ph. D., Senior Engineer
> Big Data Application Service Technology Laboratory,
> Computer Network Information Center, Chinese Academy of Sciences
> office phone:+86-10-58812516
> mobile：+86-13671116520
>