Pentaho dialect error

5 posts / 0 new
Last post
rodrigonovo
rodrigonovo's picture
Offline
Last seen: 3 months 2 weeks ago
Joined: Jan 28 2014
Junior Boarder

Posts: 7

Rodrigo Porto
Pentaho dialect error

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

radams
radams's picture
Offline
Last seen: 17 hours 4 min ago
Joined: Jan 3 2011
Administrator

Posts: 493

Robert Adams
Re: Pentaho dialect error

Hi,

We found an issue when using a having statement with a count(distinct). We will have a fix for this issue in our next maintenance release (4.0.2) which will be out in February.

Thanks,

Robert

rodrigonovo
rodrigonovo's picture
Offline
Last seen: 3 months 2 weeks ago
Joined: Jan 28 2014
Junior Boarder

Posts: 7

Rodrigo Porto
Re: Pentaho dialect error

Robert,

Thanks for the status report.
I will test this release when it comes out and update this topic with the results.

Regards

rodrigonovo
rodrigonovo's picture
Offline
Last seen: 3 months 2 weeks ago
Joined: Jan 28 2014
Junior Boarder

Posts: 7

Rodrigo Porto
Hello Robert!

Hello Robert!

 

I saw that version 4.0.2 is out!

Do you know if this issue has been corrected?

 

If yes, how can apply this patch in my current installation?

Just reinstall the newer version over the current one?

 

Thanks for your help!

 

Regards

radams
radams's picture
Offline
Last seen: 17 hours 4 min ago
Joined: Jan 3 2011
Administrator

Posts: 493

Robert Adams
 Hi, The issue we corrected

 

Hi,

 

The issue we corrected was for Bug 5363 in the readme file.

 

Follow the upgrade procedure in the Installation Guide to perform the upgrade.

 

Thanks,

 

Robert