Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Using JDBC Statement instead of Prepared Statement ?

  1. #1
    Join Date
    Oct 2010
    Posts
    7

    Default Using JDBC Statement instead of Prepared Statement ?

    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 !

  2. #2
    Join Date
    Mar 2003
    Posts
    8,085

    Default

    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.
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

  3. #3
    Join Date
    Oct 2010
    Posts
    7

    Default

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.