Hbase Phoenix Configuration

Hbase Configuration

All the configuration files are under folder /usr/local/Hbase/conf/.

**hbase-site.xml **

<property>

      <name>hbase.rootdir</name>

      <value>hdfs://localhost:9000/hbase</value>

   </property>

   <property>

      <name>hbase.cluster.distributed</name>

      <value>true</value>

   </property>

   <property>

      <name>hbase.zookeeper.quorum</name>

      <value>localhost</value>

   </property>

   <property>

      <name>dfs.replication</name>

      <value>1</value>

   </property>

   <property>

      <name>hbase.zookeeper.property.clientPort</name>

      <value>2181</value>

   </property>

   <property>

      <name>hbase.zookeeper.property.dataDir</name>

      <value>/home/hadoop/software/hbase-1.2.6.1/zookeeper</value>

   </property>

~/.Bashrc

export JAVA_HOME=/usr/local/jdk1.8.0_171

export PATH=$PATH:$JAVA_HOME/bin

export HADOOP_HOME=/home/hadoop/software/hadoop

export HADOOP_MAPRED_HOME=$HADOOP_HOME

export HADOOP_COMMON_HOME=$HADOOP_HOME

export HADOOP_HDFS_HOME=$HADOOP_HOME

export YARN_HOME=$HADOOP_HOME

export HADOOP_COMMON_LIB_NATIVE_DIR=$HADOOP_HOME/lib/native

export PATH=$PATH:$HADOOP_HOME/sbin:$HADOOP_HOME/bin

export HADOOP_INSTALL=$HADOOP_HOME

export HBASE_HOME=/home/hadoop/software/hbase-1.2.6.1

export PATH=$PATH:$HBASE_HOME/bin

export MAVEN_HOME=/home/hadoop/Downloads/apache-maven-3.5.4-bin/apache-maven-3.5.4

export PATH=$PATH:$MAVEN_HOME/bin

export PATH=$PATH:/home/hadoop/software/apache-phoenix-4.14.0-HBase-1.2-bin/bin

hbase-env.sh

UnComment these 2 lines

export JAVA_HOME=/usr/local/jdk1.8.0_171

export HBASE_REGIONSERVERS=${HBASE_HOME}/conf/regionservers

export HBASE_MANAGES_ZK=true

Comment these 2 lines

export HBASE_MASTER_OPTS="$HBASE_MASTER_OPTS -XX:PermSize=128m -XX:MaxPermSize=128m"

export HBASE_REGIONSERVER_OPTS="$HBASE_REGIONSERVER_OPTS -XX:PermSize=128m -XX:MaxPermSize=128m"

Cheacking  hbase version:

 Command  #    hbase version

Entering hbase shell.

 Command  #   hbase shell

Start Hbase

Command  #    start-hbase

Apache Phoenix

1.      Download Phoenix

Link: http://www.apache.org/dyn/closer.lua/phoenix/apache-phoenix-4.14.0-HBase-1.2/bin/apache-phoenix-4.14.0-HBase-1.2-bin.tar.gz

2.      Extract zip file

tar -xzf apache-phoenix-4.14.0-HBase-1.2-bin.tar.gz

3.      install python 2

4.      check version

#Command       python -V

5.      start query server

#Command Sqlline.py

6.      copy jar phoenix-4.14.0-HBase-1.2-server.jar

              

               From location: /Hbase/phoenix-4.14.0-HBase-1.2-server.jar

               Paste to Location: / hbase/lib/

7.      quit phoenix query server

#Command    !quit

Runnable JAR

#Command

java -cp shop.jar "com.shopper.dao.CreateDropTableOption2" -Xmx1024m

java -cp shop.jar "com.shopper.dao.CreateDropTableOption1"