[SPARK-9686] Spark Thrift server doesn't return correct JDBC metadata

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Duplicate
• Affects Version/s: 1.4.0, 1.4.1, 1.5.0, 1.5.1, 1.5.2
• Component/s: SQL
• Assignee: Unassigned
• Reporter: pin_zhang
• Created: 06/Aug/15 10:24
• Updated: 09/Oct/20 20:33
• Resolved: 09/Oct/20 20:33

Description

1. Start start-thriftserver.sh
2. connect with beeline
3. create table
4.show tables, the new created table returned
5.
Class.forName("org.apache.hive.jdbc.HiveDriver");
String URL = "jdbc:hive2://localhost:10000/default";
Properties info = new Properties();
Connection conn = DriverManager.getConnection(URL, info);
ResultSet tables = conn.getMetaData().getTables(conn.getCatalog(),
null, null, null);

Problem:
No tables with returned this API, that work in spark1.3

Issue Links

• blocks: SPARK-11785 When deployed against remote Hive metastore with lower versions, JDBC metadata calls throws exception
• duplicates: SPARK-28426 Metadata Handling in Thrift Server
• is related to: SPARK-11783 When deployed against remote Hive metastore, HiveContext.executionHive points to wrong metastore
• links to: [Github] Pull Request #9911 (liancheng)