PDA

View Full Version : Connection errors and pentaho Hive



oss
11-19-2012, 12:35 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

oss
11-21-2012, 11:07 AM
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