[HIVE-24092] Implement additional JDBC methods required by JDBC storage handler

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: JDBC storage handler
• Assignee: Kishen Das
• Reporter: Jesús Camacho Rodríguez
• Created: 29/Aug/20 16:51
• Updated: 27/Feb/24 22:24
• Resolved: 10/Sep/20 15:41

Description

Calcite may rely on the following JDBC methods to generate SQL queries for Hive JDBC storage handler, which in the case of Hive itself, return a Method not supported exception. We should implement such methods:

nullsAreSortedAtEnd
nullsAreSortedAtStart
nullsAreSortedLow
nullsAreSortedHigh
storesLowerCaseIdentifiers
storesLowerCaseQuotedIdentifiers
storesMixedCaseIdentifiers
storesMixedCaseQuotedIdentifiers
storesUpperCaseIdentifiers
storesUpperCaseQuotedIdentifiers
supportsMixedCaseIdentifiers
supportsMixedCaseQuotedIdentifiers

Issue Links

• relates to: IMPALA-12806 Set HIVE_DEFAULT_NULLS_LAST in HS2 OpenSession Response
• links to: pull request 1443