Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: not able to query - hive-0.8.0 from Report designer

  1. #1
    Join Date
    Jul 2012
    Posts
    3

    Default not able to query - hive-0.8.0 from Report designer

    successfully tested connection to hive -0.8.0 from report designer(ver 3.8.2). but unable to execute queries(preview data).the jdbc folder within the report designer has jar below jar files.
    hive-exec-0.7.0-pentaho-1.0.0
    hive-jdbc-0.7.0-pentaho-1.0.0
    hive-metastore-0.7.0-pentaho-1.0.0
    hive-service-0.7.0-pentaho-1.0.0
    hive-jdbc-0.7.0-pentaho-SNAPSHOT
    should the jar files be corresponding to hive 0.8 version. if so can i get the link to download the files.
    error message below
    ****************************************************************************************************************************
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: show tables
    at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:254)
    at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:95)
    at org.pentaho.reporting.ui.datasources.jdbc.ui.JdbcPreviewWorker.run(JdbcPreviewWorker.java:103)
    at java.lang.Thread.run(Unknown Source)
    ParentException:
    java.sql.SQLException: Error retrieving next row
    at org.apache.hadoop.hive.jdbc.HiveQueryResultSet.next(HiveQueryResultSet.java:173)
    at org.pentaho.reporting.engine.classic.core.modules.misc.tablemodel.ResultSetTableModelFactory.generateDefaultTableModel(ResultSetTableModelFactory.java:338)
    at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.parametrizeAndQuery(SimpleSQLReportDataFactory.java:426)
    at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:250)
    at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:95)
    at org.pentaho.reporting.ui.datasources.jdbc.ui.JdbcPreviewWorker.run(JdbcPreviewWorker.java:103)
    at java.lang.Thread.run(Unknown Source)
    ****************************************************************************************************************************

  2. #2
    Join Date
    Apr 2009
    Posts
    337

    Default

    did you have a look at this JIRA and the solution?

    http://jira.pentaho.com/browse/PDI-6709
    Regards,
    Madhu

  3. #3
    Join Date
    Jul 2012
    Posts
    3

    Default

    checked the link.i am using apache version of hadoop-hive.(not CDH3). also the report designer works well with 0.7 version of hive. so is it not working with 0.8 version due to jar files?

  4. #4
    Join Date
    Jul 2012
    Posts
    3

    Default

    download 3.9.0 version of report designer. test connection to hive-0.8.0 works fine and i am also able to successfully excute the queries/preview data. this version of report designer also has the same set up of jar files as that of 3.8.2 version.

    no idea as why 3.8.2 version does not work with hive-0.8.0. let me know if you know any.

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.