[HIVE-4573] Support alternate table types for HiveServer2

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.10.0
• Fix Version/s: 0.12.0
• Component/s: HiveServer2, JDBC

Release Note

Adds new config parameter that needs to be documented:

<property>
  <name>hive.server2.table.type.mapping</name>
  <value>HIVE</value>
  <description>
   This setting reflects how HiveServer will report the table types for JDBC and other
   client implementations that retrieves the available tables and supported table types
     HIVE : Exposes the hive's native table tyes like MANAGED_TABLE, EXTERNAL_TABLE, VIRTUAL_VIEW
     CLASSIC : More generic types like TABLE and VIEW
  </description>
</property>

• Assignee: Prasad Suresh Mujumdar
• Reporter: Johndee Burks
• Created: 17/May/13 06:04
• Updated: 03/May/15 04:08
• Resolved: 06/Aug/13 00:13

Description

The getTables jdbc function no longer returns information when using normal JDBC table types like TABLE or VIEW. You must now use a more specific type such as MANAGED_TABLE or VIRTUAL_VIEW. An example application that will fail to return results against 0.10 is below, works without issue in 0.9. In my 0.10 test I used HS2.

import java.sql.SQLException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.DriverManager;
import org.apache.hive.jdbc.HiveDriver;
import java.sql.DatabaseMetaData;

public class TestGet {
  private static String driverName = "org.apache.hive.jdbc.HiveDriver";

  /**
 * @param args
 * @throws SQLException
   */
  public static void main(String[] args) throws SQLException {
      try {
      Class.forName(driverName);
    } catch (ClassNotFoundException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
      System.exit(1);
    }
    Connection con = DriverManager.getConnection("jdbc:hive2://hostname:10000/default");
    DatabaseMetaData dbmd = con.getMetaData();
    String[] types = {"TABLE"};
    ResultSet rs = dbmd.getTables(null, null, "%", types);
      while (rs.next()) {
        System.out.println(rs.getString("TABLE_NAME"));
      }
    }
  }
}

Issue Links

• is related to: HIVE-4998 support jdbc documented table types in default configuration