[HIVE-7676] JDBC: Support more DatabaseMetaData, ResultSetMetaData methods

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.13.1
• Fix Version/s: 0.14.0
• Component/s: JDBC
• Assignee: Alexander Pivovarov
• Reporter: Alexander Pivovarov
• Created: 11/Aug/14 06:33
• Updated: 11/Aug/15 01:28
• Resolved: 13/Aug/14 21:13

Description

I noticed that some methods in HiveDatabaseMetaData throws exceptions instead of returning true/false. Many JDBC clients expects implementations for particular methods in order to work.

E.g. SQuirreL SQL shows databases only if supportsSchemasInTableDefinitions returns true.

Also hive 0.14.0 supports UNION ALL and does not support UNION
We can indicate this in HiveDatabaseMetaData instead of throwing Method Not supported exception.

getIdentifierQuoteString should return space if not supported.
http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getIdentifierQuoteString%28%29

Issue Links

• blocks: HIVE-11516 Fix JDBC compliance issues
• is related to: HIVE-7680 Do not throw SQLException for HiveStatement getMoreResults and setEscapeProcessing(false)
• is related to: HIVE-7722 TestJdbcDriver2.testDatabaseMetaData fails after HIVE-7676
• is related to: HIVE-3217 Implement HiveDatabaseMetaData.getFunctions() to retrieve registered UDFs.
• is related to: HIVE-4806 Add more implementations of JDBC API methods to Hive and Hive2 drivers
• relates to: HIVE-2935 Implement HiveServer2