I'm using Pentaho EE with InfiniDB.
Everything works well, except for distinct-count measures.
When using this kind of measure, the SQL query generated by Pentaho raises an error in InfiniDB (wich does not happens when using MySQL).
Here is the error:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'orderfact.QUANTITYORDERED' in 'having clause'
Abd the SQL:
[select `products`.`PRODUCTLINE` as `c0` from `products` as `products`, `orderfact` as `orderfact` where `orderfact`.`PRODUCTCODE` = `products`.`PRODUCTCODE` group by `products`.`PRODUCTLINE` having (NOT((sum(`orderfact`.`QUANTITYORDERED`) is null)) OR NOT((count(distinct `orderfact`.`QUANTITYORDERED`) is null)) ) order by ISNULL(`products`.`PRODUCTLINE`) ASC, `products`.`PRODUCTLINE` ASC]
The same query, when executed in MySQL runs perfectly!
My guess is that it has something to do with "only_full_group_by" SQL mode.
Am I right? Can I change any parameter in InfiniDB 4 to make things work?
Thanks in advance