Accessing HBase databases

1. Find the following jars in HBase and Hadoop installation directories and put them in esProc external library folder. Get the appropriate jars according to the HBase and Hadoop versions you are using. The directory containing files of this external library is: installation directory\esProc\extlib\HbaseCli. The Raqsoft core jar for this external library is HbaseCli.jar.

commons-codec-1.9.jar

commons-collections-3.2.2.jar

commons-configuration-1.6.jar

commons-lang-2.6.jar

guava-12.0.1.jar

hadoop-auth-2.5.1.jar

hadoop-common-2.5.1.jar

hadoop-hdfs-2.5.1.jar

hbase-client-1.3.0.jar

hbase-common-1.3.0.jar

hbase-hadoop2-compat-1.3.0.jar

hbase-protocol-1.3.0.jar

htrace-core-3.0.4.jar

htrace-core-3.1.0-incubating.jar

log4j-1.2.17.jar

metrics-core-2.2.0.jar

netty-all-4.0.23.Final.jar

protobuf-java-2.5.0.jar

slf4j-api-1.7.7.jar

slf4j-log4j12-1.7.5.jar

zookeeper-3.4.6.jar

Note: The third-party jars are provided within the package and users can choose appropriate ones for specific scenarios.

 

2. Download the following four files from the web and place them in installation directory\bin:

hadoop.dll

hadoop.lib

libwinutils.lib

winutils.exe

Note: The above files are required under Windows environment, but not under Linux. There are x86 winutils.exe and x64 winutils.exe depending on different OS versions.

 

3. HbaseCli requires a JRE version 1.7 or above. The embedded JRE version in esProc is JRE1.6. Users need to install a higher version and configure java_home in the config.txt under installation directory\esProc\bin. If a JDK version 1.7 or above has been chosen when installing esProc, just ignore this step.

 

4. Users can manually change the size of memory if the default size isn’t large enough for needs. Two ways to manage memory under Windows are available: Change the memory settings in config.txt when starting esProc through the executable file; and in the .bat file when starting the application through the batch file. Under Linux, change the memory size in the .sh file.

Below is the method of changing memory settings in config.txt under Windows:

java_home=C:\ProgramFiles\Java\JDK1.7.0_11;esproc_port=48773;jvm_args=-Xms256m -XX:PermSize=256M -XX:MaxPermSize=512M -Xmx9783m -Duser.language=zh

 

5. On the machine where esProc is installed, find the hosts file to add the IP address and hostname of the machine holding the HBase database. For example, if the IP address and hostname are 192.168.0.8 and masters respectively, here are the settings:

 

6. esProc provides a number of external library functions, including hbase_open(), hbase_filter(), hbase_filterlist(), hbase_get(), hbase_scan(), hbase_cmp() and hbase_close(), to access HBase databases. Look up them in【Help】-【Function reference】to find the uses.