HBase API操作

1.1 环境准备

新建项目后在pom.xml中添加依赖：

<dependency>     <groupId>org.apache.hbase</groupId>     <artifactId>hbase-server</artifactId>     <version>1.3.1</version> </dependency>   <dependency>     <groupId>org.apache.hbase</groupId>     <artifactId>hbase-client</artifactId>     <version>1.3.1</version> </dependency>   <dependency>    <groupId>jdk.tools</groupId>    <artifactId>jdk.tools</artifactId>    <version>1.8</version>    <scope>system</scope>    <systemPath>${JAVA_HOME}/lib/tools.jar</systemPath> </dependency>

 

1.2 HBaseAPI

1.2.1 获取Configuration对象

public static Configuration conf; static{    //使用HBaseConfiguration的单例方法实例化    conf = HBaseConfiguration.create();   //hbase-site.xml可以替换以下这两行代码   conf.set("hbase.zookeeper.quorum", "192.168.9.102");   conf.set("hbase.zookeeper.property.clientPort", "2181"); }

此部分还可以将xml配置文件放入到resource文件夹下，来替换上边这些代码

hbase-site.xml

<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<!--
/**
 *
 * Licensed to the Apache Software Foundation (ASF) under one
 * or more contributor license agreements.  See the NOTICE file
 * distributed with this work for additional information
 * regarding copyright ownership.  The ASF licenses this file
 * to you under the Apache License, Version 2.0 (the
 * "License"); you may not use this file except in compliance
 * with the License.  You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
-->
<configuration>
<property>     
		<name>hbase.rootdir</name>     
		<value>hdfs://hadoop102:9000/hbase</value>   
	</property>

	<property>   
		<name>hbase.cluster.distributed</name>
		<value>true</value>
	</property>

   <!-- 0.98后的新变动，之前版本没有.port,默认端口为60000 -->
	<property>
		<name>hbase.master.port</name>
		<value>16000</value>
	</property>

	<property>   
		<name>hbase.zookeeper.quorum</name>
	     <value>hadoop102:2181,hadoop103:2181,hadoop104:2181</value>
	</property>

	<property>   
		<name>hbase.zookeeper.property.dataDir</name>
	     <value>/opt/module/zookeeper-3.4.5/data</value>
	</property>
</configuration>

1.2.2 判断表是否存在

public static boolean isTableExist(String tableName) throws MasterNotRunningException,  ZooKeeperConnectionException, IOException{    //在HBase中管理、访问表需要先创建HBaseAdmin对象 //Connection connection = ConnectionFactory.createConnection(conf); //HBaseAdmin admin = (HBaseAdmin) connection.getAdmin();    HBaseAdmin admin = new HBaseAdmin(conf);    return admin.tableExists(tableName); }

1.2.3 创建表

public static void createTable(String tableName, String... columnFamily) throws  MasterNotRunningException, ZooKeeperConnectionException, IOException{    HBaseAdmin admin = new HBaseAdmin(conf);    //判断表是否存在    if(isTableExist(tableName)){       System.out.println("表" + tableName + "已存在");       //System.exit(0);    }else{       //创建表属性对象,表名需要转字节       HTableDescriptor descriptor = new HTableDescriptor(TableName.valueOf(tableName));       //创建多个列族       for(String cf : columnFamily){           descriptor.addFamily(new HColumnDescriptor(cf));       }       //根据对表的配置，创建表       admin.createTable(descriptor);       System.out.println("表" + tableName + "创建成功！");    } }

1.2.4 删除表

public static void dropTable(String tableName) throws MasterNotRunningException,  ZooKeeperConnectionException, IOException{    HBaseAdmin admin = new HBaseAdmin(conf);    if(isTableExist(tableName)){       admin.disableTable(tableName);       admin.deleteTable(tableName);       System.out.println("表" + tableName + "删除成功！");    }else{       System.out.println("表" + tableName + "不存在！");    } }

1.2.5 向表中插入数据

public static void addRowData(String tableName, String rowKey, String columnFamily, String  column, String value) throws IOException{    //创建HTable对象    HTable hTable = new HTable(conf, tableName);    //向表中插入数据    Put put = new Put(Bytes.toBytes(rowKey));    //向Put对象中组装数据    put.add(Bytes.toBytes(columnFamily), Bytes.toBytes(column), Bytes.toBytes(value));    hTable.put(put);    hTable.close();    System.out.println("插入数据成功"); }

1.2.6 删除多行数据

public static void deleteMultiRow(String tableName, String... rows) throws IOException{    HTable hTable = new HTable(conf, tableName);    List<Delete> deleteList = new ArrayList<Delete>();    for(String row : rows){       Delete delete = new Delete(Bytes.toBytes(row));       deleteList.add(delete);    }    hTable.delete(deleteList);    hTable.close(); }

1.2.7 获取所有数据

public static void getAllRows(String tableName) throws IOException{    HTable hTable = new HTable(conf, tableName);    //得到用于扫描region的对象    Scan scan = new Scan();    //使用HTable得到resultcanner实现类的对象    ResultScanner resultScanner = hTable.getScanner(scan);    for(Result result : resultScanner){       Cell[] cells = result.rawCells();       for(Cell cell : cells){           //得到rowkey           System.out.println("行键:" + Bytes.toString(CellUtil.cloneRow(cell)));           //得到列族           System.out.println("列族" + Bytes.toString(CellUtil.cloneFamily(cell)));           System.out.println("列:" + Bytes.toString(CellUtil.cloneQualifier(cell)));           System.out.println("值:" + Bytes.toString(CellUtil.cloneValue(cell)));       }    } }

1.2.8 获取某一行数据

public static void getRow(String tableName, String rowKey) throws IOException{    HTable table = new HTable(conf, tableName);    Get get = new Get(Bytes.toBytes(rowKey));    //get.setMaxVersions();显示所有版本     //get.setTimeStamp();显示指定时间戳的版本    Result result = table.get(get);    for(Cell cell : result.rawCells()){       System.out.println("行键:" + Bytes.toString(result.getRow()));       System.out.println("列族" + Bytes.toString(CellUtil.cloneFamily(cell)));       System.out.println("列:" + Bytes.toString(CellUtil.cloneQualifier(cell)));       System.out.println("值:" + Bytes.toString(CellUtil.cloneValue(cell)));       System.out.println("时间戳:" + cell.getTimestamp());    } }

1.2.9 获取某一行指定“列族:列”的数据

public static void getRowQualifier(String tableName, String rowKey, String family, String  qualifier) throws IOException{    HTable table = new HTable(conf, tableName);    Get get = new Get(Bytes.toBytes(rowKey));    get.addColumn(Bytes.toBytes(family), Bytes.toBytes(qualifier));    Result result = table.get(get);    for(Cell cell : result.rawCells()){       System.out.println("行键:" + Bytes.toString(result.getRow()));       System.out.println("列族" + Bytes.toString(CellUtil.cloneFamily(cell)));       System.out.println("列:" + Bytes.toString(CellUtil.cloneQualifier(cell)));       System.out.println("值:" + Bytes.toString(CellUtil.cloneValue(cell)));    } }