drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andries Engelbrecht <aengelbre...@maprtech.com>
Subject Re: Drill Installation Question
Date Tue, 18 Aug 2015 21:36:27 GMT
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 <abhishek.girish@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 <vmadhire@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 <jscott@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
>>>>>>>> 
>>>>>>> 
>>>>>>> 
>>>>> 
>>>>> 
>>>> 
>>> 
>> 


Mime
View raw message