分布式数据库Hypertable 0.9.7.6发布

jieforest

STEP 10 - START HYPERTABLETOP

The following commands should be run from the directory containing the Capfile. To start all of the Hypertable servers:

1. $ cap start

复制代码

If you want to launch the service using a different config file than the default (e.g. /home/chris/alternate.cfg):

1. $ cap -S config=/home/chris/alternate.cfg start

复制代码

You'll need to specify the same config file when running Hypertable commands such as the command shell, for example:

1. $ /opt/hypertable/current/bin/ht shell --config=/home/chris/alternate.cfg

复制代码

jieforest

STEP 11 - VERIFY INSTALLATIONTOP

Create a table.

1. echo "USE '/'; CREATE TABLE foo ( c1, c2 ); GET LISTING;" \
   
2.     | /opt/hypertable/current/bin/ht shell --batch

复制代码

The output of this command should look like:

1. foo
   
2. sys (namespace)

复制代码

jieforest

Load some data.

1. echo "USE '/'; INSERT INTO foo VALUES('001', 'c1', 'very'), \
   
2.     ('000', 'c1', 'Hypertable'), ('001', 'c2', 'easy'), ('000', 'c2', 'is');" \
   
3.     | /opt/hypertable/current/bin/ht shell --batch

复制代码

Dump the table.

1. echo "USE '/'; SELECT * FROM foo;" \
   
2.     | /opt/hypertable/current/bin/ht shell --batch

复制代码

The output of this command should look like:

1. 000        c1        Hypertable
   
2. 000        c2        is
   
3. 001        c1        very
   
4. 001        c2        easy

复制代码

jieforest

STEP 12 - STOP HYPERTABLETOP

To stop the service, shutting down all servers:

1. $ cap stop

复制代码

If you want to wipe your database clean, removing all namespaces and tables:

1. $ cap cleandb

复制代码

jieforest

WHAT NEXT?TOP

Congratulations!  Now that you have successfully installed Hypertable, we recommend that you walk through the HQL Tutorial to get familiar with using the system.

jieforest

HOW TO CHANGE HADOOP DISTROTOP

Hypertable can run on most modern distributions of Hadoop.  The Hypertable packages currently have built-in support for the Cloudera distribtion (we will be adding support for the Hortonworks distribution soon).  CDH3 is the distribution that is configured by default.  To switch to the CDH4 distribution, edit the default_distro variable at the top of your Capfile:

1. set :default_distro, "cdh4"

复制代码

and then run the following command:

1. cap set_distro

复制代码

jieforest

Other (non-Cloudera) distributions

If you would like to run Hypertable on top of a distribution other than Cloudera, you'll need to deposit the distribution jar files in the lib/java directory (e.g. /opt/hypertable/current/lib/java).  You'll also need to copy the corresponding Hypertable jar files into that directory as well.  For Hadoop 1 distributions, use the hypertable jar files located in lib/java/cd3 directory (e.g. /opt/hypertable/current/lib/java/cdh3), for Hadoop 2 distributions, use the Hypertable jar files located in the lib/java/cd4 directory (e.g. /opt/hypertable/current/lib/java/cdh4). Be sure to first remove any existing hadoop jar files, for example:

1. cap shell
   
2. cap> rm -f /opt/hypertable/current/lib/java/hadoop-*

复制代码

Then deposit the Hadoop jar files for your distribution under /opt/hypertab/current/lib/java and then distribute them to all machines in the cluster with the following command:

1. cap dist

复制代码

jieforest

over.