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: 1.0.0-milestone-1
    • 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

        Hide
        Jacques Nadeau added a comment -

        Resolved in commits through 65ffe9bd020cddb29b3aefe398928c4e36c76565

        Show
        Jacques Nadeau added a comment - Resolved in commits through 65ffe9bd020cddb29b3aefe398928c4e36c76565
        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.
        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 -

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

        Show
        Julian Hyde added a comment - Now working on some more operators (filter, aggregate etc.)
        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 -

        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.

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development