Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Connection errors and pentaho Hive

  1. #1
    Join Date
    Nov 2012
    Posts
    3

    Default Connection errors and pentaho Hive

    Hi,

    Pentaho BI Server 4.5.0-stable
    hive-server-0.8.1+61-1.cdh4.0.1.p0.1.el5
    Error is occurs in a connection of pentaho and hive.
    After operating it by the following order, an error occurs in Analysis vieew
    While reading the data, MapReduce is operating normally, the following error occurs during the reporting
    FAILED: Parse Error: line 1:18 mismatched input ''severrity'' expecting Identifier near '.' in expression specification

    Operating procedure
    ====================================================================
    Create New > Source Type:SQL Query > Finish
    +Connection
    Custom connection URL:"jdbc:hive://192.168.*.*:10000"
     Custom Driver Class Name:"org.apache.hadoop.hive.jdbc.HiveDriver"
     User Name,Password:"Blank"
    +SQL Query:"select * from deta"
    ====================================================================
    Analysis vieew Error messages
    ====================================================================


    Error Occurred While getting Resultset
    An error occurred while rendering Pivot.jsp. Please see the log for details.

    ====================================================================
    While reading the data, MapReduce is operating normally,
    the following error occurs during the reporting
    Hive-server Error messages
    ====================================================================

    FAILED: Parse Error: line 1:18 mismatched input ''severrity'' expecting Identifier near '.' in expression specification
    ====================================================================
    In addition, an error occurs in the following steps:
    Operating procedure
    ====================================================================
    Create New > Source Typeatabase Table(s) > Next > Available TablesSelect multiple tables) > Next
    +Connection
    Custom connection URL:"jdbc:hive://192.168.0.101:10000"
     Custom Driver Class Name:"org.apache.hadoop.hive.jdbc.HiveDriver"
     User Name,Password:"Blank"
    ====================================================================
    Hive-server Error messages
    ====================================================================
    FAILED: Parse Error: line 1:14 cannot recognize input near '"default"' '.' '"deta"' in join source
    ====================================================================

    Because it is possible until the reading of the table, it is thought that the
    setting of the JDBC does not have any problem.

    Best Regards.

    yama****a

  2. #2
    Join Date
    Nov 2012
    Posts
    3

    Default

    Hi,

    When read a table of Hive, i discover the following errors in pentaho.

    ====================================================================
    19:22:52,241 ERROR [MultitableDatasourceService] org.pentaho.di.core.exception.KettleDatabaseException:
    An error occurred executing SQL:
    SELECT * FROM "default"."aaa"
    Query returned non-zero code: 11, cause: FAILED: Parse Error: line 1:14 cannot recognize input near '"default"' '.' '"aaa"' in join source

    19:22:52,246 ERROR [MultitableDatasourceService] org.pentaho.di.core.exception.KettleDatabaseException:
    An error occurred executing SQL:
    SELECT * FROM "default"."aaa"
    Query returned non-zero code: 11, cause: FAILED: Parse Error: line 1:14 cannot recognize input near '"default"' '.' '"aaa"' in join source
    ====================================================================

    The SELECT sentence of Hive cannot use ""(Double-quotes).
    I think that a table cannot be read.
    Is not it a bug of pentaho?

    yama****a

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.