What is java sql SQLException org apache thrift transport TTransportException in Hive

Question

I'm trying to create a table in hive using java. The code has thrown an exception while execution.

java.sql.SQLException: org.apache.thrift.transport.TTransportException

My code is:

public void createTable(String tableName) {

        try{
            Statement stat = con.createStatement();

        String QueryString = "CREATE TABLE '"+tableName+"'(User_Id INTEGER NOT NULL AUTO_INCREMENT, " + "User_Name VARCHAR(25), UserId VARCHAR(20), User_Pwd VARCHAR(15), primary key(User_Id))";

        a = stat.executeUpdate(QueryString);
        if(a==1){
            System.out.println(a);
            System.out.println("Table has been created");
        }

        }catch(Exception e){
        System.out.println(e);}
} 

What is the reason behind this exception?

How can I fix it.?

Answer 1

This particular exception is related to Hive logs. It says that there are some issues and you are expected to go through your Hive logs Stack where you will find out the exact core reason or error in the log file.

The most common issues are as follows: 

1. Issues with meta store related to concurrency

2. When you start hive server as $hive --service yourhiveserver and keep it running for days and then run your code, it is possible that your connection is the broker to the server and you will get exact same error. If you reconnect to the server and this error will go away. This is only because after some time wait_time expired and disconnect happens.

3. Port specific errors

Be sure to set up an open Port for your Hive Server and set it as below before starting hive server:

 $export HIVE_PORT=10000
 $hive --service hiveserver
 $ _run_your_code

There might other possibilities as well. I suggest you look into the Hive Logs.

I hope this helps. Happy Learning...;-)