hbase基本的表管理和访问

最新推荐文章于 2022-09-03 12:17:49 发布

超级侠哥

最新推荐文章于 2022-09-03 12:17:49 发布

阅读量474

点赞数

分类专栏： Hadoop大数据相关

本文链接：https://blog.csdn.net/znb769525443/article/details/35292081

版权

Hadoop大数据相关专栏收录该内容

13 篇文章 2 订阅

订阅专栏

1.导入hbase依赖的jar包

hadoop-core-1.1.2.jar

zookeeper-3.4.5.jar

hbase-0.94.20-tests.jar

hbase-0.94.20.jar

以及hbase安装目录下lib中的包

2.程序代码如下：

package com.hadoop.hbase;

import org.apache.hadoop.conf.Configuration;
import org.apache.hadoop.hbase.HBaseConfiguration;
import org.apache.hadoop.hbase.HColumnDescriptor;
import org.apache.hadoop.hbase.HTableDescriptor;
import org.apache.hadoop.hbase.client.Get;
import org.apache.hadoop.hbase.client.HBaseAdmin;
import org.apache.hadoop.hbase.client.HTable;
import org.apache.hadoop.hbase.client.Put;
import org.apache.hadoop.hbase.client.Result;
import org.apache.hadoop.hbase.client.ResultScanner;
import org.apache.hadoop.hbase.client.Scan;
import org.apache.hadoop.hbase.util.Bytes;

/**
 * hbase基本的表管理和访问
 * 
 * @author root 2014-6-27
 */
public class ExampleClient {

	private static HBaseAdmin admin;
	private static HTable table;

	public static void main(String[] args) throws Exception {
		Configuration config = HBaseConfiguration.create();

		admin = new HBaseAdmin(config);
		HTableDescriptor htd = new HTableDescriptor("test");
		HColumnDescriptor hcd = new HColumnDescriptor("data");
		htd.addFamily(hcd);
		admin.createTable(htd);
		byte[] tablename = htd.getName();
		HTableDescriptor[] tables = admin.listTables();
		if (tables.length != 1 && Bytes.equals(tablename, tables[0].getName())) {
			throw new Exception("Failed create of table");
		}

		table = new HTable(config, tablename);
		byte[] row1 = Bytes.toBytes("row1");
		Put p1 = new Put(row1);
		byte[] databytes = Bytes.toBytes("data");
		p1.add(databytes, Bytes.toBytes("1"), Bytes.toBytes("values"));
		table.put(p1);

		Get g = new Get(row1);
		Result result = table.get(g);
		System.out.println("GET:" + result);

		Scan scan = new Scan();
		ResultScanner scanner = table.getScanner(scan);
		try {
			for (Result scannerResult : scanner) {
				System.out.println("Scan:" + scannerResult);
			}
		} finally {
			scanner.close();
		}

		// drop the table
		admin.disableTable(tablename);
		admin.deleteTable(tablename);
	}
}

3.出现如下表示运行正常

