HiverServer1 Connection timed out

[adrian barredo]

Hi all!
I'm with a JDBC program to connect to hive and extract data from a DB.
Here is a part of my code:

 public class HiveClient {
    // JDBC driver required for Hive connections
    private static String driverName = "org.apache.hadoop.hive.jdbc.HiveDriver";
    private static Connection con;

    private static Connection getConnection(String ip, String port, String user, String password) {
       try {
          // dynamically load the Hive JDBC driver
          Class.forName(driverName);
       } catch (ClassNotFoundException e) {
          System.out.println(e.getMessage());
          return null;
       } // try catch
      
       try {
          // return a connection based on the Hive JDBC driver
          return DriverManager.getConnection("jdbc:hive://" + ip + ":" + port + "/default?user=" + user + "&password=" + password);
          
       } catch (SQLException e) {
          System.out.println(e.getMessage());
          return null;
       } // try catch
    } // getConnection

    public static void main (String[] args) {
       try {
          // from here on, everything is SQL!
          con = getConnection("130.206.80.46", "10000", "myuser", "mypasswd");
          Statement stmt = con.createStatement();

Of course, I write my own user and password in the corresponding part.
When I execute that code, I get this message:

SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.

Could not establish connection to 130.206.80.46:10000/default?user=myuser&password=mypasswd: java.net.ConnectException: Connection timed out
Exception in thread "main" java.lang.NullPointerException
    at hiveclient.HiveClient.main(HiveClient.java:39)
Java Result: 1

Line 39 is "Statement stmt = con.createStatement(); "
Could anyone help me with this problem? Server is online because it answers my pings.
Thank you so much.

[K. Tsang]

Assuming your connection string is correct. The problem is which exception (ClassNotFoundException or SQLException) gives you the null? The first one or second one?

Is the driver class in the classpath when you run the program?

[adrian barredo]

Hi! It's the second try catch what gives me error. Hive driver is loaded in the proyect library (I use netbeans)

[K. Tsang]

Then I suggest you use the other getConnection() method:

DriverManager.getConnection("jdbc:hive://" + ip + ":" + port + "/default", user, password)

If that doesn't work, you connection string may be wrong. Is there a "default" database?

[adrian barredo]

hi! thanks for you response.

"default" database should exist, it's in the main guide:

http://forge.fi-ware.org/plugins/mediawiki/wiki/fiware/index.php/BigData_Analysis_-_User_and_Programmer_Guide#Installing_Cosmos_CLI

I've tried your code and I get this message now, I think we're on the good way:

org.apache.thrift.transport.TTransportException: java.net.SocketException: Software caused connection abort: recv failed
Exception in thread "main" java.lang.NullPointerException
	at HiveClient.main(HiveClient.java:38)
Java Result: 1

[K. Tsang]

Apparently that's the same error, still a NullPointerException for "conn".

Check out https://cwiki.apache.org/confluence/display/Hive/HiveClient (the user and password in the sample code is blank). Maybe you don't need a user/password for default database.

[adrian barredo]

Yes, that's the standalone hive. I've used that code some days ago and it worked properly.
Nowadays what I'd like to do is to connect to a remote Hive, not to a local one.
I've tried to send the user and password fields in blank, to send my own user data or to send "myuser" "mypasswd", but I don't get it yet.