PDA

View Full Version : Connection error of Hive and pentaho



oss
11-19-2012, 12:26 PM
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 (http://forums.pentaho.com/"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 Type:Database Table(s) > Next > Available Tables:(Select multiple tables) > Next
+Connection
Custom connection URL:"jdbc:hive://192.168.0.101:10000 (http://forums.pentaho.com/"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