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

Build SQL parser that generates Logical Plan

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: 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

        Hide
        julianhyde 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
        julianhyde 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
        julianhyde 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
        julianhyde Julian Hyde added a comment -

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

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

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

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

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

        Show
        julianhyde Julian Hyde added a comment - Patch containing work to date – SQL parser and JDBC driver.
        Hide
        jnadeau Jacques Nadeau added a comment -

        Resolved in commits through 65ffe9bd020cddb29b3aefe398928c4e36c76565

        Show
        jnadeau Jacques Nadeau added a comment - Resolved in commits through 65ffe9bd020cddb29b3aefe398928c4e36c76565

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development