hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Johndee Burks (JIRA)" <>
Subject [jira] [Created] (HIVE-4573) JDBC Compliance getTables
Date Fri, 17 May 2013 06:05:17 GMT
Johndee Burks created HIVE-4573:

             Summary: JDBC Compliance getTables
                 Key: HIVE-4573
             Project: Hive
          Issue Type: Bug
          Components: JDBC
    Affects Versions: 0.10.0
            Reporter: Johndee Burks
            Priority: Minor

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 {
    } catch (ClassNotFoundException e) {
      // TODO Auto-generated catch block
    Connection con = DriverManager.getConnection("jdbc:hive2://hostname:10000/default");
    DatabaseMetaData dbmd = con.getMetaData();
    String[] types = {"TABLE"};
    ResultSet rs = dbmd.getTables(null, null, "%", types);
      while ( {

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:

View raw message