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 using remote connections. —Andries > On Oct 20, 2015, at 12:05 AM, Rajkumar Singh <[email protected]> wrote: > > 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 <[email protected]> wrote: >> >> 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 <[email protected]> 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 >>> @tgrall >>> >>> On Mon, Oct 19, 2015 at 10:05 PM, De La Fuente, Pedro >>> <[email protected]> wrote: >>>> 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 explorer it just says processing query in a >>>> separate window and never comes back. >>>> >>>> >>>> >>>> I have tried to configure the settings in Drill webpage - Storage with the >>>> following settings: >>>> >>>> >>>> >>>> { >>>> >>>> "type": "hbase", >>>> >>>> "config": { >>>> >>>> "hbase.zookeeper.quorum": "c2ctsdrtpro", >>>> >>>> "hbase.zookeeper.property.clientPort": "4242" >>>> >>>> }, >>>> >>>> "size.calculator.enabled": false, >>>> >>>> "enabled": true >>>> >>>> } >>>> >>>> >>>> >>>> >>>> >>>> If the configurations are not set correctly, why would the test work >>>> successfully? >>>> >>>> >>>> Thanks, >>>> >>>> Pete >> >
