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: 0.1.0-m1
    • Component/s: None
    • Labels:
      None

      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 ]
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open In Progress In Progress
        1d 9h 26m 1 Julian Hyde 12/Feb/13 07:56
        In Progress In Progress Open Open
        83d 16h 27m 1 Julian Hyde 07/May/13 01:23
        Open Open Resolved Resolved
        107d 23h 49m 1 Jacques Nadeau 23/Aug/13 01:13
        Resolved Resolved Closed Closed
        47d 17h 51m 1 Jacques Nadeau 09/Oct/13 19:05

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development