Apache Drill
  1. Apache Drill
  2. DRILL-34

Build SQL parser that generates Logical Plan

    Details

    • Type: New Feature New Feature
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: m1
    • Component/s: None
    • Labels:
      None
    • Target Version/s:
      m1

      Description

      Build v1 of a SQL parser that converts standard SQL queries into an Apache Drill logical plan including transformation of select queries that include from, join, where, group by, order by and having clauses

        Activity

        Jacques Nadeau created issue -
        Julian Hyde made changes -
        Field Original Value New Value
        Assignee Julian Hyde [ julianhyde ]
        Julian Hyde made changes -
        Status Open [ 1 ] In Progress [ 3 ]
        Hide
        Julian Hyde added a comment -

        I'm starting work on this one. Hopefully by the end of the week I'll be able to check into sandbox/prototype/sqlparser some code that uses optiq and a dummy schema and converts a very simple statement "select * from table" into a logical plan.

        Show
        Julian Hyde added a comment - I'm starting work on this one. Hopefully by the end of the week I'll be able to check into sandbox/prototype/sqlparser some code that uses optiq and a dummy schema and converts a very simple statement "select * from table" into a logical plan.
        Show
        Julian Hyde added a comment - Implementation of simple query checked in at https://github.com/julianhyde/incubator-drill/commit/7f294adb649064e26dd2f28864260b17b07315ef . It's in pull request https://github.com/apache/incubator-drill/pull/6 .
        Hide
        Julian Hyde added a comment -

        Now working on some more operators (filter, aggregate etc.)

        Show
        Julian Hyde added a comment - Now working on some more operators (filter, aggregate etc.)
        Hide
        Jacques Nadeau added a comment -

        Initial implementation was merged into trunk. Had to do some modifications to match latest logical plan syntax updates.

        Show
        Jacques Nadeau added a comment - Initial implementation was merged into trunk. Had to do some modifications to match latest logical plan syntax updates.
        Hide
        Julian Hyde added a comment -

        Patch containing work to date – SQL parser and JDBC driver.

        Show
        Julian Hyde added a comment - Patch containing work to date – SQL parser and JDBC driver.
        Julian Hyde made changes -
        Julian Hyde made changes -
        Status In Progress [ 3 ] Open [ 1 ]
        Jake Farrell made changes -
        Workflow jira [ 12760614 ] no-reopen-closed, patch-avail [ 12807508 ]
        Jacques Nadeau made changes -
        Target Version/s 0.1 [ 12324669 ]
        Hide
        Jacques Nadeau added a comment -

        Resolved in commits through 65ffe9bd020cddb29b3aefe398928c4e36c76565

        Show
        Jacques Nadeau added a comment - Resolved in commits through 65ffe9bd020cddb29b3aefe398928c4e36c76565
        Jacques Nadeau made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Jacques Nadeau made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Jacques Nadeau made changes -
        Fix Version/s M1 [ 12324669 ]
        Jake Farrell made changes -
        Workflow no-reopen-closed, patch-avail [ 12807508 ] no-reopen-closed, patch-avail, testing [ 12860348 ]
        Tony Stevenson made changes -
        Workflow no-reopen-closed, patch-avail, testing [ 12860348 ] Drill workflow [ 12933915 ]

          People

          • Assignee:
            Julian Hyde
            Reporter:
            Jacques Nadeau
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development