You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by victor <35...@qq.com> on 2017/12/02 02:03:39 UTC
query about avatica odbc
Hi, calcite development team:
we now use calcite for some databases development , the calcite gives us a lot of convenience, thanks all of you. but it seems there has not an odbc driver for avatica, do you have some plan for odbc driver developing, please let me know as soon as possible,
thanks a lot,
yours best regards
victor lv
Re: query about avatica odbc
Posted by Michael Mior <mm...@uwaterloo.ca>.
Thanks for sharing Oleksiy! Any objections to us adding XAP to the Calcite
website? (https://calcite.apache.org/docs/powered_by.html)
--
Michael Mior
mmior@apache.org
2017-12-07 9:56 GMT-05:00 aka.fe2s <ak...@gmail.com>:
> Hi,
>
> I've managed to use ODBC-JDBC bridge with Calcite, and then connect Tableau
> via ODBC.
>
> Some details are available here
> https://speakerdeck.com/fe2s/how-we-built-sql-driver-for-
> in-memory-data-grid
>
> --
> Oleksiy
>
> On Wed, Dec 6, 2017 at 9:53 PM, Julian Hyde <jh...@apache.org> wrote:
>
> > +1
> >
> >
> > > On Dec 6, 2017, at 11:37 AM, Josh Elser <el...@apache.org> wrote:
> > >
> > > Yeah, the Phoenix ODBC driver is (sadly) not open source. It would be
> > great if it could be, but I haven't been able to make any strides there.
> > >
> > > On 12/4/17 12:26 PM, Luis Fernando Kauer wrote:
> > >> ODBC driver would be great.
> > >> Apache Phoenix ODBC Driver seems to be provided by HortonWorks (not
> > open source):
> > >> https://br.hortonworks.com/hadoop-tutorial/bi-apache-phoenix-odbc/
> > >> Apache Drill has ODBC Driver too, but it seems to be provided by MapR
> > (not open source).
> > >> However, Kylin has ODBC Driver and it is open source (Apache License):
> > >> https://github.com/KylinOLAP/odbc-driver
> > >> Maybe that can be used to get started.
> > >> Em segunda-feira, 4 de dezembro de 2017 10:40:20 BRST, Christian
> > Tzolov <ct...@pivotal.io> escreveu:
> > >> Avatica ODBC driver would be handy (and good selling i guess)
> feature
> > >> indeed!
> > >> @Josh, the documentation mentions that Apache Phoenix have ODBC
> > >> implementation over the avatica protocol but i couldn't find any code
> or
> > >> even further info? I guess it is a proprietary/commercial project?
> > >> Last week i've troubled myself trying to setup on my MacOS the
> OpenLink
> > >> ODBC-to-JDBC bridge (http://bit.ly/2AWpbhU) for calcite jdbc. It was
> a
> > >> complete failure and in the process I almost scrutinized my
> environment.
> > >> The bridge is monstrous approach to start with but just out of
> > curiosity,
> > >> has anyone every succeeded plugging avatica jdbc in such odbc-jdbc
> > bridge?
> > >> On 4 December 2017 at 06:24, Josh Elser <el...@apache.org> wrote:
> > >>> Hi Victor,
> > >>>
> > >>> An ODBC driver for Avatica would be a great addition to the project,
> > but I
> > >>> am not aware of anyone who has volunteered to take on this
> development
> > >>> effort.
> > >>>
> > >>> On 12/1/17 9:03 PM, victor wrote:
> > >>>
> > >>>> Hi, calcite development team:
> > >>>> we now use calcite for some databases development , the
> > calcite
> > >>>> gives us a lot of convenience, thanks all of you. but it seems there
> > has
> > >>>> not an odbc driver for avatica, do you have some plan for odbc
> driver
> > >>>> developing, please let me know as soon as possible,
> > >>>> thanks a lot,
> > >>>>
> > >>>>
> > >>>> yours best regards
> > >>>>
> > >>>>
> > >>>> victor lv
> > >>>>
> > >>>>
> >
> >
>
Re: query about avatica odbc
Posted by "aka.fe2s" <ak...@gmail.com>.
Hi,
I've managed to use ODBC-JDBC bridge with Calcite, and then connect Tableau
via ODBC.
Some details are available here
https://speakerdeck.com/fe2s/how-we-built-sql-driver-for-in-memory-data-grid
--
Oleksiy
On Wed, Dec 6, 2017 at 9:53 PM, Julian Hyde <jh...@apache.org> wrote:
> +1
>
>
> > On Dec 6, 2017, at 11:37 AM, Josh Elser <el...@apache.org> wrote:
> >
> > Yeah, the Phoenix ODBC driver is (sadly) not open source. It would be
> great if it could be, but I haven't been able to make any strides there.
> >
> > On 12/4/17 12:26 PM, Luis Fernando Kauer wrote:
> >> ODBC driver would be great.
> >> Apache Phoenix ODBC Driver seems to be provided by HortonWorks (not
> open source):
> >> https://br.hortonworks.com/hadoop-tutorial/bi-apache-phoenix-odbc/
> >> Apache Drill has ODBC Driver too, but it seems to be provided by MapR
> (not open source).
> >> However, Kylin has ODBC Driver and it is open source (Apache License):
> >> https://github.com/KylinOLAP/odbc-driver
> >> Maybe that can be used to get started.
> >> Em segunda-feira, 4 de dezembro de 2017 10:40:20 BRST, Christian
> Tzolov <ct...@pivotal.io> escreveu:
> >> Avatica ODBC driver would be handy (and good selling i guess) feature
> >> indeed!
> >> @Josh, the documentation mentions that Apache Phoenix have ODBC
> >> implementation over the avatica protocol but i couldn't find any code or
> >> even further info? I guess it is a proprietary/commercial project?
> >> Last week i've troubled myself trying to setup on my MacOS the OpenLink
> >> ODBC-to-JDBC bridge (http://bit.ly/2AWpbhU) for calcite jdbc. It was a
> >> complete failure and in the process I almost scrutinized my environment.
> >> The bridge is monstrous approach to start with but just out of
> curiosity,
> >> has anyone every succeeded plugging avatica jdbc in such odbc-jdbc
> bridge?
> >> On 4 December 2017 at 06:24, Josh Elser <el...@apache.org> wrote:
> >>> Hi Victor,
> >>>
> >>> An ODBC driver for Avatica would be a great addition to the project,
> but I
> >>> am not aware of anyone who has volunteered to take on this development
> >>> effort.
> >>>
> >>> On 12/1/17 9:03 PM, victor wrote:
> >>>
> >>>> Hi, calcite development team:
> >>>> we now use calcite for some databases development , the
> calcite
> >>>> gives us a lot of convenience, thanks all of you. but it seems there
> has
> >>>> not an odbc driver for avatica, do you have some plan for odbc driver
> >>>> developing, please let me know as soon as possible,
> >>>> thanks a lot,
> >>>>
> >>>>
> >>>> yours best regards
> >>>>
> >>>>
> >>>> victor lv
> >>>>
> >>>>
>
>
Re: query about avatica odbc
Posted by Julian Hyde <jh...@apache.org>.
+1
> On Dec 6, 2017, at 11:37 AM, Josh Elser <el...@apache.org> wrote:
>
> Yeah, the Phoenix ODBC driver is (sadly) not open source. It would be great if it could be, but I haven't been able to make any strides there.
>
> On 12/4/17 12:26 PM, Luis Fernando Kauer wrote:
>> ODBC driver would be great.
>> Apache Phoenix ODBC Driver seems to be provided by HortonWorks (not open source):
>> https://br.hortonworks.com/hadoop-tutorial/bi-apache-phoenix-odbc/
>> Apache Drill has ODBC Driver too, but it seems to be provided by MapR (not open source).
>> However, Kylin has ODBC Driver and it is open source (Apache License):
>> https://github.com/KylinOLAP/odbc-driver
>> Maybe that can be used to get started.
>> Em segunda-feira, 4 de dezembro de 2017 10:40:20 BRST, Christian Tzolov <ct...@pivotal.io> escreveu:
>> Avatica ODBC driver would be handy (and good selling i guess) feature
>> indeed!
>> @Josh, the documentation mentions that Apache Phoenix have ODBC
>> implementation over the avatica protocol but i couldn't find any code or
>> even further info? I guess it is a proprietary/commercial project?
>> Last week i've troubled myself trying to setup on my MacOS the OpenLink
>> ODBC-to-JDBC bridge (http://bit.ly/2AWpbhU) for calcite jdbc. It was a
>> complete failure and in the process I almost scrutinized my environment.
>> The bridge is monstrous approach to start with but just out of curiosity,
>> has anyone every succeeded plugging avatica jdbc in such odbc-jdbc bridge?
>> On 4 December 2017 at 06:24, Josh Elser <el...@apache.org> wrote:
>>> Hi Victor,
>>>
>>> An ODBC driver for Avatica would be a great addition to the project, but I
>>> am not aware of anyone who has volunteered to take on this development
>>> effort.
>>>
>>> On 12/1/17 9:03 PM, victor wrote:
>>>
>>>> Hi, calcite development team:
>>>> we now use calcite for some databases development , the calcite
>>>> gives us a lot of convenience, thanks all of you. but it seems there has
>>>> not an odbc driver for avatica, do you have some plan for odbc driver
>>>> developing, please let me know as soon as possible,
>>>> thanks a lot,
>>>>
>>>>
>>>> yours best regards
>>>>
>>>>
>>>> victor lv
>>>>
>>>>
Re: query about avatica odbc
Posted by Josh Elser <el...@apache.org>.
Yeah, the Phoenix ODBC driver is (sadly) not open source. It would be
great if it could be, but I haven't been able to make any strides there.
On 12/4/17 12:26 PM, Luis Fernando Kauer wrote:
> ODBC driver would be great.
>
> Apache Phoenix ODBC Driver seems to be provided by HortonWorks (not open source):
> https://br.hortonworks.com/hadoop-tutorial/bi-apache-phoenix-odbc/
>
>
>
> Apache Drill has ODBC Driver too, but it seems to be provided by MapR (not open source).
>
>
> However, Kylin has ODBC Driver and it is open source (Apache License):
> https://github.com/KylinOLAP/odbc-driver
>
>
>
> Maybe that can be used to get started.
> Em segunda-feira, 4 de dezembro de 2017 10:40:20 BRST, Christian Tzolov <ct...@pivotal.io> escreveu:
>
> Avatica ODBC driver would be handy (and good selling i guess) feature
> indeed!
>
> @Josh, the documentation mentions that Apache Phoenix have ODBC
> implementation over the avatica protocol but i couldn't find any code or
> even further info? I guess it is a proprietary/commercial project?
>
> Last week i've troubled myself trying to setup on my MacOS the OpenLink
> ODBC-to-JDBC bridge (http://bit.ly/2AWpbhU) for calcite jdbc. It was a
> complete failure and in the process I almost scrutinized my environment.
> The bridge is monstrous approach to start with but just out of curiosity,
> has anyone every succeeded plugging avatica jdbc in such odbc-jdbc bridge?
>
>
>
> On 4 December 2017 at 06:24, Josh Elser <el...@apache.org> wrote:
>
>> Hi Victor,
>>
>> An ODBC driver for Avatica would be a great addition to the project, but I
>> am not aware of anyone who has volunteered to take on this development
>> effort.
>>
>> On 12/1/17 9:03 PM, victor wrote:
>>
>>> Hi, calcite development team:
>>> we now use calcite for some databases development , the calcite
>>> gives us a lot of convenience, thanks all of you. but it seems there has
>>> not an odbc driver for avatica, do you have some plan for odbc driver
>>> developing, please let me know as soon as possible,
>>> thanks a lot,
>>>
>>>
>>> yours best regards
>>>
>>>
>>> victor lv
>>>
>>>
>
>
Re: query about avatica odbc
Posted by Laurent Goujon <la...@dremio.com>.
Apache Drill ODBC driver is not based on the Avatica protocol but on the
Drill RPC protocol (Drill uses Avatica for the JDBC driver as a framework).
The C++ RPC logic is open source (
https://github.com/apache/drill/tree/master/contrib/native/client) but the
ODBC adaptation layer is closed source.
Laurent
On Mon, Dec 4, 2017 at 9:26 AM, Luis Fernando Kauer <
lfkauer@yahoo.com.br.invalid> wrote:
> ODBC driver would be great.
>
> Apache Phoenix ODBC Driver seems to be provided by HortonWorks (not open
> source):
> https://br.hortonworks.com/hadoop-tutorial/bi-apache-phoenix-odbc/
>
>
>
> Apache Drill has ODBC Driver too, but it seems to be provided by MapR (not
> open source).
>
>
> However, Kylin has ODBC Driver and it is open source (Apache License):
> https://github.com/KylinOLAP/odbc-driver
>
>
>
> Maybe that can be used to get started.
> Em segunda-feira, 4 de dezembro de 2017 10:40:20 BRST, Christian Tzolov
> <ct...@pivotal.io> escreveu:
>
> Avatica ODBC driver would be handy (and good selling i guess) feature
> indeed!
>
> @Josh, the documentation mentions that Apache Phoenix have ODBC
> implementation over the avatica protocol but i couldn't find any code or
> even further info? I guess it is a proprietary/commercial project?
>
> Last week i've troubled myself trying to setup on my MacOS the OpenLink
> ODBC-to-JDBC bridge (http://bit.ly/2AWpbhU) for calcite jdbc. It was a
> complete failure and in the process I almost scrutinized my environment.
> The bridge is monstrous approach to start with but just out of curiosity,
> has anyone every succeeded plugging avatica jdbc in such odbc-jdbc bridge?
>
>
>
> On 4 December 2017 at 06:24, Josh Elser <el...@apache.org> wrote:
>
> > Hi Victor,
> >
> > An ODBC driver for Avatica would be a great addition to the project, but
> I
> > am not aware of anyone who has volunteered to take on this development
> > effort.
> >
> > On 12/1/17 9:03 PM, victor wrote:
> >
> >> Hi, calcite development team:
> >> we now use calcite for some databases development , the
> calcite
> >> gives us a lot of convenience, thanks all of you. but it seems there has
> >> not an odbc driver for avatica, do you have some plan for odbc driver
> >> developing, please let me know as soon as possible,
> >> thanks a lot,
> >>
> >>
> >> yours best regards
> >>
> >>
> >> victor lv
> >>
> >>
>
>
> --
> Christian Tzolov <http://www.linkedin.com/in/tzolov> | Principle Software
> Engineer | Spring <https://spring.io/>.io | Pivotal <http://pivotal.io/> |
> ctzolov@pivotal.io
>
>
Re: query about avatica odbc
Posted by Kevin Risden <kr...@apache.org>.
It looks like development of the Kylin ODBC driver is here now:
https://github.com/apache/kylin/tree/master/odbc
Took a bit of digging to find.
Kevin Risden
On Mon, Dec 4, 2017 at 11:26 AM, Luis Fernando Kauer <
lfkauer@yahoo.com.br.invalid> wrote:
> ODBC driver would be great.
>
> Apache Phoenix ODBC Driver seems to be provided by HortonWorks (not open
> source):
> https://br.hortonworks.com/hadoop-tutorial/bi-apache-phoenix-odbc/
>
>
>
> Apache Drill has ODBC Driver too, but it seems to be provided by MapR (not
> open source).
>
>
> However, Kylin has ODBC Driver and it is open source (Apache License):
> https://github.com/KylinOLAP/odbc-driver
>
>
>
> Maybe that can be used to get started.
> Em segunda-feira, 4 de dezembro de 2017 10:40:20 BRST, Christian Tzolov
> <ct...@pivotal.io> escreveu:
>
> Avatica ODBC driver would be handy (and good selling i guess) feature
> indeed!
>
> @Josh, the documentation mentions that Apache Phoenix have ODBC
> implementation over the avatica protocol but i couldn't find any code or
> even further info? I guess it is a proprietary/commercial project?
>
> Last week i've troubled myself trying to setup on my MacOS the OpenLink
> ODBC-to-JDBC bridge (http://bit.ly/2AWpbhU) for calcite jdbc. It was a
> complete failure and in the process I almost scrutinized my environment.
> The bridge is monstrous approach to start with but just out of curiosity,
> has anyone every succeeded plugging avatica jdbc in such odbc-jdbc bridge?
>
>
>
> On 4 December 2017 at 06:24, Josh Elser <el...@apache.org> wrote:
>
> > Hi Victor,
> >
> > An ODBC driver for Avatica would be a great addition to the project, but
> I
> > am not aware of anyone who has volunteered to take on this development
> > effort.
> >
> > On 12/1/17 9:03 PM, victor wrote:
> >
> >> Hi, calcite development team:
> >> we now use calcite for some databases development , the
> calcite
> >> gives us a lot of convenience, thanks all of you. but it seems there has
> >> not an odbc driver for avatica, do you have some plan for odbc driver
> >> developing, please let me know as soon as possible,
> >> thanks a lot,
> >>
> >>
> >> yours best regards
> >>
> >>
> >> victor lv
> >>
> >>
>
>
> --
> Christian Tzolov <http://www.linkedin.com/in/tzolov> | Principle Software
> Engineer | Spring <https://spring.io/>.io | Pivotal <http://pivotal.io/> |
> ctzolov@pivotal.io
>
>
Re: query about avatica odbc
Posted by Luis Fernando Kauer <lf...@yahoo.com.br.INVALID>.
ODBC driver would be great.
Apache Phoenix ODBC Driver seems to be provided by HortonWorks (not open source):
https://br.hortonworks.com/hadoop-tutorial/bi-apache-phoenix-odbc/
Apache Drill has ODBC Driver too, but it seems to be provided by MapR (not open source).
However, Kylin has ODBC Driver and it is open source (Apache License):
https://github.com/KylinOLAP/odbc-driver
Maybe that can be used to get started.
Em segunda-feira, 4 de dezembro de 2017 10:40:20 BRST, Christian Tzolov <ct...@pivotal.io> escreveu:
Avatica ODBC driver would be handy (and good selling i guess) feature
indeed!
@Josh, the documentation mentions that Apache Phoenix have ODBC
implementation over the avatica protocol but i couldn't find any code or
even further info? I guess it is a proprietary/commercial project?
Last week i've troubled myself trying to setup on my MacOS the OpenLink
ODBC-to-JDBC bridge (http://bit.ly/2AWpbhU) for calcite jdbc. It was a
complete failure and in the process I almost scrutinized my environment.
The bridge is monstrous approach to start with but just out of curiosity,
has anyone every succeeded plugging avatica jdbc in such odbc-jdbc bridge?
On 4 December 2017 at 06:24, Josh Elser <el...@apache.org> wrote:
> Hi Victor,
>
> An ODBC driver for Avatica would be a great addition to the project, but I
> am not aware of anyone who has volunteered to take on this development
> effort.
>
> On 12/1/17 9:03 PM, victor wrote:
>
>> Hi, calcite development team:
>> we now use calcite for some databases development , the calcite
>> gives us a lot of convenience, thanks all of you. but it seems there has
>> not an odbc driver for avatica, do you have some plan for odbc driver
>> developing, please let me know as soon as possible,
>> thanks a lot,
>>
>>
>> yours best regards
>>
>>
>> victor lv
>>
>>
--
Christian Tzolov <http://www.linkedin.com/in/tzolov> | Principle Software
Engineer | Spring <https://spring.io/>.io | Pivotal <http://pivotal.io/> |
ctzolov@pivotal.io
Re: query about avatica odbc
Posted by Christian Tzolov <ct...@pivotal.io>.
Avatica ODBC driver would be handy (and good selling i guess) feature
indeed!
@Josh, the documentation mentions that Apache Phoenix have ODBC
implementation over the avatica protocol but i couldn't find any code or
even further info? I guess it is a proprietary/commercial project?
Last week i've troubled myself trying to setup on my MacOS the OpenLink
ODBC-to-JDBC bridge (http://bit.ly/2AWpbhU) for calcite jdbc. It was a
complete failure and in the process I almost scrutinized my environment.
The bridge is monstrous approach to start with but just out of curiosity,
has anyone every succeeded plugging avatica jdbc in such odbc-jdbc bridge?
On 4 December 2017 at 06:24, Josh Elser <el...@apache.org> wrote:
> Hi Victor,
>
> An ODBC driver for Avatica would be a great addition to the project, but I
> am not aware of anyone who has volunteered to take on this development
> effort.
>
> On 12/1/17 9:03 PM, victor wrote:
>
>> Hi, calcite development team:
>> we now use calcite for some databases development , the calcite
>> gives us a lot of convenience, thanks all of you. but it seems there has
>> not an odbc driver for avatica, do you have some plan for odbc driver
>> developing, please let me know as soon as possible,
>> thanks a lot,
>>
>>
>> yours best regards
>>
>>
>> victor lv
>>
>>
--
Christian Tzolov <http://www.linkedin.com/in/tzolov> | Principle Software
Engineer | Spring <https://spring.io/>.io | Pivotal <http://pivotal.io/> |
ctzolov@pivotal.io
Re: query about avatica odbc
Posted by Josh Elser <el...@apache.org>.
Hi Victor,
An ODBC driver for Avatica would be a great addition to the project, but
I am not aware of anyone who has volunteered to take on this development
effort.
On 12/1/17 9:03 PM, victor wrote:
> Hi, calcite development team:
> we now use calcite for some databases development , the calcite gives us a lot of convenience, thanks all of you. but it seems there has not an odbc driver for avatica, do you have some plan for odbc driver developing, please let me know as soon as possible,
> thanks a lot,
>
>
> yours best regards
>
>
> victor lv
>