[
https://issues.apache.org/jira/browse/DRILL-403?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Nadeau resolved DRILL-403.
----------------------------------
Resolution: Fixed
> Add support for CASE statement
> ------------------------------
>
> Key: DRILL-403
> URL: https://issues.apache.org/jira/browse/DRILL-403
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Aman Sinha
> Assignee: Venki Korukanti
>
> 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)
--
This message was sent by Atlassian JIRA
(v6.2#6252)
