HBase fully distributed installation and installation of hive remote mode (MySQL as a database)

You guys are really embarrassed. The last blog post was wrong. The last time should be a pseudo-distributed installation of HBase. This time I guarantee a fully distributed installation.

The first is the completion of the distributed installation of HBase. the environment for this deployment is hadoop-1.2.1+hbase-0.98.x. Because this version of HBase is directly corresponding to the hadoop-1.2.1, it eliminates the steps to overwrite the jar package and eliminates the instability caused by the overlay. OK, unzip after download, enter CONF directory, configure hbase-env.sh file. Here Hbase_classpath is pointing to the Conf directory of Hadoop, which needs attention.

Here is the open zookeeper.

The next step is to configure Hbase-site.xml. The HBase directory in the HDFs file system here needs to be new. Then the last two attributes are several nodes that specify zookeeper and the directory where the data is stored.

Finally, configure Regionserver. Hmaster is H2,regionserver is h3,h4.

Start HBase. Before that, you need to make sure that Hadoop is up!

Next is to close hbase.

The following is a remote mode installation of hive (MySQL as a metabase). The setting here is hadoop-1.2.1+hive-0.12.0.

The first is to download the hive decompression and enter the Conf directory. Copy the hive-env.sh.template into hive-env.sh. Then configure the following options.

The first one is HADOOP_HOME=/HOME/LEUNG/HADOOP1 (this is based on the directory where you installed Hadoop); the second is hive_conf_dir=/home/leung/hive/. Conf (this is determined based on your hive directory location). The following is a copy of Hive-default.xml into Hive-site.xml. Then configure several properties: The first is to change the Metastore.local property to False.

The first is to specify the MySQL location, then the native thrift, and finally the JDBC driver name.

Specify the user name and password to connect to MySQL. This user must first new in MySQL and give certain permissions!

Finally, set this property to False. It is also important to note that this file is about 2000 lines or so there is a mistake, is to write </value> written </auth>. Everybody installs the time to play the small universe, look for.

Ok. The configuration is ready to start. First, start the metabase: Hive--service Metastore &, then start Hiveserver:hive--service Hiveserver &. After that, you can start hive normally.

At the same time, let's go to another node and see what happens to the database.

You can see that there are so many more tables in the original empty hive database. These are created after Hive is started, and we query the TBLs table to see the information for new table A in hive.

At this point, hbase and hive are installed successfully!

Thank you! My level is limited, please do not hesitate to correct me!

HBase fully distributed installation and installation of hive remote mode (MySQL as a database)