You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Nishith Maheshwari <ns...@gmail.com> on 2015/05/27 08:39:14 UTC
JAVA API for Drill
Hi,
I wanted to create a java application to connect and query over a HBase
database using Drill, but was unable to find any documentation regarding
this.
Is there a JAVA api through which Drill can be accessed? I did see a small
mention of C++ and JAVA api in the documentation but there was no other
link or information regarding the same.
Regards,
Nishith Maheshwari
AW: JAVA API for Drill
Posted by "MOIS Martin (MORPHO)" <ma...@morpho.com>.
Hi,
you can use the JDBC driver shipped with the distribution, to execute SQL queries against an HBase database:
String className = "org.apache.drill.jdbc.Driver";
try {
Class.forName(className);
} catch (ClassNotFoundException e) {
System.err.println("Failed to load JDBC driver '" + className + "': " + e.getMessage());
}
String jdbcUrl = " jdbc:drill:zk=<yourIP>:2181/drill/drillbits1;schema=hbase";
try (Connection con = java.sql.DriverManager.getConnection(jdbcUrl); Statement stmt = con.createStatement()) {
...
}
...
Best Regards,
Martin Mois
-----Ursprüngliche Nachricht-----
Von: Nishith Maheshwari [mailto:nshthm@gmail.com]
Gesendet: Mittwoch, 27. Mai 2015 08:39
An: user@drill.apache.org
Betreff: JAVA API for Drill
Hi,
I wanted to create a java application to connect and query over a HBase database using Drill, but was unable to find any documentation regarding this.
Is there a JAVA api through which Drill can be accessed? I did see a small mention of C++ and JAVA api in the documentation but there was no other link or information regarding the same.
Regards,
Nishith Maheshwari
#
" This e-mail and any attached documents may contain confidential or proprietary information. If you are not the intended recipient, you are notified that any dissemination, copying of this e-mail and any attachments thereto or use of their contents by any means whatsoever is strictly prohibited. If you have received this e-mail in error, please advise the sender immediately and delete this e-mail and all attached documents from your computer system."
#
Re: JAVA API for Drill
Posted by Sudheesh Katkam <sk...@maprtech.com>.
Adding to Hanifi’s comment. Loot at QueryWrapper#run method and QueryWrapper$Listener
https://github.com/hnfgns/incubator-drill/blob/master/exec/java-exec/src/main/java/org/apache/drill/exec/server/rest/QueryWrapper.java <https://github.com/hnfgns/incubator-drill/blob/master/exec/java-exec/src/main/java/org/apache/drill/exec/server/rest/QueryWrapper.java>
- Sudheesh
> On Jun 1, 2015, at 2:29 PM, Hanifi Gunes <hg...@maprtech.com> wrote:
>
> Have a look at QuerySubmitter
> <https://github.com/hnfgns/incubator-drill/blob/master/exec/java-exec/src/main/java/org/apache/drill/exec/client/QuerySubmitter.java>.
> It does boilerplate for posting queries on top DrillClient. All remains is
> to attach a result listener to perform your custom logic.
>
> -Hanifi
>
> On Mon, Jun 1, 2015 at 2:19 PM, Norris Lee <no...@simba.com> wrote:
>
>> Hi Nishith,
>>
>> As far as I know, I don't think there is any documentation on that.
>> Hopefully the function names are relatively self-explanatory. If not, feel
>> free to ask on this list for clarification.
>>
>> Norris
>>
>> -----Original Message-----
>> From: Nishith Maheshwari [mailto:nshthm@gmail.com]
>> Sent: Monday, June 01, 2015 4:19 AM
>> To: user@drill.apache.org
>> Subject: Re: JAVA API for Drill
>>
>> Thanks Norris
>>
>> Is there any documentation regarding the usage of these libraries and
>> functions? As in which function does what.
>>
>> Regards,
>> Nishith
>>
>> On Wed, May 27, 2015 at 10:06 PM, Norris Lee <no...@simba.com> wrote:
>>
>>> Hi Nishith,
>>>
>>> Take a look at the DrillClient.java and .cpp/.hpp classes of the
>>> project for the Java and C++ libraries respectively.
>>>
>>> Norris
>>>
>>> -----Original Message-----
>>> From: Nishith Maheshwari [mailto:nshthm@gmail.com]
>>> Sent: Wednesday, May 27, 2015 1:45 AM
>>> To: user@drill.apache.org
>>> Subject: Re: JAVA API for Drill
>>>
>>> Thank you Martin and Rajkumar for your prompt responses.
>>>
>>> I am actually looking if some API is available which provides this
>>> functionality. In the documentation it is mentioned in :
>>> https://drill.apache.org/docs/architecture-introduction -
>>>
>>> *You can connect to Apache Drill through the following interfaces:*
>>>
>>> - *Drill shell*
>>> - *Drill Web UI*
>>> - *ODBC
>>> <
>>> https://drill.apache.org/docs/odbc-jdbc-interfaces#using-odbc-to-acces
>>> s-apache-drill-from-bi-tools
>>>> **
>>> - *JDBC <https://drill.apache.org/docs/using-jdbc/>*
>>> - *C++ API*
>>>
>>>
>>> and in http://drill.apache.org/faq/ -
>>> *What clients are supported?*
>>>
>>> - *BI tools via the ODBC and JDBC drivers (eg, Tableau, Excel,
>>> MicroStrategy, Spotfire, QlikView, Business Objects)*
>>> - *Custom applications via the REST API*
>>> - *Java and C applications via the dedicated Java and C libraries*
>>>
>>>
>>> It would be great if you/somebody can point me to the C++ api or the
>>> dedicated JAVA library or API as mentioned in the documentation.
>>>
>>> Thanks and regards,
>>> Nishith Maheshwari
>>>
>>>
>>>
>>> On Wed, May 27, 2015 at 12:44 PM, Rajkumar Singh <rs...@maprtech.com>
>>> wrote:
>>>
>>>> Do you try drill-jdbc driver? I will suggest you to use java jdbc
>>>> connectivity to query drill using the drill-jdbc driver.I have not
>>>> tried this to query HBASE using drill but it should work if you have
>>>> correctly configured the HBase Storage plugin with the DRILL.
>>>>
>>>> Thanks
>>>>
>>>> Rajkumar Singh
>>>>
>>>>
>>>>
>>>>> On May 27, 2015, at 12:09 PM, Nishith Maheshwari
>>>>> <ns...@gmail.com>
>>>> wrote:
>>>>>
>>>>> Hi,
>>>>> I wanted to create a java application to connect and query over a
>>>>> HBase database using Drill, but was unable to find any
>>>>> documentation regarding this.
>>>>> Is there a JAVA api through which Drill can be accessed? I did see
>>>>> a
>>>> small
>>>>> mention of C++ and JAVA api in the documentation but there was no
>>>>> other link or information regarding the same.
>>>>>
>>>>> Regards,
>>>>> Nishith Maheshwari
>>>>
>>>>
>>>
>>
Re: JAVA API for Drill
Posted by Hanifi Gunes <hg...@maprtech.com>.
Have a look at QuerySubmitter
<https://github.com/hnfgns/incubator-drill/blob/master/exec/java-exec/src/main/java/org/apache/drill/exec/client/QuerySubmitter.java>.
It does boilerplate for posting queries on top DrillClient. All remains is
to attach a result listener to perform your custom logic.
-Hanifi
On Mon, Jun 1, 2015 at 2:19 PM, Norris Lee <no...@simba.com> wrote:
> Hi Nishith,
>
> As far as I know, I don't think there is any documentation on that.
> Hopefully the function names are relatively self-explanatory. If not, feel
> free to ask on this list for clarification.
>
> Norris
>
> -----Original Message-----
> From: Nishith Maheshwari [mailto:nshthm@gmail.com]
> Sent: Monday, June 01, 2015 4:19 AM
> To: user@drill.apache.org
> Subject: Re: JAVA API for Drill
>
> Thanks Norris
>
> Is there any documentation regarding the usage of these libraries and
> functions? As in which function does what.
>
> Regards,
> Nishith
>
> On Wed, May 27, 2015 at 10:06 PM, Norris Lee <no...@simba.com> wrote:
>
> > Hi Nishith,
> >
> > Take a look at the DrillClient.java and .cpp/.hpp classes of the
> > project for the Java and C++ libraries respectively.
> >
> > Norris
> >
> > -----Original Message-----
> > From: Nishith Maheshwari [mailto:nshthm@gmail.com]
> > Sent: Wednesday, May 27, 2015 1:45 AM
> > To: user@drill.apache.org
> > Subject: Re: JAVA API for Drill
> >
> > Thank you Martin and Rajkumar for your prompt responses.
> >
> > I am actually looking if some API is available which provides this
> > functionality. In the documentation it is mentioned in :
> > https://drill.apache.org/docs/architecture-introduction -
> >
> > *You can connect to Apache Drill through the following interfaces:*
> >
> > - *Drill shell*
> > - *Drill Web UI*
> > - *ODBC
> > <
> > https://drill.apache.org/docs/odbc-jdbc-interfaces#using-odbc-to-acces
> > s-apache-drill-from-bi-tools
> > >**
> > - *JDBC <https://drill.apache.org/docs/using-jdbc/>*
> > - *C++ API*
> >
> >
> > and in http://drill.apache.org/faq/ -
> > *What clients are supported?*
> >
> > - *BI tools via the ODBC and JDBC drivers (eg, Tableau, Excel,
> > MicroStrategy, Spotfire, QlikView, Business Objects)*
> > - *Custom applications via the REST API*
> > - *Java and C applications via the dedicated Java and C libraries*
> >
> >
> > It would be great if you/somebody can point me to the C++ api or the
> > dedicated JAVA library or API as mentioned in the documentation.
> >
> > Thanks and regards,
> > Nishith Maheshwari
> >
> >
> >
> > On Wed, May 27, 2015 at 12:44 PM, Rajkumar Singh <rs...@maprtech.com>
> > wrote:
> >
> > > Do you try drill-jdbc driver? I will suggest you to use java jdbc
> > > connectivity to query drill using the drill-jdbc driver.I have not
> > > tried this to query HBASE using drill but it should work if you have
> > > correctly configured the HBase Storage plugin with the DRILL.
> > >
> > > Thanks
> > >
> > > Rajkumar Singh
> > >
> > >
> > >
> > > > On May 27, 2015, at 12:09 PM, Nishith Maheshwari
> > > > <ns...@gmail.com>
> > > wrote:
> > > >
> > > > Hi,
> > > > I wanted to create a java application to connect and query over a
> > > > HBase database using Drill, but was unable to find any
> > > > documentation regarding this.
> > > > Is there a JAVA api through which Drill can be accessed? I did see
> > > > a
> > > small
> > > > mention of C++ and JAVA api in the documentation but there was no
> > > > other link or information regarding the same.
> > > >
> > > > Regards,
> > > > Nishith Maheshwari
> > >
> > >
> >
>
RE: JAVA API for Drill
Posted by Norris Lee <no...@simba.com>.
Hi Nishith,
As far as I know, I don't think there is any documentation on that. Hopefully the function names are relatively self-explanatory. If not, feel free to ask on this list for clarification.
Norris
-----Original Message-----
From: Nishith Maheshwari [mailto:nshthm@gmail.com]
Sent: Monday, June 01, 2015 4:19 AM
To: user@drill.apache.org
Subject: Re: JAVA API for Drill
Thanks Norris
Is there any documentation regarding the usage of these libraries and functions? As in which function does what.
Regards,
Nishith
On Wed, May 27, 2015 at 10:06 PM, Norris Lee <no...@simba.com> wrote:
> Hi Nishith,
>
> Take a look at the DrillClient.java and .cpp/.hpp classes of the
> project for the Java and C++ libraries respectively.
>
> Norris
>
> -----Original Message-----
> From: Nishith Maheshwari [mailto:nshthm@gmail.com]
> Sent: Wednesday, May 27, 2015 1:45 AM
> To: user@drill.apache.org
> Subject: Re: JAVA API for Drill
>
> Thank you Martin and Rajkumar for your prompt responses.
>
> I am actually looking if some API is available which provides this
> functionality. In the documentation it is mentioned in :
> https://drill.apache.org/docs/architecture-introduction -
>
> *You can connect to Apache Drill through the following interfaces:*
>
> - *Drill shell*
> - *Drill Web UI*
> - *ODBC
> <
> https://drill.apache.org/docs/odbc-jdbc-interfaces#using-odbc-to-acces
> s-apache-drill-from-bi-tools
> >**
> - *JDBC <https://drill.apache.org/docs/using-jdbc/>*
> - *C++ API*
>
>
> and in http://drill.apache.org/faq/ -
> *What clients are supported?*
>
> - *BI tools via the ODBC and JDBC drivers (eg, Tableau, Excel,
> MicroStrategy, Spotfire, QlikView, Business Objects)*
> - *Custom applications via the REST API*
> - *Java and C applications via the dedicated Java and C libraries*
>
>
> It would be great if you/somebody can point me to the C++ api or the
> dedicated JAVA library or API as mentioned in the documentation.
>
> Thanks and regards,
> Nishith Maheshwari
>
>
>
> On Wed, May 27, 2015 at 12:44 PM, Rajkumar Singh <rs...@maprtech.com>
> wrote:
>
> > Do you try drill-jdbc driver? I will suggest you to use java jdbc
> > connectivity to query drill using the drill-jdbc driver.I have not
> > tried this to query HBASE using drill but it should work if you have
> > correctly configured the HBase Storage plugin with the DRILL.
> >
> > Thanks
> >
> > Rajkumar Singh
> >
> >
> >
> > > On May 27, 2015, at 12:09 PM, Nishith Maheshwari
> > > <ns...@gmail.com>
> > wrote:
> > >
> > > Hi,
> > > I wanted to create a java application to connect and query over a
> > > HBase database using Drill, but was unable to find any
> > > documentation regarding this.
> > > Is there a JAVA api through which Drill can be accessed? I did see
> > > a
> > small
> > > mention of C++ and JAVA api in the documentation but there was no
> > > other link or information regarding the same.
> > >
> > > Regards,
> > > Nishith Maheshwari
> >
> >
>
Re: JAVA API for Drill
Posted by Nishith Maheshwari <ns...@gmail.com>.
Thanks Norris
Is there any documentation regarding the usage of these libraries and
functions? As in which function does what.
Regards,
Nishith
On Wed, May 27, 2015 at 10:06 PM, Norris Lee <no...@simba.com> wrote:
> Hi Nishith,
>
> Take a look at the DrillClient.java and .cpp/.hpp classes of the project
> for the Java and C++ libraries respectively.
>
> Norris
>
> -----Original Message-----
> From: Nishith Maheshwari [mailto:nshthm@gmail.com]
> Sent: Wednesday, May 27, 2015 1:45 AM
> To: user@drill.apache.org
> Subject: Re: JAVA API for Drill
>
> Thank you Martin and Rajkumar for your prompt responses.
>
> I am actually looking if some API is available which provides this
> functionality. In the documentation it is mentioned in :
> https://drill.apache.org/docs/architecture-introduction -
>
> *You can connect to Apache Drill through the following interfaces:*
>
> - *Drill shell*
> - *Drill Web UI*
> - *ODBC
> <
> https://drill.apache.org/docs/odbc-jdbc-interfaces#using-odbc-to-access-apache-drill-from-bi-tools
> >**
> - *JDBC <https://drill.apache.org/docs/using-jdbc/>*
> - *C++ API*
>
>
> and in http://drill.apache.org/faq/ -
> *What clients are supported?*
>
> - *BI tools via the ODBC and JDBC drivers (eg, Tableau, Excel,
> MicroStrategy, Spotfire, QlikView, Business Objects)*
> - *Custom applications via the REST API*
> - *Java and C applications via the dedicated Java and C libraries*
>
>
> It would be great if you/somebody can point me to the C++ api or the
> dedicated JAVA library or API as mentioned in the documentation.
>
> Thanks and regards,
> Nishith Maheshwari
>
>
>
> On Wed, May 27, 2015 at 12:44 PM, Rajkumar Singh <rs...@maprtech.com>
> wrote:
>
> > Do you try drill-jdbc driver? I will suggest you to use java jdbc
> > connectivity to query drill using the drill-jdbc driver.I have not
> > tried this to query HBASE using drill but it should work if you have
> > correctly configured the HBase Storage plugin with the DRILL.
> >
> > Thanks
> >
> > Rajkumar Singh
> >
> >
> >
> > > On May 27, 2015, at 12:09 PM, Nishith Maheshwari <ns...@gmail.com>
> > wrote:
> > >
> > > Hi,
> > > I wanted to create a java application to connect and query over a
> > > HBase database using Drill, but was unable to find any documentation
> > > regarding this.
> > > Is there a JAVA api through which Drill can be accessed? I did see a
> > small
> > > mention of C++ and JAVA api in the documentation but there was no
> > > other link or information regarding the same.
> > >
> > > Regards,
> > > Nishith Maheshwari
> >
> >
>
RE: JAVA API for Drill
Posted by Norris Lee <no...@simba.com>.
Hi Nishith,
Take a look at the DrillClient.java and .cpp/.hpp classes of the project for the Java and C++ libraries respectively.
Norris
-----Original Message-----
From: Nishith Maheshwari [mailto:nshthm@gmail.com]
Sent: Wednesday, May 27, 2015 1:45 AM
To: user@drill.apache.org
Subject: Re: JAVA API for Drill
Thank you Martin and Rajkumar for your prompt responses.
I am actually looking if some API is available which provides this functionality. In the documentation it is mentioned in :
https://drill.apache.org/docs/architecture-introduction -
*You can connect to Apache Drill through the following interfaces:*
- *Drill shell*
- *Drill Web UI*
- *ODBC
<https://drill.apache.org/docs/odbc-jdbc-interfaces#using-odbc-to-access-apache-drill-from-bi-tools>**
- *JDBC <https://drill.apache.org/docs/using-jdbc/>*
- *C++ API*
and in http://drill.apache.org/faq/ -
*What clients are supported?*
- *BI tools via the ODBC and JDBC drivers (eg, Tableau, Excel,
MicroStrategy, Spotfire, QlikView, Business Objects)*
- *Custom applications via the REST API*
- *Java and C applications via the dedicated Java and C libraries*
It would be great if you/somebody can point me to the C++ api or the dedicated JAVA library or API as mentioned in the documentation.
Thanks and regards,
Nishith Maheshwari
On Wed, May 27, 2015 at 12:44 PM, Rajkumar Singh <rs...@maprtech.com>
wrote:
> Do you try drill-jdbc driver? I will suggest you to use java jdbc
> connectivity to query drill using the drill-jdbc driver.I have not
> tried this to query HBASE using drill but it should work if you have
> correctly configured the HBase Storage plugin with the DRILL.
>
> Thanks
>
> Rajkumar Singh
>
>
>
> > On May 27, 2015, at 12:09 PM, Nishith Maheshwari <ns...@gmail.com>
> wrote:
> >
> > Hi,
> > I wanted to create a java application to connect and query over a
> > HBase database using Drill, but was unable to find any documentation
> > regarding this.
> > Is there a JAVA api through which Drill can be accessed? I did see a
> small
> > mention of C++ and JAVA api in the documentation but there was no
> > other link or information regarding the same.
> >
> > Regards,
> > Nishith Maheshwari
>
>
Re: JAVA API for Drill
Posted by Nishith Maheshwari <ns...@gmail.com>.
Thank you Martin and Rajkumar for your prompt responses.
I am actually looking if some API is available which provides this
functionality. In the documentation it is mentioned in :
https://drill.apache.org/docs/architecture-introduction -
*You can connect to Apache Drill through the following interfaces:*
- *Drill shell*
- *Drill Web UI*
- *ODBC
<https://drill.apache.org/docs/odbc-jdbc-interfaces#using-odbc-to-access-apache-drill-from-bi-tools>**
- *JDBC <https://drill.apache.org/docs/using-jdbc/>*
- *C++ API*
and in http://drill.apache.org/faq/ -
*What clients are supported?*
- *BI tools via the ODBC and JDBC drivers (eg, Tableau, Excel,
MicroStrategy, Spotfire, QlikView, Business Objects)*
- *Custom applications via the REST API*
- *Java and C applications via the dedicated Java and C libraries*
It would be great if you/somebody can point me to the C++ api or the
dedicated JAVA library or API as mentioned in the documentation.
Thanks and regards,
Nishith Maheshwari
On Wed, May 27, 2015 at 12:44 PM, Rajkumar Singh <rs...@maprtech.com>
wrote:
> Do you try drill-jdbc driver? I will suggest you to use java jdbc
> connectivity to query drill using the drill-jdbc driver.I have not tried
> this to query HBASE using drill but it should work if you have correctly
> configured the HBase Storage plugin with the DRILL.
>
> Thanks
>
> Rajkumar Singh
>
>
>
> > On May 27, 2015, at 12:09 PM, Nishith Maheshwari <ns...@gmail.com>
> wrote:
> >
> > Hi,
> > I wanted to create a java application to connect and query over a HBase
> > database using Drill, but was unable to find any documentation regarding
> > this.
> > Is there a JAVA api through which Drill can be accessed? I did see a
> small
> > mention of C++ and JAVA api in the documentation but there was no other
> > link or information regarding the same.
> >
> > Regards,
> > Nishith Maheshwari
>
>
Re: JAVA API for Drill
Posted by Rajkumar Singh <rs...@maprtech.com>.
Do you try drill-jdbc driver? I will suggest you to use java jdbc connectivity to query drill using the drill-jdbc driver.I have not tried this to query HBASE using drill but it should work if you have correctly
configured the HBase Storage plugin with the DRILL.
Thanks
Rajkumar Singh
> On May 27, 2015, at 12:09 PM, Nishith Maheshwari <ns...@gmail.com> wrote:
>
> Hi,
> I wanted to create a java application to connect and query over a HBase
> database using Drill, but was unable to find any documentation regarding
> this.
> Is there a JAVA api through which Drill can be accessed? I did see a small
> mention of C++ and JAVA api in the documentation but there was no other
> link or information regarding the same.
>
> Regards,
> Nishith Maheshwari