Hello.
I finally managed to make a connection to hbase with knime.
However everytime that I try to run the Database Reader I get the following exception:
ERROR Database Reader Execute failed: java.sql.SQLException: java.util.concurrent.TimeoutException
On the log file:
2013-06-24 15:47:40,087 DEBUG pool-1-thread-2 DatabaseConnectionSettings : Opening database connection to "jdbc:hbql;maxtablerefs=10;hbase.master=hadoop-m-02.smm.lx.dri.pt"...
2013-06-24 15:48:02,954 DEBUG main NodeContainerEditPart : Database Reader 0:1 (EXECUTING)
2013-06-24 15:48:04,378 DEBUG main NodeContainerEditPart : Database Reader 0:1 (EXECUTING)
2013-06-24 15:48:41,087 DEBUG KNIME-Worker-1 Database Reader : reset
2013-06-24 15:48:41,087 DEBUG KNIME-Worker-1 Database Reader : clean output ports.
2013-06-24 15:48:41,087 ERROR KNIME-Worker-1 Database Reader : Execute failed: java.sql.SQLException: java.util.concurrent.TimeoutException
2013-06-24 15:48:41,088 DEBUG KNIME-Worker-1 Database Reader : Execute failed: java.sql.SQLException: java.util.concurrent.TimeoutException
java.sql.SQLException: java.sql.SQLException: java.util.concurrent.TimeoutException
at org.knime.core.node.port.database.DatabaseReaderConnection.initConnection(DatabaseReaderConnection.java:179)
at org.knime.core.node.port.database.DatabaseReaderConnection.createTable(DatabaseReaderConnection.java:257)
at org.knime.base.node.io.database.DBReaderNodeModel.execute(DBReaderNodeModel.java:110)
at org.knime.core.node.NodeModel.execute(NodeModel.java:680)
at org.knime.core.node.NodeModel.executeModel(NodeModel.java:536)
at org.knime.core.node.Node.invokeNodeModelExecute(Node.java:1000)
at org.knime.core.node.Node.execute(Node.java:894)
at org.knime.core.node.workflow.SingleNodeContainer.performExecuteNode(SingleNodeContainer.java:895)
at org.knime.core.node.exec.LocalNodeExecutionJob.mainExecute(LocalNodeExecutionJob.java:100)
at org.knime.core.node.workflow.NodeExecutionJob.run(NodeExecutionJob.java:166)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at org.knime.core.util.ThreadPool$MyFuture.run(ThreadPool.java:124)
at org.knime.core.util.ThreadPool$Worker.run(ThreadPool.java:239)
Caused by: java.sql.SQLException: java.util.concurrent.TimeoutException
at org.knime.core.node.port.database.DatabaseConnectionSettings.createConnection(DatabaseConnectionSettings.java:407)
at org.knime.core.node.port.database.DatabaseReaderConnection.initConnection(DatabaseReaderConnection.java:177)
... 14 more
Caused by: java.util.concurrent.TimeoutException
at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:258)
at java.util.concurrent.FutureTask.get(FutureTask.java:119)
at org.knime.core.node.port.database.DatabaseConnectionSettings.createConnection(DatabaseConnectionSettings.java:401)
... 15 more
Can anyone help me with this issue? I already manage to increase the database timeout but I'm getting the same problem.
Thanks in advance.
Joana Dias