[ https://issues.apache.org/jira/browse/DRILL-2859?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Victoria Markman updated DRILL-2859: ------------------------------------ Labels: interval (was: ) > Unexpected exception in the query with an interval data type > ------------------------------------------------------------ > > Key: DRILL-2859 > URL: https://issues.apache.org/jira/browse/DRILL-2859 > Project: Apache Drill > Issue Type: Bug > Components: Query Planning & Optimization > Affects Versions: 0.9.0 > Reporter: Victoria Markman > Priority: Critical > Labels: interval > Fix For: Future > > > {code} > 0: jdbc:drill:schema=dfs> select cast(cast(a1 as int) as interval day) from > t1 where a1 = 1; > Query failed: SYSTEM ERROR: Unexpected exception during fragment > initialization: todo: implement syntax > SPECIAL(Reinterpret(*(Reinterpret(CAST(CAST($0):INTEGER):DECIMAL(2, 0)), > 86400000))) > [5119315b-dd73-432f-ab93-49e76e9165f6 on atsqa4-134.qa.lab:31010] > (org.apache.drill.exec.work.foreman.ForemanException) Unexpected exception > during fragment initialization: todo: implement syntax > SPECIAL(Reinterpret(*(Reinterpret(CAST(CAST($0):INTEGER):DECIMAL(2, 0)), > 86400000))) > org.apache.drill.exec.work.foreman.Foreman.run():212 > java.util.concurrent.ThreadPoolExecutor.runWorker():1145 > java.util.concurrent.ThreadPoolExecutor$Worker.run():615 > java.lang.Thread.run():745 > Caused By (java.lang.AssertionError) todo: implement syntax > SPECIAL(Reinterpret(*(Reinterpret(CAST(CAST($0):INTEGER):DECIMAL(2, 0)), > 86400000))) > > org.apache.drill.exec.planner.logical.DrillOptiq$RexToDrill.visitCall():182 > org.apache.drill.exec.planner.logical.DrillOptiq$RexToDrill.visitCall():73 > org.apache.calcite.rex.RexCall.accept():107 > org.apache.drill.exec.planner.logical.DrillOptiq.toDrill():70 > > org.apache.drill.exec.planner.common.DrillProjectRelBase.getProjectExpressions():111 > > org.apache.drill.exec.planner.physical.ProjectPrel.getPhysicalOperator():57 > org.apache.drill.exec.planner.physical.ScreenPrel.getPhysicalOperator():51 > > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToPop():376 > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():157 > org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():167 > org.apache.drill.exec.work.foreman.Foreman.runSQL():773 > org.apache.drill.exec.work.foreman.Foreman.run():203 > java.util.concurrent.ThreadPoolExecutor.runWorker():1145 > java.util.concurrent.ThreadPoolExecutor$Worker.run():615 > java.lang.Thread.run():745 > Error: exception while executing query: Failure while executing query. > (state=,code=0) > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)