[DRILL-4714] Add metadata and prepared statement APIs to DrillClient<->Drillbit interface

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Metadata
• Assignee: Venki Korukanti
• Reporter: Venki Korukanti
• Reviewer: Chun Chang
• Created: 08/Jun/16 17:04
• Updated: 21/Mar/17 00:33

Description

Currently ODBC/JDBC drivers spawn a set of queries on INFORMATION_SCHEMA for metadata. Client has to deal with submitting a query, reading query results and constructing required objects. Sometimes same work is done twice (planning work in case of prepare statements) to get the metadata and execute query. Instead we could simplify the client by providing APIs on the client interface and let the server construct the required objects and send them to client directly. These APIs provide common info that can be consumed by the JDBC/ODBC driver.

Here is the doc explaining the new APIs.

Sub-Tasks

• Improvements to InfoSchema RecordGenerator needed for DRILL-4714: Closed
• Add support for new metadata fetch APIs: Closed
• Add support for prepared statement implementation on server side: Closed
• Update JDBC DatabaseMetaData implementation to use new Metadata APIs: Closed
• Update JDBC driver to use the new prepared statement APIs on DrillClient: Closed
• Add cancel for create prepare statement (and possibly other metadata APIs): Open
• Add column size information to ColumnMetadata: Closed
• Basic implementation for displaySize: Closed