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