Reply
New Contributor
Posts: 1
Registered: ‎02-18-2015

Connect to Cloudera Live Impala via JDBC => java.net.ConnectException

I want to connect to Impala running on the Cloudera Live trial. I did not make any changes to Cloudera Live. Just tried out the tutorial and made some Impala queries. Works!

 

I use this configuration in my external tool on my Mac:

 

    <data-source name="impala" type="jdbc">
      <uri value="jdbc:impala://216.121.116.50:21050/;auth=noSasl"/>
      <driver value="com.cloudera.impala.jdbc4.Driver"/>
      <param name="user" value="cloudera"/>
      <param name="password" value="cloudera"/>
    </data-source>

 

I also added all JARs (JDBC4 etc.) to the built path. Drivers seem to be loaded successfully. I get the following exception:


20:48:21    system.error    description=Evaluation exception: SQLException while retrieving JDBC Connection: [Simba][ImpalaJDBCDriver](500310) Invalid operation: java.net.ConnectException: Connection refused;, originalTuple={}, operatorName=default.GetBids, inputPort=0, nodeName=null, type=eval-error, action=continue, time=2015-02-18 20:48:21.000+0100

 

I assume I use wrong user and password :-) Or do you see any other wrong configuration? Where can I find the correct credentials in my Cloudera Live user interface? Via email, I only received Cloudera Manager and HUE Query UI.

 

Thanks for help...

 

 

 

 

Announcements