Hi,
I’m encountering this error while using Tableau with Drill:
(org.apache.drill.exec.work.foreman.ForemanException) Unexpected exception
during fragment initialization: Internal error: while converting CASE WHEN 1000
= 0 THEN NULL ELSE CAST(`Custom_SQL_Query`.`Clip Duration Ms` AS FLOAT) / 1000
END
Caused By (java.lang.UnsupportedOperationException) class
org.apache.calcite.sql.SqlLiteral: NULL
org.apache.calcite.util.Util.needToImplement():920
org.apache.calcite.sql.validate.SqlValidatorImpl.getValidatedNodeType():1420
org.apache.calcite.sql2rel.SqlNodeToRexConverterImpl.convertLiteral():90
org.apache.calcite.sql2rel.SqlToRelConverter$Blackboard.visit():4153
org.apache.calcite.sql2rel.SqlToRelConverter$Blackboard.visit():3598
org.apache.calcite.sql.SqlLiteral.accept():404
org.apache.calcite.sql2rel.SqlToRelConverter$Blackboard.convertExpression():4057
org.apache.calcite.sql2rel.StandardConvertletTable.convertCase():303
sun.reflect.GeneratedMethodAccessor162.invoke():-1
sun.reflect.DelegatingMethodAccessorImpl.invoke():43
java.lang.reflect.Method.invoke():606
I’m trying to understand what it means exactly. Is NULL not supported? Is there
a property I can set to enable it? I didn’t find anything to help me in the
docs.
Maybe worth mentioning that I didn’t actually see the error in Tableau. I
enabled verbose errors in drill console and actually copied the query and ran
it in the console.
Thanks,
Ali Kashmar
EMC| Open Innovation Lab
O: 613.321.1334 | M: 613.219.9361
