Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.4.0
    • Component/s: None
    • Labels:
      None

      Description

      Drill currently throws an error for CASE statements. This issue is to track adding support for such statements.

      select case when N_NATIONKEY = 0 then 1 end from dfs.`/tmp/parquet/nation.parquet` ;
      Exception in thread "WorkManager-2" java.lang.AssertionError: todo: implement syntax SPECIAL(CASE(=(CAST($0):INTEGER NOT NULL, 0), 1, null))
      at org.apache.drill.exec.planner.logical.DrillOptiq$RexToDrill.visitCall(DrillOptiq.java:113)
      at org.apache.drill.exec.planner.logical.DrillOptiq$RexToDrill.visitCall(DrillOptiq.java:63)

        Activity

        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Resolved Resolved
        81d 4h 9m 1 Jacques Nadeau 28/May/14 23:15
        Tony Stevenson made changes -
        Workflow no-reopen-closed, patch-avail, testing [ 12860200 ] Drill workflow [ 12933760 ]
        Jacques Nadeau made changes -
        Fix Version/s 0.4.0 [ 12324963 ]
        Hide
        Jacques Nadeau added a comment -

        Fixed

        Show
        Jacques Nadeau added a comment - Fixed
        Jacques Nadeau made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Jake Farrell made changes -
        Workflow no-reopen-closed, patch-avail [ 12846739 ] no-reopen-closed, patch-avail, testing [ 12860200 ]
        Jacques Nadeau made changes -
        Field Original Value New Value
        Assignee Venki Korukanti [ vkorukanti ]
        Hide
        Jacques Nadeau added a comment -

        This is also required for TPC-H 12

        Show
        Jacques Nadeau added a comment - This is also required for TPC-H 12
        Aman Sinha created issue -

          People

          • Assignee:
            Venki Korukanti
            Reporter:
            Aman Sinha
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development