Penatho Analyzer using MongoDB Optiq SQL translate error

[Joel Latino]

The Optiq as jdbc driver for mongodb seems doesn't support the minimal SQL for mondrian (like Kettle jdbc supports http://wiki.pentaho.com/display/EAI/JDBC+and+SQL+Reference).

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]

I think thats something Julian is working on at the moment.

See: https://twitter.com/julianhyde/status/461967033115373569

"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.

-Paul

--
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 optiq-dev+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Julian Hyde]

Yeah, looks like https://github.com/julianhyde/optiq/issues/270. I’ve added this query to that issue.

Julian