Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-4682

Allow full schema identifier in SELECT clause

Attach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • SQL Parser
    • None

    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.

      Attachments

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            vitalii Vitalii Diravka
            aengelbrecht Andries Engelbrecht

            Dates

              Created:
              Updated:

              Slack

                Issue deployment