Drill & PHP

[Sharhabeel Hamdan <sh...@gmail.com>]

Hello Great Team :)

I would like to know if there is any way that I can connect PHP to Drill
and execute SQL queries from there ?

Thanks,
Sharhabeel

Re: Drill & PHP

[Jason Altekruse <al...@gmail.com>]

While it is not part of the open source Drill project, Mapr Technologies
provides an ODBC driver for Drill. A quick search on the PHP docs seems to
indicate that PHP can connect to an ODBC provider. The rest interface is
also available, and would be bundled with the default open source build,
although you will have to send requests and read them in JSON format as Ted
mentioned.

http://doc.mapr.com/display/MapR/Using+ODBC+to+Access+Apache+Drill+from+BI+Tools

http://php.net/manual/en/function.odbc-connect.php

-Jason Alterkuse

On Thu, Jan 1, 2015 at 6:11 PM, Ted Dunning <te...@gmail.com> wrote:

> Yes.  You can use the REST interface which only requires that you be able
> to formulate your query in a JSON object and send it to a Drill process
> from the PHP server.
>
>
>
> On Thu, Jan 1, 2015 at 3:38 PM, Sharhabeel Hamdan <
> sharhabeel.hamdan@gmail.com> wrote:
>
> > Hello Great Team :)
> >
> > I would like to know if there is any way that I can connect PHP to Drill
> > and execute SQL queries from there ?
> >
> > Thanks,
> > Sharhabeel
> >
>

Re: Drill & PHP

[Ted Dunning <te...@gmail.com>]

Yes.  You can use the REST interface which only requires that you be able
to formulate your query in a JSON object and send it to a Drill process
from the PHP server.



On Thu, Jan 1, 2015 at 3:38 PM, Sharhabeel Hamdan <
sharhabeel.hamdan@gmail.com> wrote:

> Hello Great Team :)
>
> I would like to know if there is any way that I can connect PHP to Drill
> and execute SQL queries from there ?
>
> Thanks,
> Sharhabeel
>