[DRILL-3180] Apache Drill JDBC storage plugin to query rdbms systems such as MySQL and Netezza from Apache Drill

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.0
• Fix Version/s: 1.2.0
• Component/s: Storage - Other
• Labels: Drill JDBC plugin
• Assignee: Jacques Nadeau
• Reporter: Magnus Pierre
• Created: 26/May/15 06:47
• Updated: 23/Dec/15 20:27
• Resolved: 14/Sep/15 05:29

Description

I have developed the base code for a JDBC storage-plugin for Apache Drill. The code is primitive but consitutes a good starting point for further coding. Today it provides primitive support for SELECT against RDBMS with JDBC.

The goal is to provide complete SELECT support against RDBMS with push down capabilities.

Currently the code is using standard JDBC classes.

Sub-Tasks

• Push down joins into source db: Open
• Unregister driver when database is not available: Open
• Validate GroupScan applyAssignments to improve efficiency: Open
• Push down aggregate operations to source db: Open
• Provide accurate estimates / statistics to Drill: Open