Re: Apache Drill connecting to OpenTSDB hbase

2015-10-20 Thread Rajkumar Singh
It seems that you are able to connect to drill using direct drillbit connection thats why you are able to get success on the Test connection.can you check whether you are able to access the zookeeper quorum from your client machine. > On 20-Oct-2015, at 11:01 AM, Rajkumar Singh

Re: Apache Drill connecting to OpenTSDB hbase

2015-10-20 Thread Ted Dunning
Chad's right. This is complicated stuff to pull apart for most users. On Tue, Oct 20, 2015 at 9:49 AM, Chad Smykay wrote: > On these note we could REALLY use a UDF for OpenTSDB tables from Drill. > -- > Kind Regards, > Chad Smykay | Solutions Architect | M:

Re: Apache Drill connecting to OpenTSDB hbase

2015-10-20 Thread Andries Engelbrecht
Thx Jim, very good info. I think Pete’s connectivity issue is that he is using the OpenTSB port instead of the ZK port (2181 or 5181) in the Drill plugin configuration. Once he fixes that Drill will be able to access the data in HBase or MapR-DB, then will need to look into the data elements

Re: Apache Drill connecting to OpenTSDB hbase

2015-10-20 Thread Andries Engelbrecht
4242 is an unusual ZK port, typically it is 2181 or 5181, is there a reason it is 4242? The Hbase plugin can hang for a while if not configured properly and in some cases cause connectivity loss through ODBC/JDBC. Try to access HBase plugin through sqlline first on the cluster directly before

Re: Apache Drill connecting to OpenTSDB hbase

2015-10-20 Thread Jim Scott
4242 is the OpenTSDB Daemon port. OpenTSDB isn't a database, rather it depends on HBase or MapR-DB. In either case OpenTSDB connects to one of those databases and uses the tables in that database. So, when you are wanting to work with OpenTSDB data you are really wanting to query the table in

Apache Drill connecting to OpenTSDB hbase

2015-10-19 Thread De La Fuente, Pedro
Hi, I am currently trying to connect to an OpenTSDB database with Apache Drill. The test works successfully in the MAPR Drill ODBC Driver DSN Setup (Test button) after entering the connection type of Direct to DrillBit (host:port) and no authentication type. Next, when I open drill

Re: Apache Drill connecting to OpenTSDB hbase

2015-10-19 Thread Tugdual Grall
Hello, Have you tried to run a simple query from SqlLine or Web UI? (with a limit just to be sure) Any error? Tug @tgrall On Mon, Oct 19, 2015 at 10:05 PM, De La Fuente, Pedro wrote: > Hi, > > > I am currently trying to connect to an OpenTSDB database with

Re: Apache Drill connecting to OpenTSDB hbase

2015-10-19 Thread Rajkumar Singh
Did you see any exception in drillbit logs and also what is the underlying Hbase version? > On 20-Oct-2015, at 10:30 AM, Tugdual Grall wrote: > > Hello, > > Have you tried to run a simple query from SqlLine or Web UI? (with a > limit just to be sure) > Any error? > > Tug