Penatho Analyzer using MongoDB Optiq SQL translate error

Skip to first unread message

Joel Latino

May 6, 2014, 5:06:01 AM5/6/14
The Optiq as jdbc driver for mongodb seems doesn't support the minimal SQL for mondrian (like Kettle jdbc supports

2014-05-05 17:43:45,362 DEBUG [mondrian.rolap.RolapUtil] SqlTupleReader.readTuples [[Account Name].[Account Name]]: executing sql [select "dataTest"."name" as "c0" from "sampleTest"."dataTest" as "dataTest" group by "dataTest"."name" having NOT((sum("dataTest"."valueProduct") is null))  order by CASE WHEN "dataTest"."name" IS NULL THEN 1 ELSE 0 END, "dataTest"."name" ASC], failed (java.lang.AssertionError: cannot translate NOT(IS NULL($1)))
2014-05-05 17:43:45,575 ERROR [com.pentaho.analyzer.b.c] Ticket Number: 1399308225575
2014-05-05 17:43:45,575 ERROR [com.pentaho.analyzer.b.c] Exception in AJAX handler.
java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.lang.AssertionError: cannot translate NOT(IS NULL($1))

Paul Stoellberger

May 6, 2014, 5:47:36 AM5/6/14
I think thats something Julian is working on at the moment.

"Having wasted 1/2 hr trying to translate 'y > CASE x WHEN NULL THEN 0 ELSE x END' into @MongoDB I'm considering switching to APL.”

I thought that mongo was ok with mondrian queries already, but it seems like there is stuff missing.


You received this message because you are subscribed to the Google Groups "optiq-dev" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
For more options, visit

Julian Hyde

May 7, 2014, 7:52:48 PM5/7/14
Yeah, looks like I’ve added this query to that issue.

Reply all
Reply to author
0 new messages