0 Replies Latest reply on Aug 13, 2019 7:43 PM by rjsosi

    Setting up a Hive SQL connection for SQL Developer.

    rjsosi

      Hi\,

       

      We're using SQL Developer Version 19.1.0.094.

       

         I’m trying to set up a Hive connection for SQL Developer using credentials I got from My Aginity connection.

       

      The  credentials I have for Aginity work:

       

      I tried to copy these credentials to “The SQL Developer” login and got the message you see at the bottom.

       

       

      The message I get is:

       

      "Status : Failure -Test failed: [Simba][HiveJDBCDriver](500310) Invalid operation: java.net.ConnectException: Connection refused: connect;"

       

      So when you get a connection refused message what am I missing? Also the port I'm using is 9083. In the Aginity connector, it allows for 2 ports.

       

      Is that going to a problem that I don't have a way to enter the second port number in the SQL Developer Connection?

       

      Also if the server I'm longing into has kerberos authentication do I have to do anything differently?

       

      Thanks!