package com.quyf;
import org.apache.hadoop.conf.Configuration;
import org.apache.hadoop.fs.Path;
import org.apache.hadoop.hbase.*;
import org.apache.hadoop.hbase.client.*;
import org.apache.hadoop.hbase.util.Bytes;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;
import java.io.IOException;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
/**
* Created by Administrator on 2018/4/8.
*/
public class HbaseDemo {
private static Connection conn;
private static Configuration configuration;
private static Admin admin;
public static void main(String[] args) throws Exception{
//System.out.println("hello world");
}
@Before
public void setup() throws Exception{
configuration = new Configuration();
configuration.set("hbase.zookeeper.quorum", "bg1:2181,bg2:2181,bg3:2181");
// configuration.addResource(new Path("I:\\gitproject\\hbase_demo\\src\\main\\resources\\hbase-site.xml"));
conn = ConnectionFactory.createConnection(configuration);
admin = conn.getAdmin();
}
/**
* 结束之后 关闭对象
*/
@After
public void End_up() throws Exception {
if (conn != null) conn.close();
}
@Test
public void create() throws IOException {
String[] cols = {"phone","addr","age"};
createTable("helloworld", cols);
}
/**
* @param tableName
* @param columns
* @throws IOException
*/
private void createTable(String tableName, String[] columns) throws IOException {
TableName tb = TableName.valueOf( tableName );
if( admin.tableExists( tb )){
System.out.println("已经存在");
}else{
System.out.println("not存在");
HTableDescriptor desc = new HTableDescriptor( tb );
for (String column:columns) {
desc.addFamily( new HColumnDescriptor(column));
}
admin.createTable(desc);
System.out.println("create "+tableName+" success");
}
}
@Test
public void showTable() throws IOException {
TableName[] tables = admin.listTableNames();
for(TableName tab:tables){
System.out.println("表名:"+tab.getNameAsString());
HTableDescriptor desc = admin.getTableDescriptor( tab );
for(HColumnDescriptor column: desc.getColumnFamilies()){
System.out.println(column.getNameAsString()+"==="+column.toString());
}
}
}
@Test
public void getByRowKey() throws IOException {
//admin.getTableDescriptor(TableName.valueOf("test"));
Table table = conn.getTable(TableName.valueOf("test"));
Get get = new Get("0004".getBytes());
Result rt = table.get(get);
System.out.println( rt.toString());
for(Cell cell:rt.rawCells()){
System.out.println(
Bytes.toString(CellUtil.cloneRow(cell))+"\t"+
Bytes.toString( CellUtil.cloneFamily(cell))+"\t"+
Bytes.toString(CellUtil.cloneQualifier(cell))+"\t"+
Bytes.toString( CellUtil.cloneValue(cell))
);
}
}
@Test
public void put() throws IOException {
Table tab = conn.getTable(TableName.valueOf("test"));
Put put1 = new Put("0004".getBytes());
put1.addColumn("info".getBytes(),"age".getBytes(),Bytes.toBytes("4"));
//put1.addColumn("info".getBytes(),"username".getBytes(),Bytes.toBytes("hellooww"));
Put put2 = new Put("0005".getBytes());
put2.addColumn("info".getBytes(),"age".getBytes(),Bytes.toBytes("45"));
// put2.addColumn("info".getBytes(),"username".getBytes(),Bytes.toBytes("alibaba"));
List list = new ArrayList();
list.add(put1);
list.add(put2);
tab.put(list);
}
@Test
public void deletByRowKey() throws IOException {
Table table = conn.getTable(TableName.valueOf("test"));
Delete delete = new Delete(Bytes.toBytes("0004"));
//如果age列有多个版本的话,这里只删除了最新的一个版本,其他版本的数据还在的,
// addColumn是删除某一个列簇里的最新时间戳版本。
// delete.addColumns是删除某个列簇里的所有时间戳版本。
//delete.addColumn("info".getBytes(),"age".getBytes());
//测试下删除不存在的列
// delete.addColumn("info".getBytes(),"hh".getBytes());
//测试下删除不存在的列簇 会报错 column family info22 does not exist in region test
delete.addColumn("info22".getBytes(),"hh".getBytes());
table.delete(delete);
table.close();
}
@Test
public void scanTable() throws IOException {
Table table = conn.getTable(TableName.valueOf("test"));
Scan scan = new Scan();
//scan可以加很多条件和范围
scan.withStartRow("0002".getBytes());
//scan.withStopRow("0004".getBytes());//不包含末尾行
scan.withStopRow("0004".getBytes(),true);//包含末尾行
ResultScanner rtScan = table.getScanner( scan );
// Iterator itor = rtScan.iterator();
// while(itor.hasNext()){
// System.out.println( itor.next().toString());
// }
for (org.apache.hadoop.hbase.client.Result next = rtScan.next();next !=null;next = rtScan.next() ){
System.out.println(next.toString());
}
}
}