Using JDBC Statement instead of Prepared Statement ?

[Eligriv]

Hello everyone, I'd like to use Pentaho reporting on a database (hadoop+hive) but its jdbc driver does not support PreparedStatement. Is there a way to do that ? Thanks !

[Taqua]

Nope, not with the existing releases. In 3.7, you can use the Advanced-SQL datasource to parametrize your query manually - and if your resulting query does not contain any parameter-placeholders (${..}) then we will switch to a ordinary statement (non-prepared). AFAIK pentaho is also working on extending the hive driver to allow prepared statements, but I have no insight on how far that project is.

[Eligriv]

Thank for your answer Do you know where i could find the 3.7 version of pentaho reporting ?