org.pentaho.di.core.exception.KettleDatabaseException: Error cancelling statement Method not supported

Pentaho BI Platform Tracking | Jasper Knulst | 4 years ago
  1. 0

    Hi, I noticed that I am not the only one that ran into trouble while truying to connect to a Hive instance via JDBC in PDI 4.4. I have tried multiple setups but just can't get it to work. I am on PDI 4.4 & CDH3u4 with the standard Cloudera Hive (0.7.1-chd3u4) Hive thrift server running on the cluster side... When I use the standard jdbc jar "hive-jdbc-0.7.0-pentaho-1.0.2.jar" from /plugins/pentaho-big-data-plugin/hadoop-configurations/cdh3u4/lib I get this error message while testing the connection: ############################ Error connecting to database [Hive cHadoop1] : org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Error connecting to database: (using class org.apache.hadoop.hive.jdbc.HiveDriver) Error communicating with Hive org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database ############################# When I tried to use the "hive-jdbc-0.7.0-pentaho-1.0.2.jar" on both end it makes no difference; still this error. So I tried replacing the "hive-jdbc-0.7.0-pentaho-1.0.2.jar" (on the Pentaho side) with a copy of the "hive-jdbc-0.7.1-cdh3u4.jar" from the cluster Now I can connect to Hive and browse tables but when I try to access table contents I get the "Method not supported" error message with this stacktrace: This time I can tell from the Hive logs that the Hive statements is executed; a MR job is being triggered. But when the time comes to stream the results back to Pentaho I get this: (Looks like PDI cannot handle the row results from the Hive query) ##################################### 2012/11/21 12:50:10 - Hive cHadoop1 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : ERROR executing query: org.pentaho.di.core.exception.KettleDatabaseException: 2012/11/21 12:50:10 - Hive cHadoop1 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Error getting row information from database: 2012/11/21 12:50:10 - Hive cHadoop1 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Method not supported 2012/11/21 12:50:10 - Hive cHadoop1 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : ERROR in part: openQuery : get rowinfo 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Unexpected error 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : An error occurred executing SQL in part [openQuery : get rowinfo]: 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : SELECT * FROM gsa_log limit 10 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Error getting row information from database: 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Method not supported 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.core.database.Database.openQuery(Database.java:1863) 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:233) 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:143) 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50) 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at java.lang.Thread.run(Thread.java:662) 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Error getting row information from database: 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Method not supported 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.core.database.Database.getRowInfo(Database.java:2396) 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.core.database.Database.openQuery(Database.java:1850) 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : ... 4 more 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Caused by: java.sql.SQLException: Method not supported 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.apache.hadoop.hive.jdbc.HiveResultSetMetaData.isSigned(HiveResultSetMetaData.java:177) 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.core.database.Database.getValueFromSQLType(Database.java:2408) 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.core.database.Database.getRowInfo(Database.java:2389) 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : ... 5 more 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Something went wrong while trying to stop the transformation: org.pentaho.di.core.exception.KettleDatabaseException: 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Error cancelling statement 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Method not supported 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Error cancelling statement 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Method not supported 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.core.database.Database.cancelStatement(Database.java:635) 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.core.database.Database.cancelQuery(Database.java:615) 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.trans.steps.tableinput.TableInput.stopRunning(TableInput.java:303) 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.trans.Trans.stopAll(Trans.java:1563) 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.trans.step.BaseStep.stopAll(BaseStep.java:2525) 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:74) 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at java.lang.Thread.run(Thread.java:662) 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Caused by: java.sql.SQLException: Method not supported 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.apache.hadoop.hive.jdbc.HiveStatement.cancel(HiveStatement.java:90) 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.core.database.Database.cancelStatement(Database.java:629) 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : ... 6 more 2012/11/21 12:50:10 - Table input.0 - Finished reading query, closing connection. ######################################

    Pentaho BI Platform Tracking | 4 years ago | Jasper Knulst
    org.pentaho.di.core.exception.KettleDatabaseException: Error cancelling statement Method not supported
  2. 0

    Hi, I noticed that I am not the only one that ran into trouble while truying to connect to a Hive instance via JDBC in PDI 4.4. I have tried multiple setups but just can't get it to work. I am on PDI 4.4 & CDH3u4 with the standard Cloudera Hive (0.7.1-chd3u4) Hive thrift server running on the cluster side... When I use the standard jdbc jar "hive-jdbc-0.7.0-pentaho-1.0.2.jar" from /plugins/pentaho-big-data-plugin/hadoop-configurations/cdh3u4/lib I get this error message while testing the connection: ############################ Error connecting to database [Hive cHadoop1] : org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Error connecting to database: (using class org.apache.hadoop.hive.jdbc.HiveDriver) Error communicating with Hive org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database ############################# When I tried to use the "hive-jdbc-0.7.0-pentaho-1.0.2.jar" on both end it makes no difference; still this error. So I tried replacing the "hive-jdbc-0.7.0-pentaho-1.0.2.jar" (on the Pentaho side) with a copy of the "hive-jdbc-0.7.1-cdh3u4.jar" from the cluster Now I can connect to Hive and browse tables but when I try to access table contents I get the "Method not supported" error message with this stacktrace: This time I can tell from the Hive logs that the Hive statements is executed; a MR job is being triggered. But when the time comes to stream the results back to Pentaho I get this: (Looks like PDI cannot handle the row results from the Hive query) ##################################### 2012/11/21 12:50:10 - Hive cHadoop1 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : ERROR executing query: org.pentaho.di.core.exception.KettleDatabaseException: 2012/11/21 12:50:10 - Hive cHadoop1 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Error getting row information from database: 2012/11/21 12:50:10 - Hive cHadoop1 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Method not supported 2012/11/21 12:50:10 - Hive cHadoop1 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : ERROR in part: openQuery : get rowinfo 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Unexpected error 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : An error occurred executing SQL in part [openQuery : get rowinfo]: 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : SELECT * FROM gsa_log limit 10 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Error getting row information from database: 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Method not supported 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.core.database.Database.openQuery(Database.java:1863) 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:233) 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:143) 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50) 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at java.lang.Thread.run(Thread.java:662) 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Error getting row information from database: 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Method not supported 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.core.database.Database.getRowInfo(Database.java:2396) 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.core.database.Database.openQuery(Database.java:1850) 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : ... 4 more 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Caused by: java.sql.SQLException: Method not supported 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.apache.hadoop.hive.jdbc.HiveResultSetMetaData.isSigned(HiveResultSetMetaData.java:177) 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.core.database.Database.getValueFromSQLType(Database.java:2408) 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.core.database.Database.getRowInfo(Database.java:2389) 2012/11/21 12:50:10 - Table input.0 - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : ... 5 more 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Something went wrong while trying to stop the transformation: org.pentaho.di.core.exception.KettleDatabaseException: 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Error cancelling statement 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Method not supported 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Error cancelling statement 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Method not supported 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.core.database.Database.cancelStatement(Database.java:635) 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.core.database.Database.cancelQuery(Database.java:615) 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.trans.steps.tableinput.TableInput.stopRunning(TableInput.java:303) 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.trans.Trans.stopAll(Trans.java:1563) 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.trans.step.BaseStep.stopAll(BaseStep.java:2525) 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:74) 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at java.lang.Thread.run(Thread.java:662) 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Caused by: java.sql.SQLException: Method not supported 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.apache.hadoop.hive.jdbc.HiveStatement.cancel(HiveStatement.java:90) 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : at org.pentaho.di.core.database.Database.cancelStatement(Database.java:629) 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : ... 6 more 2012/11/21 12:50:10 - Table input.0 - Finished reading query, closing connection. ######################################

    Pentaho BI Platform Tracking | 4 years ago | Jasper Knulst
    org.pentaho.di.core.exception.KettleDatabaseException: Error cancelling statement Method not supported
  3. 0

    "java.sql.SQLException: Method not supported" when retrieving data from hive table.

    pentaho.com | 2 months ago
    org.pentaho.di.core.exception.KettleDatabaseException: Error cancelling statement Method not supported
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    When trying to use Instaview with our Hadoop distro @ 10.100.9.42 and table fact_sales_1998, I get the following exception while executing the MonetDB population transformation. It seems that the populator tries to stop transformation after 100k rows. This can also be reproduced by firing up the attached transformation with its table input step and hitting stop after the rows have started to flow. ----------------------------------------------------------------- 2013/09/24 13:15:19 - Spoon - Transformation opened. 2013/09/24 13:15:19 - Spoon - Launching transformation [Untitled 2]... 2013/09/24 13:15:19 - Spoon - Started the transformation execution. 2013/09/24 13:15:20 - Untitled 2 - Dispatching started for transformation [Untitled 2] 2013/09/24 13:16:12 - Input.0 - linenr 50000 2013/09/24 13:16:12 - Do Not Edit.0 - linenr 50000 2013/09/24 13:16:40 - Input.0 - linenr 100000 2013/09/24 13:16:41 - Do Not Edit.0 - linenr 100000 2013/09/24 13:16:41 - Untitled 2 - ERROR (version 5.0.0.1, build 1 from 2013-09-11_16-51-19 by buildguy) : Something went wrong while trying to stop the transformation: org.pentaho.di.core.exception.KettleDatabaseException: 2013/09/24 13:16:41 - Untitled 2 - Error cancelling statement 2013/09/24 13:16:41 - Untitled 2 - Method not supported 2013/09/24 13:16:41 - Untitled 2 - ERROR (version 5.0.0.1, build 1 from 2013-09-11_16-51-19 by buildguy) : Something went wrong while trying to stop the transformation: org.pentaho.di.core.exception.KettleDatabaseException: 2013/09/24 13:16:41 - Untitled 2 - Error cancelling statement 2013/09/24 13:16:41 - Untitled 2 - Method not supported 2013/09/24 13:16:41 - Untitled 2 - ERROR (version 5.0.0.1, build 1 from 2013-09-11_16-51-19 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2013/09/24 13:16:41 - Untitled 2 - Error cancelling statement 2013/09/24 13:16:41 - Untitled 2 - Method not supported 2013/09/24 13:16:41 - Untitled 2 - 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.core.database.Database.cancelStatement(Database.java:664) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.core.database.Database.cancelQuery(Database.java:646) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.steps.tableinput.TableInput.stopRunning(TableInput.java:303) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.Trans.stopAll(Trans.java:1729) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.step.BaseStep.stopAll(BaseStep.java:2605) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.step.BaseStep.putRow(BaseStep.java:1093) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:204) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60) 2013/09/24 13:16:41 - Untitled 2 - at java.lang.Thread.run(Thread.java:724) 2013/09/24 13:16:41 - Untitled 2 - Caused by: java.sql.SQLException: Method not supported 2013/09/24 13:16:41 - Untitled 2 - at org.apache.hadoop.hive.jdbc.HiveStatement.cancel(HiveStatement.java:85) 2013/09/24 13:16:41 - Untitled 2 - at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2013/09/24 13:16:41 - Untitled 2 - at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 2013/09/24 13:16:41 - Untitled 2 - at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 2013/09/24 13:16:41 - Untitled 2 - at java.lang.reflect.Method.invoke(Method.java:606) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.hadoop.shim.common.DriverProxyInvocationChain$CaptureResultSetInvocationHandler.invoke(DriverProxyInvocationChain.java:461) 2013/09/24 13:16:41 - Untitled 2 - at com.sun.proxy.$Proxy138.cancel(Unknown Source) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.core.database.Database.cancelStatement(Database.java:659) 2013/09/24 13:16:41 - Untitled 2 - ... 8 more 2013/09/24 13:16:41 - Input.0 - Finished reading query, closing connection. 2013/09/24 13:16:41 - Do Not Edit.0 - Finished processing (I=0, O=0, R=100107, W=100107, U=0, E=0) 2013/09/24 13:16:41 - Untitled 2 - ERROR (version 5.0.0.1, build 1 from 2013-09-11_16-51-19 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2013/09/24 13:16:41 - Untitled 2 - Error cancelling statement 2013/09/24 13:16:41 - Untitled 2 - Method not supported 2013/09/24 13:16:41 - Untitled 2 - 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.core.database.Database.cancelStatement(Database.java:664) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.core.database.Database.cancelQuery(Database.java:646) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.steps.tableinput.TableInput.stopRunning(TableInput.java:303) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.Trans.stopAll(Trans.java:1729) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.step.BaseStep.stopAll(BaseStep.java:2605) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.steps.monetdbbulkloader.MonetDBBulkLoader.processRow(MonetDBBulkLoader.java:216) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60) 2013/09/24 13:16:41 - Untitled 2 - at java.lang.Thread.run(Thread.java:724) 2013/09/24 13:16:41 - Untitled 2 - Caused by: java.sql.SQLException: Method not supported 2013/09/24 13:16:41 - Untitled 2 - at org.apache.hadoop.hive.jdbc.HiveStatement.cancel(HiveStatement.java:85) 2013/09/24 13:16:41 - Untitled 2 - at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2013/09/24 13:16:41 - Untitled 2 - at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 2013/09/24 13:16:41 - Untitled 2 - at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 2013/09/24 13:16:41 - Untitled 2 - at java.lang.reflect.Method.invoke(Method.java:606) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.hadoop.shim.common.DriverProxyInvocationChain$CaptureResultSetInvocationHandler.invoke(DriverProxyInvocationChain.java:461) 2013/09/24 13:16:41 - Untitled 2 - at com.sun.proxy.$Proxy138.cancel(Unknown Source) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.core.database.Database.cancelStatement(Database.java:659) 2013/09/24 13:16:41 - Untitled 2 - ... 7 more 2013/09/24 13:16:41 - Output.0 - Finished processing (I=0, O=100000, R=100001, W=100000, U=0, E=0) 2013/09/24 13:16:41 - Input.0 - Finished processing (I=100208, O=0, R=0, W=100206, U=0, E=0) 2013/09/24 13:16:41 - Spoon - The transformation has finished!!

    Pentaho BI Platform Tracking | 3 years ago | Curtis Boyden
    org.pentaho.di.core.exception.KettleDatabaseException: Error cancelling statement Method not supported
  6. 0

    When trying to use Instaview with our Hadoop distro @ 10.100.9.42 and table fact_sales_1998, I get the following exception while executing the MonetDB population transformation. It seems that the populator tries to stop transformation after 100k rows. This can also be reproduced by firing up the attached transformation with its table input step and hitting stop after the rows have started to flow. ----------------------------------------------------------------- 2013/09/24 13:15:19 - Spoon - Transformation opened. 2013/09/24 13:15:19 - Spoon - Launching transformation [Untitled 2]... 2013/09/24 13:15:19 - Spoon - Started the transformation execution. 2013/09/24 13:15:20 - Untitled 2 - Dispatching started for transformation [Untitled 2] 2013/09/24 13:16:12 - Input.0 - linenr 50000 2013/09/24 13:16:12 - Do Not Edit.0 - linenr 50000 2013/09/24 13:16:40 - Input.0 - linenr 100000 2013/09/24 13:16:41 - Do Not Edit.0 - linenr 100000 2013/09/24 13:16:41 - Untitled 2 - ERROR (version 5.0.0.1, build 1 from 2013-09-11_16-51-19 by buildguy) : Something went wrong while trying to stop the transformation: org.pentaho.di.core.exception.KettleDatabaseException: 2013/09/24 13:16:41 - Untitled 2 - Error cancelling statement 2013/09/24 13:16:41 - Untitled 2 - Method not supported 2013/09/24 13:16:41 - Untitled 2 - ERROR (version 5.0.0.1, build 1 from 2013-09-11_16-51-19 by buildguy) : Something went wrong while trying to stop the transformation: org.pentaho.di.core.exception.KettleDatabaseException: 2013/09/24 13:16:41 - Untitled 2 - Error cancelling statement 2013/09/24 13:16:41 - Untitled 2 - Method not supported 2013/09/24 13:16:41 - Untitled 2 - ERROR (version 5.0.0.1, build 1 from 2013-09-11_16-51-19 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2013/09/24 13:16:41 - Untitled 2 - Error cancelling statement 2013/09/24 13:16:41 - Untitled 2 - Method not supported 2013/09/24 13:16:41 - Untitled 2 - 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.core.database.Database.cancelStatement(Database.java:664) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.core.database.Database.cancelQuery(Database.java:646) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.steps.tableinput.TableInput.stopRunning(TableInput.java:303) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.Trans.stopAll(Trans.java:1729) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.step.BaseStep.stopAll(BaseStep.java:2605) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.step.BaseStep.putRow(BaseStep.java:1093) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:204) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60) 2013/09/24 13:16:41 - Untitled 2 - at java.lang.Thread.run(Thread.java:724) 2013/09/24 13:16:41 - Untitled 2 - Caused by: java.sql.SQLException: Method not supported 2013/09/24 13:16:41 - Untitled 2 - at org.apache.hadoop.hive.jdbc.HiveStatement.cancel(HiveStatement.java:85) 2013/09/24 13:16:41 - Untitled 2 - at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2013/09/24 13:16:41 - Untitled 2 - at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 2013/09/24 13:16:41 - Untitled 2 - at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 2013/09/24 13:16:41 - Untitled 2 - at java.lang.reflect.Method.invoke(Method.java:606) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.hadoop.shim.common.DriverProxyInvocationChain$CaptureResultSetInvocationHandler.invoke(DriverProxyInvocationChain.java:461) 2013/09/24 13:16:41 - Untitled 2 - at com.sun.proxy.$Proxy138.cancel(Unknown Source) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.core.database.Database.cancelStatement(Database.java:659) 2013/09/24 13:16:41 - Untitled 2 - ... 8 more 2013/09/24 13:16:41 - Input.0 - Finished reading query, closing connection. 2013/09/24 13:16:41 - Do Not Edit.0 - Finished processing (I=0, O=0, R=100107, W=100107, U=0, E=0) 2013/09/24 13:16:41 - Untitled 2 - ERROR (version 5.0.0.1, build 1 from 2013-09-11_16-51-19 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2013/09/24 13:16:41 - Untitled 2 - Error cancelling statement 2013/09/24 13:16:41 - Untitled 2 - Method not supported 2013/09/24 13:16:41 - Untitled 2 - 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.core.database.Database.cancelStatement(Database.java:664) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.core.database.Database.cancelQuery(Database.java:646) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.steps.tableinput.TableInput.stopRunning(TableInput.java:303) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.Trans.stopAll(Trans.java:1729) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.step.BaseStep.stopAll(BaseStep.java:2605) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.steps.monetdbbulkloader.MonetDBBulkLoader.processRow(MonetDBBulkLoader.java:216) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60) 2013/09/24 13:16:41 - Untitled 2 - at java.lang.Thread.run(Thread.java:724) 2013/09/24 13:16:41 - Untitled 2 - Caused by: java.sql.SQLException: Method not supported 2013/09/24 13:16:41 - Untitled 2 - at org.apache.hadoop.hive.jdbc.HiveStatement.cancel(HiveStatement.java:85) 2013/09/24 13:16:41 - Untitled 2 - at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2013/09/24 13:16:41 - Untitled 2 - at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 2013/09/24 13:16:41 - Untitled 2 - at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 2013/09/24 13:16:41 - Untitled 2 - at java.lang.reflect.Method.invoke(Method.java:606) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.hadoop.shim.common.DriverProxyInvocationChain$CaptureResultSetInvocationHandler.invoke(DriverProxyInvocationChain.java:461) 2013/09/24 13:16:41 - Untitled 2 - at com.sun.proxy.$Proxy138.cancel(Unknown Source) 2013/09/24 13:16:41 - Untitled 2 - at org.pentaho.di.core.database.Database.cancelStatement(Database.java:659) 2013/09/24 13:16:41 - Untitled 2 - ... 7 more 2013/09/24 13:16:41 - Output.0 - Finished processing (I=0, O=100000, R=100001, W=100000, U=0, E=0) 2013/09/24 13:16:41 - Input.0 - Finished processing (I=100208, O=0, R=0, W=100206, U=0, E=0) 2013/09/24 13:16:41 - Spoon - The transformation has finished!!

    Pentaho BI Platform Tracking | 3 years ago | Curtis Boyden
    org.pentaho.di.core.exception.KettleDatabaseException: Error cancelling statement Method not supported

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Method not supported

      at org.apache.hadoop.hive.jdbc.HiveStatement.cancel()
    2. org.apache.hadoop
      HiveStatement.cancel
      1. org.apache.hadoop.hive.jdbc.HiveStatement.cancel(HiveStatement.java:90)
      1 frame
    3. org.pentaho.di
      RunThread.run
      1. org.pentaho.di.core.database.Database.cancelStatement(Database.java:629)
      2. org.pentaho.di.core.database.Database.cancelQuery(Database.java:615)
      3. org.pentaho.di.trans.steps.tableinput.TableInput.stopRunning(TableInput.java:303)
      4. org.pentaho.di.trans.Trans.stopAll(Trans.java:1563)
      5. org.pentaho.di.trans.step.BaseStep.stopAll(BaseStep.java:2525)
      6. org.pentaho.di.trans.step.RunThread.run(RunThread.java:74)
      6 frames
    4. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:662)
      1 frame