Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to connect kettle spoon to hbase, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

Download and install spoon address: http://www.pentaho.com/download

Select Download Windows. Only the windows version is spoon. You can download and decompress it and use it without installation.

Spoon is written in pure java, so you must install the jdk package of java before using it.

Download address: http://www.oracle.com/technetwork/java/javase/downloads/index.html

The connection to HBase needs to be configured (the actual connection to HBase is through the zookeeper service)

Go to the spoon directory and open the plugins\ pentaho-big-data-plugin\ plugin.properties file

Modify the active.hadoop.configuration configuration item (configuration driver set directory name), which is empty by default. It has been modified at present.

Enter the directory plugins\ pentaho-big-data-plugin\ hadoop-configurations to view the directory of the currently available driver sets

The four directories in it are all hadoop-configurations driver sets. Zookeeper-*.jar files are required to link HBase.

For example, under the cdh62 directory lib:

Then the cdh62 driver set can be used.

When HBase starts, it binds the hostname value of the server, so you need to bind the same host in the spoon machine or you can't connect.

Enter the command on the HBase machine:

Hostname

Such as:

Root@ubuntu:~# hostnameubuntu

Then modify the hosts on the spoon machine

Open the C:\ Windows\ System32\ drivers\ etc\ hosts file

For example, the IP of the HBase server is 192.168.0.10

Add a new line to the hosts file and save it.

192.168.0.10 ubuntu

Open spoon, enter the spoon decompression directory and double-click the Spoon.bat file

Note: in fact, it can also be run under linux (not for remote connection). Just open the spoon.sh script.

Create a new transformation and click Big Data > HBase Input

Double-click the HBase Input icon > Click the New pop-up edit Hadoop cluster window

Modify the Cluster Name value (that is, the HBase connection alias), and change the server where ZooKeeper, such as HBase, is located. The IP is 192.168.0.10. The default HBase port number is 2182.

OK, and then select hbase-test in Hadoop Cluster

Enter the Create/Edit mappings selection card and follow these steps

Then return to the Configure query tab and follow the steps

Then right-click HBase Input > Select Preview > Quick launch

You can view the data.

Thank you for reading this article carefully. I hope the article "how to connect kettle spoon to hbase" shared by the editor will be helpful to everyone. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.