[
https://issues.apache.org/jira/browse/HIVE-4573?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13728815#comment-13728815
]
Prasad Mujumdar commented on HIVE-4573:
---------------------------------------
[~hagleitn] Thanks for taking a look.
IMO, both use cases are valid. For applications or admin/monitoring tools
developed specifically for hive, it would be useful to keep the hive specific
details. Also we don't would break backward compatibility for existing apps
that are expecting the hive way. That's my rationale for the fix.
If that sounds reasonable, I will go ahead and make the necessary doc changes.
> Support alternate table types for HiveServer2
> ---------------------------------------------
>
> Key: HIVE-4573
> URL: https://issues.apache.org/jira/browse/HIVE-4573
> Project: Hive
> Issue Type: Bug
> Components: HiveServer2, JDBC
> Affects Versions: 0.10.0
> Reporter: Johndee Burks
> Assignee: Prasad Mujumdar
> Priority: Minor
> Attachments: HIVE-4573.1.patch
>
>
> 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.
> {code}
> 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"));
> }
> }
> }
> }
> {code}
--
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: http://www.atlassian.com/software/jira
