You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Naveen Madhire <vm...@umail.iu.edu> on 2015/08/17 21:34:45 UTC
Drill Installation Question
Hi,
I am trying to install Drill on a Cloudera cluster by following the steps
described on the website.
https://drill.apache.org/docs/starting-drill-in-distributed-mode/
I have few questions before I start installing Drill,
1. How can I start a Drill shell on a node not in the cluster, probably the
edge node which interacts with the cluster. Is it like just download the
drill tarball and start the shell?
2. Is there a UI which I can use to write queries and verify the data,
instead of using drill shell command line access.
Please let me know, any info on the above points would be helpful.
Thanks,
Naveen
Re: Drill Installation Question
Posted by Naveen Madhire <vm...@umail.iu.edu>.
Well, the requirement is the users will access Drill using a webui from
their desktops and only few ports on edge node is open to the outside
world. So, I need something running on the edge node to run drill queries.
I am not a network expert but let me figure out about NAT, tunnel etc which
you mentioned from others.
Thanks for your help.
On Tue, Aug 18, 2015 at 4:36 PM, Andries Engelbrecht <
aengelbrecht@maprtech.com> wrote:
> Can’t you use a network service like NAT, tunnel, etc to provide access?
>
> —Andries
>
> > On Aug 18, 2015, at 2:33 PM, Abhishek Girish <ab...@gmail.com>
> wrote:
> >
> > I don't think that is currently possible. AFAIK, the web-UI is tied to
> the
> > drillbit service and cannot be brought up stand-alone.
> >
> > On Tue, Aug 18, 2015 at 2:22 PM, Naveen Madhire <vm...@umail.iu.edu>
> > wrote:
> >
> >> Thanks for all your help. One last question guys :)
> >>
> >> Currently, I have started drillbits on all the datanodes and accessing
> the
> >> drill command line from an edge node outside of the cloudera cluster.
> >>
> >> I can see that, I can only access the webui on 8047 port from the
> >> datanodes.
> >>
> >> I need to access the webui for running queries from the edge node. We
> have
> >> few firewall rules such that the datanode ports are not opened.
> >>
> >> How can I use webui running on a node outside of the cluster without
> >> starting the drillbit service?
> >>
> >> Thanks
> >>
> >> On Tue, Aug 18, 2015 at 3:44 PM, Abhishek Girish <
> >> abhishek.girish@gmail.com>
> >> wrote:
> >>
> >>> You could override defaults in drill-override.conf. Example:
> >>>
> >>> http: {
> >>> enabled: true,
> >>> port: 8047
> >>> }
> >>>
> >>> Refer to drill-override-example.conf for details.
> >>>
> >>> On Tue, Aug 18, 2015 at 1:38 PM, Naveen Madhire <vmadhire@umail.iu.edu
> >
> >>> wrote:
> >>>
> >>>> Thanks for the info.
> >>>>
> >>>> Also, I didn't find any info on changing the default ports 8047, 31010
> >>> etc.
> >>>> I need to be able to configure specific ports to be used for Drill
> >>> service.
> >>>> Please let me know.
> >>>>
> >>>> Thanks.
> >>>>
> >>>> On Tue, Aug 18, 2015 at 3:11 PM, Andries Engelbrecht <
> >>>> aengelbrecht@maprtech.com> wrote:
> >>>>
> >>>>> See
> >>>>> https://drill.apache.org/docs/querying-system-tables/ <
> >>>>> https://drill.apache.org/docs/querying-system-tables/>
> >>>>>
> >>>>>
> >>>>> —Andries
> >>>>>
> >>>>>
> >>>>>> On Aug 18, 2015, at 11:51 AM, Naveen Madhire <
> >> vmadhire@umail.iu.edu>
> >>>>> wrote:
> >>>>>>
> >>>>>> Well, this is working well now. I really like the install process,
> >>> very
> >>>>>> simple and straight forward. :)
> >>>>>>
> >>>>>> One have one question,
> >>>>>>
> >>>>>> I ran the select * from sys.drillbits query,
> >>>>>>
> >>>>>> I see the output gives, user port, control port, data port and
> >>> current?
> >>>>>> What does these each one mean ?
> >>>>>>
> >>>>>>
> >>>>>> Thanks.
> >>>>>>
> >>>>>>
> >>>>>> On Mon, Aug 17, 2015 at 2:47 PM, Andries Engelbrecht <
> >>>>>> aengelbrecht@maprtech.com> wrote:
> >>>>>>
> >>>>>>> SQuirreL is also a popular UI choice, where you use the JDBC
> >> driver
> >>>> and
> >>>>>>> can connect to the cluster. It is a bit more powerful than the
> >>> WebUI,
> >>>>> but
> >>>>>>> does require installation and configuration.
> >>>>>>>
> >>>>>>>
> >> https://drill.apache.org/docs/using-jdbc-with-squirrel-on-windows/
> >>> <
> >>>>>>>
> >> https://drill.apache.org/docs/using-jdbc-with-squirrel-on-windows/>
> >>>>>>>
> >>>>>>> Instructions are very similar for Mac or Linux as well.
> >>>>>>>
> >>>>>>>
> >>>>>>> —Andries
> >>>>>>>
> >>>>>>>> On Aug 17, 2015, at 12:38 PM, Jim Scott <js...@maprtech.com>
> >>> wrote:
> >>>>>>>>
> >>>>>>>> 1. Yes. When you initiate the sqlline from the command line you
> >>>> specify
> >>>>>>> the
> >>>>>>>> zookeeper quorum in which to connect.
> >>>>>>>>
> >>>>>>>> 2. There is a WebUI for Drill. Here is a reference from the
> >>>>>>> documentation:
> >>>>>>>>
> >>>>>>>
> >>>>>
> >>>>
> >>>
> >>
> https://drill.apache.org/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/
> >>>>>>>>
> >>>>>>>> On Mon, Aug 17, 2015 at 2:34 PM, Naveen Madhire <
> >>>> vmadhire@umail.iu.edu
> >>>>>>
> >>>>>>>> wrote:
> >>>>>>>>
> >>>>>>>>> Hi,
> >>>>>>>>>
> >>>>>>>>> I am trying to install Drill on a Cloudera cluster by following
> >>> the
> >>>>>>> steps
> >>>>>>>>> described on the website.
> >>>>>>>>>
> >> https://drill.apache.org/docs/starting-drill-in-distributed-mode/
> >>>>>>>>>
> >>>>>>>>> I have few questions before I start installing Drill,
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>> 1. How can I start a Drill shell on a node not in the cluster,
> >>>>> probably
> >>>>>>> the
> >>>>>>>>> edge node which interacts with the cluster. Is it like just
> >>> download
> >>>>> the
> >>>>>>>>> drill tarball and start the shell?
> >>>>>>>>> 2. Is there a UI which I can use to write queries and verify the
> >>>> data,
> >>>>>>>>> instead of using drill shell command line access.
> >>>>>>>>>
> >>>>>>>>> Please let me know, any info on the above points would be
> >> helpful.
> >>>>>>>>>
> >>>>>>>>> Thanks,
> >>>>>>>>> Naveen
> >>>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>> --
> >>>>>>>> *Jim Scott*
> >>>>>>>> Director, Enterprise Strategy & Architecture
> >>>>>>>> +1 (347) 746-9281
> >>>>>>>> @kingmesal <https://twitter.com/kingmesal>
> >>>>>>>>
> >>>>>>>> <http://www.mapr.com/>
> >>>>>>>> [image: MapR Technologies] <http://www.mapr.com>
> >>>>>>>>
> >>>>>>>> Now Available - Free Hadoop On-Demand Training
> >>>>>>>> <
> >>>>>>>
> >>>>>
> >>>>
> >>>
> >>
> http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available
> >>>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>
> >>>>>
> >>>>
> >>>
> >>
>
>
Re: Drill Installation Question
Posted by Andries Engelbrecht <ae...@maprtech.com>.
Can’t you use a network service like NAT, tunnel, etc to provide access?
—Andries
> On Aug 18, 2015, at 2:33 PM, Abhishek Girish <ab...@gmail.com> wrote:
>
> I don't think that is currently possible. AFAIK, the web-UI is tied to the
> drillbit service and cannot be brought up stand-alone.
>
> On Tue, Aug 18, 2015 at 2:22 PM, Naveen Madhire <vm...@umail.iu.edu>
> wrote:
>
>> Thanks for all your help. One last question guys :)
>>
>> Currently, I have started drillbits on all the datanodes and accessing the
>> drill command line from an edge node outside of the cloudera cluster.
>>
>> I can see that, I can only access the webui on 8047 port from the
>> datanodes.
>>
>> I need to access the webui for running queries from the edge node. We have
>> few firewall rules such that the datanode ports are not opened.
>>
>> How can I use webui running on a node outside of the cluster without
>> starting the drillbit service?
>>
>> Thanks
>>
>> On Tue, Aug 18, 2015 at 3:44 PM, Abhishek Girish <
>> abhishek.girish@gmail.com>
>> wrote:
>>
>>> You could override defaults in drill-override.conf. Example:
>>>
>>> http: {
>>> enabled: true,
>>> port: 8047
>>> }
>>>
>>> Refer to drill-override-example.conf for details.
>>>
>>> On Tue, Aug 18, 2015 at 1:38 PM, Naveen Madhire <vm...@umail.iu.edu>
>>> wrote:
>>>
>>>> Thanks for the info.
>>>>
>>>> Also, I didn't find any info on changing the default ports 8047, 31010
>>> etc.
>>>> I need to be able to configure specific ports to be used for Drill
>>> service.
>>>> Please let me know.
>>>>
>>>> Thanks.
>>>>
>>>> On Tue, Aug 18, 2015 at 3:11 PM, Andries Engelbrecht <
>>>> aengelbrecht@maprtech.com> wrote:
>>>>
>>>>> See
>>>>> https://drill.apache.org/docs/querying-system-tables/ <
>>>>> https://drill.apache.org/docs/querying-system-tables/>
>>>>>
>>>>>
>>>>> —Andries
>>>>>
>>>>>
>>>>>> On Aug 18, 2015, at 11:51 AM, Naveen Madhire <
>> vmadhire@umail.iu.edu>
>>>>> wrote:
>>>>>>
>>>>>> Well, this is working well now. I really like the install process,
>>> very
>>>>>> simple and straight forward. :)
>>>>>>
>>>>>> One have one question,
>>>>>>
>>>>>> I ran the select * from sys.drillbits query,
>>>>>>
>>>>>> I see the output gives, user port, control port, data port and
>>> current?
>>>>>> What does these each one mean ?
>>>>>>
>>>>>>
>>>>>> Thanks.
>>>>>>
>>>>>>
>>>>>> On Mon, Aug 17, 2015 at 2:47 PM, Andries Engelbrecht <
>>>>>> aengelbrecht@maprtech.com> wrote:
>>>>>>
>>>>>>> SQuirreL is also a popular UI choice, where you use the JDBC
>> driver
>>>> and
>>>>>>> can connect to the cluster. It is a bit more powerful than the
>>> WebUI,
>>>>> but
>>>>>>> does require installation and configuration.
>>>>>>>
>>>>>>>
>> https://drill.apache.org/docs/using-jdbc-with-squirrel-on-windows/
>>> <
>>>>>>>
>> https://drill.apache.org/docs/using-jdbc-with-squirrel-on-windows/>
>>>>>>>
>>>>>>> Instructions are very similar for Mac or Linux as well.
>>>>>>>
>>>>>>>
>>>>>>> —Andries
>>>>>>>
>>>>>>>> On Aug 17, 2015, at 12:38 PM, Jim Scott <js...@maprtech.com>
>>> wrote:
>>>>>>>>
>>>>>>>> 1. Yes. When you initiate the sqlline from the command line you
>>>> specify
>>>>>>> the
>>>>>>>> zookeeper quorum in which to connect.
>>>>>>>>
>>>>>>>> 2. There is a WebUI for Drill. Here is a reference from the
>>>>>>> documentation:
>>>>>>>>
>>>>>>>
>>>>>
>>>>
>>>
>> https://drill.apache.org/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/
>>>>>>>>
>>>>>>>> On Mon, Aug 17, 2015 at 2:34 PM, Naveen Madhire <
>>>> vmadhire@umail.iu.edu
>>>>>>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> Hi,
>>>>>>>>>
>>>>>>>>> I am trying to install Drill on a Cloudera cluster by following
>>> the
>>>>>>> steps
>>>>>>>>> described on the website.
>>>>>>>>>
>> https://drill.apache.org/docs/starting-drill-in-distributed-mode/
>>>>>>>>>
>>>>>>>>> I have few questions before I start installing Drill,
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> 1. How can I start a Drill shell on a node not in the cluster,
>>>>> probably
>>>>>>> the
>>>>>>>>> edge node which interacts with the cluster. Is it like just
>>> download
>>>>> the
>>>>>>>>> drill tarball and start the shell?
>>>>>>>>> 2. Is there a UI which I can use to write queries and verify the
>>>> data,
>>>>>>>>> instead of using drill shell command line access.
>>>>>>>>>
>>>>>>>>> Please let me know, any info on the above points would be
>> helpful.
>>>>>>>>>
>>>>>>>>> Thanks,
>>>>>>>>> Naveen
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> *Jim Scott*
>>>>>>>> Director, Enterprise Strategy & Architecture
>>>>>>>> +1 (347) 746-9281
>>>>>>>> @kingmesal <https://twitter.com/kingmesal>
>>>>>>>>
>>>>>>>> <http://www.mapr.com/>
>>>>>>>> [image: MapR Technologies] <http://www.mapr.com>
>>>>>>>>
>>>>>>>> Now Available - Free Hadoop On-Demand Training
>>>>>>>> <
>>>>>>>
>>>>>
>>>>
>>>
>> http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>
>>>>>
>>>>
>>>
>>
Re: Drill Installation Question
Posted by Abhishek Girish <ab...@gmail.com>.
I don't think that is currently possible. AFAIK, the web-UI is tied to the
drillbit service and cannot be brought up stand-alone.
On Tue, Aug 18, 2015 at 2:22 PM, Naveen Madhire <vm...@umail.iu.edu>
wrote:
> Thanks for all your help. One last question guys :)
>
> Currently, I have started drillbits on all the datanodes and accessing the
> drill command line from an edge node outside of the cloudera cluster.
>
> I can see that, I can only access the webui on 8047 port from the
> datanodes.
>
> I need to access the webui for running queries from the edge node. We have
> few firewall rules such that the datanode ports are not opened.
>
> How can I use webui running on a node outside of the cluster without
> starting the drillbit service?
>
> Thanks
>
> On Tue, Aug 18, 2015 at 3:44 PM, Abhishek Girish <
> abhishek.girish@gmail.com>
> wrote:
>
> > You could override defaults in drill-override.conf. Example:
> >
> > http: {
> > enabled: true,
> > port: 8047
> > }
> >
> > Refer to drill-override-example.conf for details.
> >
> > On Tue, Aug 18, 2015 at 1:38 PM, Naveen Madhire <vm...@umail.iu.edu>
> > wrote:
> >
> > > Thanks for the info.
> > >
> > > Also, I didn't find any info on changing the default ports 8047, 31010
> > etc.
> > > I need to be able to configure specific ports to be used for Drill
> > service.
> > > Please let me know.
> > >
> > > Thanks.
> > >
> > > On Tue, Aug 18, 2015 at 3:11 PM, Andries Engelbrecht <
> > > aengelbrecht@maprtech.com> wrote:
> > >
> > > > See
> > > > https://drill.apache.org/docs/querying-system-tables/ <
> > > > https://drill.apache.org/docs/querying-system-tables/>
> > > >
> > > >
> > > > —Andries
> > > >
> > > >
> > > > > On Aug 18, 2015, at 11:51 AM, Naveen Madhire <
> vmadhire@umail.iu.edu>
> > > > wrote:
> > > > >
> > > > > Well, this is working well now. I really like the install process,
> > very
> > > > > simple and straight forward. :)
> > > > >
> > > > > One have one question,
> > > > >
> > > > > I ran the select * from sys.drillbits query,
> > > > >
> > > > > I see the output gives, user port, control port, data port and
> > current?
> > > > > What does these each one mean ?
> > > > >
> > > > >
> > > > > Thanks.
> > > > >
> > > > >
> > > > > On Mon, Aug 17, 2015 at 2:47 PM, Andries Engelbrecht <
> > > > > aengelbrecht@maprtech.com> wrote:
> > > > >
> > > > >> SQuirreL is also a popular UI choice, where you use the JDBC
> driver
> > > and
> > > > >> can connect to the cluster. It is a bit more powerful than the
> > WebUI,
> > > > but
> > > > >> does require installation and configuration.
> > > > >>
> > > > >>
> https://drill.apache.org/docs/using-jdbc-with-squirrel-on-windows/
> > <
> > > > >>
> https://drill.apache.org/docs/using-jdbc-with-squirrel-on-windows/>
> > > > >>
> > > > >> Instructions are very similar for Mac or Linux as well.
> > > > >>
> > > > >>
> > > > >> —Andries
> > > > >>
> > > > >>> On Aug 17, 2015, at 12:38 PM, Jim Scott <js...@maprtech.com>
> > wrote:
> > > > >>>
> > > > >>> 1. Yes. When you initiate the sqlline from the command line you
> > > specify
> > > > >> the
> > > > >>> zookeeper quorum in which to connect.
> > > > >>>
> > > > >>> 2. There is a WebUI for Drill. Here is a reference from the
> > > > >> documentation:
> > > > >>>
> > > > >>
> > > >
> > >
> >
> https://drill.apache.org/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/
> > > > >>>
> > > > >>> On Mon, Aug 17, 2015 at 2:34 PM, Naveen Madhire <
> > > vmadhire@umail.iu.edu
> > > > >
> > > > >>> wrote:
> > > > >>>
> > > > >>>> Hi,
> > > > >>>>
> > > > >>>> I am trying to install Drill on a Cloudera cluster by following
> > the
> > > > >> steps
> > > > >>>> described on the website.
> > > > >>>>
> https://drill.apache.org/docs/starting-drill-in-distributed-mode/
> > > > >>>>
> > > > >>>> I have few questions before I start installing Drill,
> > > > >>>>
> > > > >>>>
> > > > >>>> 1. How can I start a Drill shell on a node not in the cluster,
> > > > probably
> > > > >> the
> > > > >>>> edge node which interacts with the cluster. Is it like just
> > download
> > > > the
> > > > >>>> drill tarball and start the shell?
> > > > >>>> 2. Is there a UI which I can use to write queries and verify the
> > > data,
> > > > >>>> instead of using drill shell command line access.
> > > > >>>>
> > > > >>>> Please let me know, any info on the above points would be
> helpful.
> > > > >>>>
> > > > >>>> Thanks,
> > > > >>>> Naveen
> > > > >>>>
> > > > >>>
> > > > >>>
> > > > >>>
> > > > >>> --
> > > > >>> *Jim Scott*
> > > > >>> Director, Enterprise Strategy & Architecture
> > > > >>> +1 (347) 746-9281
> > > > >>> @kingmesal <https://twitter.com/kingmesal>
> > > > >>>
> > > > >>> <http://www.mapr.com/>
> > > > >>> [image: MapR Technologies] <http://www.mapr.com>
> > > > >>>
> > > > >>> Now Available - Free Hadoop On-Demand Training
> > > > >>> <
> > > > >>
> > > >
> > >
> >
> http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available
> > > > >>>
> > > > >>
> > > > >>
> > > >
> > > >
> > >
> >
>
Re: Drill Installation Question
Posted by Naveen Madhire <vm...@umail.iu.edu>.
Thanks for all your help. One last question guys :)
Currently, I have started drillbits on all the datanodes and accessing the
drill command line from an edge node outside of the cloudera cluster.
I can see that, I can only access the webui on 8047 port from the
datanodes.
I need to access the webui for running queries from the edge node. We have
few firewall rules such that the datanode ports are not opened.
How can I use webui running on a node outside of the cluster without
starting the drillbit service?
Thanks
On Tue, Aug 18, 2015 at 3:44 PM, Abhishek Girish <ab...@gmail.com>
wrote:
> You could override defaults in drill-override.conf. Example:
>
> http: {
> enabled: true,
> port: 8047
> }
>
> Refer to drill-override-example.conf for details.
>
> On Tue, Aug 18, 2015 at 1:38 PM, Naveen Madhire <vm...@umail.iu.edu>
> wrote:
>
> > Thanks for the info.
> >
> > Also, I didn't find any info on changing the default ports 8047, 31010
> etc.
> > I need to be able to configure specific ports to be used for Drill
> service.
> > Please let me know.
> >
> > Thanks.
> >
> > On Tue, Aug 18, 2015 at 3:11 PM, Andries Engelbrecht <
> > aengelbrecht@maprtech.com> wrote:
> >
> > > See
> > > https://drill.apache.org/docs/querying-system-tables/ <
> > > https://drill.apache.org/docs/querying-system-tables/>
> > >
> > >
> > > —Andries
> > >
> > >
> > > > On Aug 18, 2015, at 11:51 AM, Naveen Madhire <vm...@umail.iu.edu>
> > > wrote:
> > > >
> > > > Well, this is working well now. I really like the install process,
> very
> > > > simple and straight forward. :)
> > > >
> > > > One have one question,
> > > >
> > > > I ran the select * from sys.drillbits query,
> > > >
> > > > I see the output gives, user port, control port, data port and
> current?
> > > > What does these each one mean ?
> > > >
> > > >
> > > > Thanks.
> > > >
> > > >
> > > > On Mon, Aug 17, 2015 at 2:47 PM, Andries Engelbrecht <
> > > > aengelbrecht@maprtech.com> wrote:
> > > >
> > > >> SQuirreL is also a popular UI choice, where you use the JDBC driver
> > and
> > > >> can connect to the cluster. It is a bit more powerful than the
> WebUI,
> > > but
> > > >> does require installation and configuration.
> > > >>
> > > >> https://drill.apache.org/docs/using-jdbc-with-squirrel-on-windows/
> <
> > > >> https://drill.apache.org/docs/using-jdbc-with-squirrel-on-windows/>
> > > >>
> > > >> Instructions are very similar for Mac or Linux as well.
> > > >>
> > > >>
> > > >> —Andries
> > > >>
> > > >>> On Aug 17, 2015, at 12:38 PM, Jim Scott <js...@maprtech.com>
> wrote:
> > > >>>
> > > >>> 1. Yes. When you initiate the sqlline from the command line you
> > specify
> > > >> the
> > > >>> zookeeper quorum in which to connect.
> > > >>>
> > > >>> 2. There is a WebUI for Drill. Here is a reference from the
> > > >> documentation:
> > > >>>
> > > >>
> > >
> >
> https://drill.apache.org/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/
> > > >>>
> > > >>> On Mon, Aug 17, 2015 at 2:34 PM, Naveen Madhire <
> > vmadhire@umail.iu.edu
> > > >
> > > >>> wrote:
> > > >>>
> > > >>>> Hi,
> > > >>>>
> > > >>>> I am trying to install Drill on a Cloudera cluster by following
> the
> > > >> steps
> > > >>>> described on the website.
> > > >>>> https://drill.apache.org/docs/starting-drill-in-distributed-mode/
> > > >>>>
> > > >>>> I have few questions before I start installing Drill,
> > > >>>>
> > > >>>>
> > > >>>> 1. How can I start a Drill shell on a node not in the cluster,
> > > probably
> > > >> the
> > > >>>> edge node which interacts with the cluster. Is it like just
> download
> > > the
> > > >>>> drill tarball and start the shell?
> > > >>>> 2. Is there a UI which I can use to write queries and verify the
> > data,
> > > >>>> instead of using drill shell command line access.
> > > >>>>
> > > >>>> Please let me know, any info on the above points would be helpful.
> > > >>>>
> > > >>>> Thanks,
> > > >>>> Naveen
> > > >>>>
> > > >>>
> > > >>>
> > > >>>
> > > >>> --
> > > >>> *Jim Scott*
> > > >>> Director, Enterprise Strategy & Architecture
> > > >>> +1 (347) 746-9281
> > > >>> @kingmesal <https://twitter.com/kingmesal>
> > > >>>
> > > >>> <http://www.mapr.com/>
> > > >>> [image: MapR Technologies] <http://www.mapr.com>
> > > >>>
> > > >>> Now Available - Free Hadoop On-Demand Training
> > > >>> <
> > > >>
> > >
> >
> http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available
> > > >>>
> > > >>
> > > >>
> > >
> > >
> >
>
Re: Drill Installation Question
Posted by Abhishek Girish <ab...@gmail.com>.
You could override defaults in drill-override.conf. Example:
http: {
enabled: true,
port: 8047
}
Refer to drill-override-example.conf for details.
On Tue, Aug 18, 2015 at 1:38 PM, Naveen Madhire <vm...@umail.iu.edu>
wrote:
> Thanks for the info.
>
> Also, I didn't find any info on changing the default ports 8047, 31010 etc.
> I need to be able to configure specific ports to be used for Drill service.
> Please let me know.
>
> Thanks.
>
> On Tue, Aug 18, 2015 at 3:11 PM, Andries Engelbrecht <
> aengelbrecht@maprtech.com> wrote:
>
> > See
> > https://drill.apache.org/docs/querying-system-tables/ <
> > https://drill.apache.org/docs/querying-system-tables/>
> >
> >
> > —Andries
> >
> >
> > > On Aug 18, 2015, at 11:51 AM, Naveen Madhire <vm...@umail.iu.edu>
> > wrote:
> > >
> > > Well, this is working well now. I really like the install process, very
> > > simple and straight forward. :)
> > >
> > > One have one question,
> > >
> > > I ran the select * from sys.drillbits query,
> > >
> > > I see the output gives, user port, control port, data port and current?
> > > What does these each one mean ?
> > >
> > >
> > > Thanks.
> > >
> > >
> > > On Mon, Aug 17, 2015 at 2:47 PM, Andries Engelbrecht <
> > > aengelbrecht@maprtech.com> wrote:
> > >
> > >> SQuirreL is also a popular UI choice, where you use the JDBC driver
> and
> > >> can connect to the cluster. It is a bit more powerful than the WebUI,
> > but
> > >> does require installation and configuration.
> > >>
> > >> https://drill.apache.org/docs/using-jdbc-with-squirrel-on-windows/ <
> > >> https://drill.apache.org/docs/using-jdbc-with-squirrel-on-windows/>
> > >>
> > >> Instructions are very similar for Mac or Linux as well.
> > >>
> > >>
> > >> —Andries
> > >>
> > >>> On Aug 17, 2015, at 12:38 PM, Jim Scott <js...@maprtech.com> wrote:
> > >>>
> > >>> 1. Yes. When you initiate the sqlline from the command line you
> specify
> > >> the
> > >>> zookeeper quorum in which to connect.
> > >>>
> > >>> 2. There is a WebUI for Drill. Here is a reference from the
> > >> documentation:
> > >>>
> > >>
> >
> https://drill.apache.org/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/
> > >>>
> > >>> On Mon, Aug 17, 2015 at 2:34 PM, Naveen Madhire <
> vmadhire@umail.iu.edu
> > >
> > >>> wrote:
> > >>>
> > >>>> Hi,
> > >>>>
> > >>>> I am trying to install Drill on a Cloudera cluster by following the
> > >> steps
> > >>>> described on the website.
> > >>>> https://drill.apache.org/docs/starting-drill-in-distributed-mode/
> > >>>>
> > >>>> I have few questions before I start installing Drill,
> > >>>>
> > >>>>
> > >>>> 1. How can I start a Drill shell on a node not in the cluster,
> > probably
> > >> the
> > >>>> edge node which interacts with the cluster. Is it like just download
> > the
> > >>>> drill tarball and start the shell?
> > >>>> 2. Is there a UI which I can use to write queries and verify the
> data,
> > >>>> instead of using drill shell command line access.
> > >>>>
> > >>>> Please let me know, any info on the above points would be helpful.
> > >>>>
> > >>>> Thanks,
> > >>>> Naveen
> > >>>>
> > >>>
> > >>>
> > >>>
> > >>> --
> > >>> *Jim Scott*
> > >>> Director, Enterprise Strategy & Architecture
> > >>> +1 (347) 746-9281
> > >>> @kingmesal <https://twitter.com/kingmesal>
> > >>>
> > >>> <http://www.mapr.com/>
> > >>> [image: MapR Technologies] <http://www.mapr.com>
> > >>>
> > >>> Now Available - Free Hadoop On-Demand Training
> > >>> <
> > >>
> >
> http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available
> > >>>
> > >>
> > >>
> >
> >
>
Re: Drill Installation Question
Posted by Naveen Madhire <vm...@umail.iu.edu>.
Thanks for the info.
Also, I didn't find any info on changing the default ports 8047, 31010 etc.
I need to be able to configure specific ports to be used for Drill service.
Please let me know.
Thanks.
On Tue, Aug 18, 2015 at 3:11 PM, Andries Engelbrecht <
aengelbrecht@maprtech.com> wrote:
> See
> https://drill.apache.org/docs/querying-system-tables/ <
> https://drill.apache.org/docs/querying-system-tables/>
>
>
> —Andries
>
>
> > On Aug 18, 2015, at 11:51 AM, Naveen Madhire <vm...@umail.iu.edu>
> wrote:
> >
> > Well, this is working well now. I really like the install process, very
> > simple and straight forward. :)
> >
> > One have one question,
> >
> > I ran the select * from sys.drillbits query,
> >
> > I see the output gives, user port, control port, data port and current?
> > What does these each one mean ?
> >
> >
> > Thanks.
> >
> >
> > On Mon, Aug 17, 2015 at 2:47 PM, Andries Engelbrecht <
> > aengelbrecht@maprtech.com> wrote:
> >
> >> SQuirreL is also a popular UI choice, where you use the JDBC driver and
> >> can connect to the cluster. It is a bit more powerful than the WebUI,
> but
> >> does require installation and configuration.
> >>
> >> https://drill.apache.org/docs/using-jdbc-with-squirrel-on-windows/ <
> >> https://drill.apache.org/docs/using-jdbc-with-squirrel-on-windows/>
> >>
> >> Instructions are very similar for Mac or Linux as well.
> >>
> >>
> >> —Andries
> >>
> >>> On Aug 17, 2015, at 12:38 PM, Jim Scott <js...@maprtech.com> wrote:
> >>>
> >>> 1. Yes. When you initiate the sqlline from the command line you specify
> >> the
> >>> zookeeper quorum in which to connect.
> >>>
> >>> 2. There is a WebUI for Drill. Here is a reference from the
> >> documentation:
> >>>
> >>
> https://drill.apache.org/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/
> >>>
> >>> On Mon, Aug 17, 2015 at 2:34 PM, Naveen Madhire <vmadhire@umail.iu.edu
> >
> >>> wrote:
> >>>
> >>>> Hi,
> >>>>
> >>>> I am trying to install Drill on a Cloudera cluster by following the
> >> steps
> >>>> described on the website.
> >>>> https://drill.apache.org/docs/starting-drill-in-distributed-mode/
> >>>>
> >>>> I have few questions before I start installing Drill,
> >>>>
> >>>>
> >>>> 1. How can I start a Drill shell on a node not in the cluster,
> probably
> >> the
> >>>> edge node which interacts with the cluster. Is it like just download
> the
> >>>> drill tarball and start the shell?
> >>>> 2. Is there a UI which I can use to write queries and verify the data,
> >>>> instead of using drill shell command line access.
> >>>>
> >>>> Please let me know, any info on the above points would be helpful.
> >>>>
> >>>> Thanks,
> >>>> Naveen
> >>>>
> >>>
> >>>
> >>>
> >>> --
> >>> *Jim Scott*
> >>> Director, Enterprise Strategy & Architecture
> >>> +1 (347) 746-9281
> >>> @kingmesal <https://twitter.com/kingmesal>
> >>>
> >>> <http://www.mapr.com/>
> >>> [image: MapR Technologies] <http://www.mapr.com>
> >>>
> >>> Now Available - Free Hadoop On-Demand Training
> >>> <
> >>
> http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available
> >>>
> >>
> >>
>
>
Re: Drill Installation Question
Posted by Andries Engelbrecht <ae...@maprtech.com>.
See
https://drill.apache.org/docs/querying-system-tables/ <https://drill.apache.org/docs/querying-system-tables/>
—Andries
> On Aug 18, 2015, at 11:51 AM, Naveen Madhire <vm...@umail.iu.edu> wrote:
>
> Well, this is working well now. I really like the install process, very
> simple and straight forward. :)
>
> One have one question,
>
> I ran the select * from sys.drillbits query,
>
> I see the output gives, user port, control port, data port and current?
> What does these each one mean ?
>
>
> Thanks.
>
>
> On Mon, Aug 17, 2015 at 2:47 PM, Andries Engelbrecht <
> aengelbrecht@maprtech.com> wrote:
>
>> SQuirreL is also a popular UI choice, where you use the JDBC driver and
>> can connect to the cluster. It is a bit more powerful than the WebUI, but
>> does require installation and configuration.
>>
>> https://drill.apache.org/docs/using-jdbc-with-squirrel-on-windows/ <
>> https://drill.apache.org/docs/using-jdbc-with-squirrel-on-windows/>
>>
>> Instructions are very similar for Mac or Linux as well.
>>
>>
>> —Andries
>>
>>> On Aug 17, 2015, at 12:38 PM, Jim Scott <js...@maprtech.com> wrote:
>>>
>>> 1. Yes. When you initiate the sqlline from the command line you specify
>> the
>>> zookeeper quorum in which to connect.
>>>
>>> 2. There is a WebUI for Drill. Here is a reference from the
>> documentation:
>>>
>> https://drill.apache.org/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/
>>>
>>> On Mon, Aug 17, 2015 at 2:34 PM, Naveen Madhire <vm...@umail.iu.edu>
>>> wrote:
>>>
>>>> Hi,
>>>>
>>>> I am trying to install Drill on a Cloudera cluster by following the
>> steps
>>>> described on the website.
>>>> https://drill.apache.org/docs/starting-drill-in-distributed-mode/
>>>>
>>>> I have few questions before I start installing Drill,
>>>>
>>>>
>>>> 1. How can I start a Drill shell on a node not in the cluster, probably
>> the
>>>> edge node which interacts with the cluster. Is it like just download the
>>>> drill tarball and start the shell?
>>>> 2. Is there a UI which I can use to write queries and verify the data,
>>>> instead of using drill shell command line access.
>>>>
>>>> Please let me know, any info on the above points would be helpful.
>>>>
>>>> Thanks,
>>>> Naveen
>>>>
>>>
>>>
>>>
>>> --
>>> *Jim Scott*
>>> Director, Enterprise Strategy & Architecture
>>> +1 (347) 746-9281
>>> @kingmesal <https://twitter.com/kingmesal>
>>>
>>> <http://www.mapr.com/>
>>> [image: MapR Technologies] <http://www.mapr.com>
>>>
>>> Now Available - Free Hadoop On-Demand Training
>>> <
>> http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available
>>>
>>
>>
Re: Drill Installation Question
Posted by Naveen Madhire <vm...@umail.iu.edu>.
Well, this is working well now. I really like the install process, very
simple and straight forward. :)
One have one question,
I ran the select * from sys.drillbits query,
I see the output gives, user port, control port, data port and current?
What does these each one mean ?
Thanks.
On Mon, Aug 17, 2015 at 2:47 PM, Andries Engelbrecht <
aengelbrecht@maprtech.com> wrote:
> SQuirreL is also a popular UI choice, where you use the JDBC driver and
> can connect to the cluster. It is a bit more powerful than the WebUI, but
> does require installation and configuration.
>
> https://drill.apache.org/docs/using-jdbc-with-squirrel-on-windows/ <
> https://drill.apache.org/docs/using-jdbc-with-squirrel-on-windows/>
>
> Instructions are very similar for Mac or Linux as well.
>
>
> —Andries
>
> > On Aug 17, 2015, at 12:38 PM, Jim Scott <js...@maprtech.com> wrote:
> >
> > 1. Yes. When you initiate the sqlline from the command line you specify
> the
> > zookeeper quorum in which to connect.
> >
> > 2. There is a WebUI for Drill. Here is a reference from the
> documentation:
> >
> https://drill.apache.org/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/
> >
> > On Mon, Aug 17, 2015 at 2:34 PM, Naveen Madhire <vm...@umail.iu.edu>
> > wrote:
> >
> >> Hi,
> >>
> >> I am trying to install Drill on a Cloudera cluster by following the
> steps
> >> described on the website.
> >> https://drill.apache.org/docs/starting-drill-in-distributed-mode/
> >>
> >> I have few questions before I start installing Drill,
> >>
> >>
> >> 1. How can I start a Drill shell on a node not in the cluster, probably
> the
> >> edge node which interacts with the cluster. Is it like just download the
> >> drill tarball and start the shell?
> >> 2. Is there a UI which I can use to write queries and verify the data,
> >> instead of using drill shell command line access.
> >>
> >> Please let me know, any info on the above points would be helpful.
> >>
> >> Thanks,
> >> Naveen
> >>
> >
> >
> >
> > --
> > *Jim Scott*
> > Director, Enterprise Strategy & Architecture
> > +1 (347) 746-9281
> > @kingmesal <https://twitter.com/kingmesal>
> >
> > <http://www.mapr.com/>
> > [image: MapR Technologies] <http://www.mapr.com>
> >
> > Now Available - Free Hadoop On-Demand Training
> > <
> http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available
> >
>
>
Re: Drill Installation Question
Posted by Andries Engelbrecht <ae...@maprtech.com>.
SQuirreL is also a popular UI choice, where you use the JDBC driver and can connect to the cluster. It is a bit more powerful than the WebUI, but does require installation and configuration.
https://drill.apache.org/docs/using-jdbc-with-squirrel-on-windows/ <https://drill.apache.org/docs/using-jdbc-with-squirrel-on-windows/>
Instructions are very similar for Mac or Linux as well.
—Andries
> On Aug 17, 2015, at 12:38 PM, Jim Scott <js...@maprtech.com> wrote:
>
> 1. Yes. When you initiate the sqlline from the command line you specify the
> zookeeper quorum in which to connect.
>
> 2. There is a WebUI for Drill. Here is a reference from the documentation:
> https://drill.apache.org/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/
>
> On Mon, Aug 17, 2015 at 2:34 PM, Naveen Madhire <vm...@umail.iu.edu>
> wrote:
>
>> Hi,
>>
>> I am trying to install Drill on a Cloudera cluster by following the steps
>> described on the website.
>> https://drill.apache.org/docs/starting-drill-in-distributed-mode/
>>
>> I have few questions before I start installing Drill,
>>
>>
>> 1. How can I start a Drill shell on a node not in the cluster, probably the
>> edge node which interacts with the cluster. Is it like just download the
>> drill tarball and start the shell?
>> 2. Is there a UI which I can use to write queries and verify the data,
>> instead of using drill shell command line access.
>>
>> Please let me know, any info on the above points would be helpful.
>>
>> Thanks,
>> Naveen
>>
>
>
>
> --
> *Jim Scott*
> Director, Enterprise Strategy & Architecture
> +1 (347) 746-9281
> @kingmesal <https://twitter.com/kingmesal>
>
> <http://www.mapr.com/>
> [image: MapR Technologies] <http://www.mapr.com>
>
> Now Available - Free Hadoop On-Demand Training
> <http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available>
Re: Drill Installation Question
Posted by Jim Scott <js...@maprtech.com>.
1. Yes. When you initiate the sqlline from the command line you specify the
zookeeper quorum in which to connect.
2. There is a WebUI for Drill. Here is a reference from the documentation:
https://drill.apache.org/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/
On Mon, Aug 17, 2015 at 2:34 PM, Naveen Madhire <vm...@umail.iu.edu>
wrote:
> Hi,
>
> I am trying to install Drill on a Cloudera cluster by following the steps
> described on the website.
> https://drill.apache.org/docs/starting-drill-in-distributed-mode/
>
> I have few questions before I start installing Drill,
>
>
> 1. How can I start a Drill shell on a node not in the cluster, probably the
> edge node which interacts with the cluster. Is it like just download the
> drill tarball and start the shell?
> 2. Is there a UI which I can use to write queries and verify the data,
> instead of using drill shell command line access.
>
> Please let me know, any info on the above points would be helpful.
>
> Thanks,
> Naveen
>
--
*Jim Scott*
Director, Enterprise Strategy & Architecture
+1 (347) 746-9281
@kingmesal <https://twitter.com/kingmesal>
<http://www.mapr.com/>
[image: MapR Technologies] <http://www.mapr.com>
Now Available - Free Hadoop On-Demand Training
<http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available>