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 < [email protected]> 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 <[email protected]> > 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 <[email protected]> > > 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 < > >> [email protected]> > >> 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 <[email protected] > > > >>> 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 < > >>>> [email protected]> 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 < > >> [email protected]> > >>>>> 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 < > >>>>>> [email protected]> 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 <[email protected]> > >>> 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 < > >>>> [email protected] > >>>>>> > >>>>>>>> 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 > >>>>>>>> > >>>>>>> > >>>>>>> > >>>>> > >>>>> > >>>> > >>> > >> > >
