[DRILL-4682] Allow full schema identifier in SELECT clause

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: SQL Parser
• Assignee: Vitalii Diravka
• Reporter: Andries Engelbrecht
• Created: 17/May/16 15:08
• Updated: 11/Mar/19 13:34

Description

Currently Drill requires aliases to identify columns in the SELECT clause when working with multiple tables/workspaces.

Many BI/Analytical and other tools by default will use the full schema identifier in the select clause when generating SQL statements for execution for generic JDBC or ODBC sources. Not supporting this feature causes issues and a slower adoption of utilizing Drill as an execution engine within the larger Analytical SQL community.

Propose to support

SELECT <storage_plugin>.<workspace>.<table>.<column> FROM <storage_plugin>.<workspace>.<table>

Also see DRILL-3510 for double quote support as per ANSI_QUOTES

SELECT "<storage_plugin>"."<workspace>"."<table>"."<column>" FROM "<storage_plugin>"."<workspace>"."<table>"

Which is very common generic SQL being generated by most tools when dealing with a generic SQL data source.

Issue Links

• Dependent: DRILL-3993 Rebase Drill on Calcite master branch
• relates to: CALCITE-1208 Improve two-level column structure handling
• links to: GitHub Pull Request #549
• links to: GitHub Pull Request #549