14/06/27 18:34:51 INFO zookeeper.ZooKeeper: Client environment:zookeeper.version=3.4.5-1392090, built on 09/30/2012 17:52 GMT
14/06/27 18:34:51 INFO zookeeper.ZooKeeper: Client environment:host.name=znb
14/06/27 18:34:51 INFO zookeeper.ZooKeeper: Client environment:java.version=1.8.0_05
14/06/27 18:34:51 INFO zookeeper.ZooKeeper: Client environment:java.vendor=Oracle Corporation
14/06/27 18:34:51 INFO zookeeper.ZooKeeper: Client environment:java.home=/usr/lib/java/jdk1.8/jre
14/06/27 18:34:51 INFO zookeeper.ZooKeeper: Client environment:java.class.path=/home/znb/workspace/hadoop/hadoop/bin:/home/znb/workspace/hadoop/hadoop/lib/activation-1.1.jar:/home/znb/workspace/hadoop/hadoop/lib/asm-3.1.jar:/home/znb/workspace/hadoop/hadoop/lib/avro-1.5.3.jar:/home/znb/workspace/hadoop/hadoop/lib/avro-ipc-1.5.3.jar:/home/znb/workspace/hadoop/hadoop/lib/commons-beanutils-1.7.0.jar:/home/znb/workspace/hadoop/hadoop/lib/commons-beanutils-core-1.8.0.jar:/home/znb/workspace/hadoop/hadoop/lib/commons-cli-1.2.jar:/home/znb/workspace/hadoop/hadoop/lib/commons-codec-1.4.jar:/home/znb/workspace/hadoop/hadoop/lib/commons-collections-3.2.1.jar:/home/znb/workspace/hadoop/hadoop/lib/commons-configuration-1.6.jar:/home/znb/workspace/hadoop/hadoop/lib/commons-digester-1.8.jar:/home/znb/workspace/hadoop/hadoop/lib/commons-el-1.0.jar:/home/znb/workspace/hadoop/hadoop/lib/commons-httpclient-3.1.jar:/home/znb/workspace/hadoop/hadoop/lib/commons-io-2.1.jar:/home/znb/workspace/hadoop/hadoop/lib/commons-lang-2.5.jar:/home/znb/workspace/hadoop/hadoop/lib/commons-logging-1.1.1.jar:/home/znb/workspace/hadoop/hadoop/lib/commons-math-2.1.jar:/home/znb/workspace/hadoop/hadoop/lib/commons-net-1.4.1.jar:/home/znb/workspace/hadoop/hadoop/lib/core-3.1.1.jar:/home/znb/workspace/hadoop/hadoop/lib/guava-11.0.2.jar:/home/znb/workspace/hadoop/hadoop/lib/hadoop-core-1.1.2.jar:/home/znb/workspace/hadoop/hadoop/lib/hamcrest-core-1.3.jar:/home/znb/workspace/hadoop/hadoop/lib/hbase-0.94.20-tests.jar:/home/znb/workspace/hadoop/hadoop/lib/hbase-0.94.20.jar:/home/znb/workspace/hadoop/hadoop/lib/high-scale-lib-1.1.1.jar:/home/znb/workspace/hadoop/hadoop/lib/httpclient-4.1.2.jar:/home/znb/workspace/hadoop/hadoop/lib/httpcore-4.1.3.jar:/home/znb/workspace/hadoop/hadoop/lib/jackson-core-asl-1.8.8.jar:/home/znb/workspace/hadoop/hadoop/lib/jackson-jaxrs-1.8.8.jar:/home/znb/workspace/hadoop/hadoop/lib/jackson-mapper-asl-1.8.8.jar:/home/znb/workspace/hadoop/hadoop/lib/jackson-xc-1.8.8.jar:/home/znb/workspace/hadoop/hadoop/lib/jamon-runtime-2.3.1.jar:/home/znb/workspace/hadoop/hadoop/lib/jasper-compiler-5.5.23.jar:/home/znb/workspace/hadoop/hadoop/lib/jasper-runtime-5.5.23.jar:/home/znb/workspace/hadoop/hadoop/lib/jaxb-api-2.1.jar:/home/znb/workspace/hadoop/hadoop/lib/jaxb-impl-2.2.3-1.jar:/home/znb/workspace/hadoop/hadoop/lib/jersey-core-1.8.jar:/home/znb/workspace/hadoop/hadoop/lib/jersey-json-1.8.jar:/home/znb/workspace/hadoop/hadoop/lib/jersey-server-1.8.jar:/home/znb/workspace/hadoop/hadoop/lib/jettison-1.1.jar:/home/znb/workspace/hadoop/hadoop/lib/jetty-6.1.26.jar:/home/znb/workspace/hadoop/hadoop/lib/jetty-util-6.1.26.jar:/home/znb/workspace/hadoop/hadoop/lib/jruby-complete-1.6.5.jar:/home/znb/workspace/hadoop/hadoop/lib/jsp-2.1-6.1.14.jar:/home/znb/workspace/hadoop/hadoop/lib/jsp-api-2.1-6.1.14.jar:/home/znb/workspace/hadoop/hadoop/lib/jsr305-1.3.9.jar:/home/znb/workspace/hadoop/hadoop/lib/junit-4.11.jar:/home/znb/workspace/hadoop/hadoop/lib/libthrift-0.8.0.jar:/home/znb/workspace/hadoop/hadoop/lib/log4j-1.2.16.jar:/home/znb/workspace/hadoop/hadoop/lib/metrics-core-2.1.2.jar:/home/znb/workspace/hadoop/hadoop/lib/netty-3.2.4.Final.jar:/home/znb/workspace/hadoop/hadoop/lib/protobuf-java-2.4.0a.jar:/home/znb/workspace/hadoop/hadoop/lib/servlet-api-2.5-6.1.14.jar:/home/znb/workspace/hadoop/hadoop/lib/slf4j-api-1.4.3.jar:/home/znb/workspace/hadoop/hadoop/lib/slf4j-log4j12-1.4.3.jar:/home/znb/workspace/hadoop/hadoop/lib/snappy-java-1.0.3.2.jar:/home/znb/workspace/hadoop/hadoop/lib/stax-api-1.0.1.jar:/home/znb/workspace/hadoop/hadoop/lib/velocity-1.7.jar:/home/znb/workspace/hadoop/hadoop/lib/xmlenc-0.52.jar:/home/znb/workspace/hadoop/hadoop/lib/zookeeper-3.4.5.jar
14/06/27 18:34:51 INFO zookeeper.ZooKeeper: Client environment:java.library.path=/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
14/06/27 18:34:51 INFO zookeeper.ZooKeeper: Client environment:java.io.tmpdir=/tmp
14/06/27 18:34:51 INFO zookeeper.ZooKeeper: Client environment:java.compiler=<NA>
14/06/27 18:34:51 INFO zookeeper.ZooKeeper: Client environment:os.name=Linux
14/06/27 18:34:51 INFO zookeeper.ZooKeeper: Client environment:os.arch=amd64
14/06/27 18:34:51 INFO zookeeper.ZooKeeper: Client environment:os.version=3.11.0-23-generic
14/06/27 18:34:51 INFO zookeeper.ZooKeeper: Client environment:user.name=root
14/06/27 18:34:51 INFO zookeeper.ZooKeeper: Client environment:user.home=/root
14/06/27 18:34:51 INFO zookeeper.ZooKeeper: Client environment:user.dir=/home/znb/workspace/hadoop/hadoop
14/06/27 18:34:51 INFO zookeeper.ZooKeeper: Initiating client connection, connectString=localhost:2181 sessionTimeout=180000 watcher=hconnection
14/06/27 18:34:51 INFO zookeeper.RecoverableZooKeeper: The identifier of this process is 14511@znb
14/06/27 18:34:51 INFO zookeeper.ClientCnxn: Opening socket connection to server localhost/127.0.0.1:2181. Will not attempt to authenticate using SASL (unknown error)
14/06/27 18:34:51 INFO zookeeper.ClientCnxn: Socket connection established to localhost/127.0.0.1:2181, initiating session
14/06/27 18:34:51 INFO zookeeper.ClientCnxn: Session establishment complete on server localhost/127.0.0.1:2181, sessionid = 0x146dca9d17c0016, negotiated timeout = 180000
14/06/27 18:34:52 INFO zookeeper.ZooKeeper: Initiating client connection, connectString=localhost:2181 sessionTimeout=180000 watcher=catalogtracker-on-org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation@26aa12dd
14/06/27 18:34:52 INFO zookeeper.ClientCnxn: Opening socket connection to server localhost/127.0.0.1:2181. Will not attempt to authenticate using SASL (unknown error)
14/06/27 18:34:52 INFO zookeeper.ClientCnxn: Socket connection established to localhost/127.0.0.1:2181, initiating session
14/06/27 18:34:52 INFO zookeeper.RecoverableZooKeeper: The identifier of this process is 14511@znb
14/06/27 18:34:52 INFO zookeeper.ClientCnxn: Session establishment complete on server localhost/127.0.0.1:2181, sessionid = 0x146dca9d17c0017, negotiated timeout = 180000
14/06/27 18:34:52 INFO zookeeper.ZooKeeper: Session: 0x146dca9d17c0017 closed
14/06/27 18:34:52 INFO zookeeper.ClientCnxn: EventThread shut down
GET:keyvalues={row1/data:1/1403865292631/Put/vlen=6/ts=0}
Scan:keyvalues={row1/data:1/1403865292631/Put/vlen=6/ts=0}
14/06/27 18:34:52 INFO client.HBaseAdmin: Started disable of test
14/06/27 18:34:52 INFO zookeeper.ZooKeeper: Initiating client connection, connectString=localhost:2181 sessionTimeout=180000 watcher=catalogtracker-on-org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation@26aa12dd
14/06/27 18:34:52 INFO zookeeper.RecoverableZooKeeper: The identifier of this process is 14511@znb
14/06/27 18:34:52 INFO zookeeper.ClientCnxn: Opening socket connection to server localhost/127.0.0.1:2181. Will not attempt to authenticate using SASL (unknown error)
14/06/27 18:34:52 INFO zookeeper.ClientCnxn: Socket connection established to localhost/127.0.0.1:2181, initiating session
14/06/27 18:34:52 INFO zookeeper.ClientCnxn: Session establishment complete on server localhost/127.0.0.1:2181, sessionid = 0x146dca9d17c0018, negotiated timeout = 180000
14/06/27 18:34:52 INFO zookeeper.ZooKeeper: Session: 0x146dca9d17c0018 closed
14/06/27 18:34:52 INFO zookeeper.ClientCnxn: EventThread shut down
14/06/27 18:34:53 INFO zookeeper.ZooKeeper: Initiating client connection, connectString=localhost:2181 sessionTimeout=180000 watcher=catalogtracker-on-org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation@26aa12dd
14/06/27 18:34:53 INFO zookeeper.RecoverableZooKeeper: The identifier of this process is 14511@znb
14/06/27 18:34:53 INFO zookeeper.ClientCnxn: Opening socket connection to server localhost/127.0.0.1:2181. Will not attempt to authenticate using SASL (unknown error)
14/06/27 18:34:53 INFO zookeeper.ClientCnxn: Socket connection established to localhost/127.0.0.1:2181, initiating session
14/06/27 18:34:53 INFO zookeeper.ClientCnxn: Session establishment complete on server localhost/127.0.0.1:2181, sessionid = 0x146dca9d17c0019, negotiated timeout = 180000
14/06/27 18:34:53 INFO zookeeper.ZooKeeper: Session: 0x146dca9d17c0019 closed
14/06/27 18:34:53 INFO zookeeper.ClientCnxn: EventThread shut down
14/06/27 18:34:53 INFO client.HBaseAdmin: Disabled test
14/06/27 18:34:54 INFO client.HBaseAdmin: Deleted test