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.gir...@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 <vmadh...@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.gir...@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 <vmadh...@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 < >>>> aengelbre...@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 < >> vmadh...@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 < >>>>>> aengelbre...@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 <jsc...@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 < >>>> vmadh...@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 >>>>>>>> >>>>>>> >>>>>>> >>>>> >>>>> >>>> >>> >>