What is the symptom you see from Tableau? Did you see some kind of disconnection or a white-out screen?
On Tue, Mar 8, 2016 at 1:34 PM, Kashmar, Ali <[email protected]> wrote: > 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 > -- Luca Candela *Dir. of Product, Dremio* *www.dremio.com <http://www.dremio.com>*
