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 > > > >>> > > > >> > > > >> > > > > > > > > >
