如何检查cassandra与pentaho数据集成器的连接 [英] How to check connection of cassandra with pentaho data integrator

问题描述

我正在尝试通过使用Pentaho数据集成5.1（社区版）从Oracle表加载数据到Cassandra表。但我没有得到是否已经建立了oracle和cassandra之间的连接。我使用Cassandra 2.2.3和Oracle 11gR2。
我在数据集成的lib文件夹中添加了以下jars
--cassandra-thrift-1.0.0
--apache-cassandra-cql-1.0.0
- -libthrift-0.6.jar
--guava-r08.jar
--cassandra_driver.jar
任何人都可以帮我找出如何检查Pentaho是否建立连接。 / p>

解决方案

有一些方法来调试是否建立了与数据库的连接，我不知道是否所有的都是有效的

1）测试按钮 p>

只需在连接编辑屏幕上点击测试按钮。

2）具有高细节的日志可能有助于

另一种测试方式是使用

4）受控输出测试

或者你可以尝试一个更简单的转换，以确保它运行正常。例如。

I'm trying to load data from Oracle table to Cassandra table by using Pentaho Data Integration 5.1(Community Edition). But I'm not getting whether connection has been established between oracle and cassandra. I'm using Cassandra 2.2.3 and Oracle 11gR2. I've added following jars in lib folder of data-integration --cassandra-thrift-1.0.0 --apache-cassandra-cql-1.0.0 --libthrift-0.6.jar --guava-r08.jar --cassandra_driver.jar Please anyone can help me to figure out how to check whether connection has been established in Pentaho.

解决方案

There are some ways to debug if a connection is established to a database, I don't know if all of them are valid for cassandra, but I'll add a especial one for that.

1) The test button

By simply clicking the test button on the connection edit screen.

2) Logs with high details may help

Another way to test is running you transformation with a high detail log:

sh pan.sh -file=my_cassandra_transformation.ktr -level=Rowlevel

3) The input preview

For cassandra, in especific, I would try just to create a simple read operation using Cassandra Input step and clicking in the 'preview' button.

4) The controlled output test

Or maybe you can try with a simplier transformation first, to make sure it's running fine. Eg.

这篇关于如何检查cassandra与pentaho数据集成器的连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！