export JAVA_HOME=/root/apps/jdk1..0_67

export HBASE_MANAGES_ZK=false

    <configuration>

        <!-- 指定hbase在HDFS上存储的路径 -->

        <property>

                <name>hbase.rootdir</name>
　　　　　　　　　　<!-- 会在hdfs根目录/下建立一个文件夹，用来放hbase中的数据【Hbase基于HDFS】-->
                <value>hdfs://hdp01:9000/hbase</value>

        </property>

        <!-- 指定hbase是分布式的 -->

        <property>

                <name>hbase.cluster.distributed</name>

                <value>true</value>

        </property>

        <!-- 指定zk的地址，多个用“,”分割 -->

        <property>

                <name>hbase.zookeeper.quorum</name>

                <value>hdp01:2181,hdp02:2181,hdp03:2181</value>

        </property>

    </configuration>

hdp01

hdp02

hdp03

bin/start-hbase.sh

bin/hbase-daemon.sh start master

bin/hbase-daemon.sh start master

bin/hbase-daemon.sh start regionserever

bin/hbase shell

Hbase> list     // 查看表

Hbase> status   // 查看集群状态

Hbase> version  // 查看集群版本

bin/hbase shell

create 't_user_info','base_info','extra_info'

         表名      列族名   列族名

put 't_user_info','行健','列族:key','value'

hbase(main):011:0> put 't_user_info','','base_info:username','zhangsan'

0 row(s) in 0.2420 seconds

hbase(main):012:0> put 't_user_info','','base_info:age',''

0 row(s) in 0.0140 seconds

hbase(main):013:0> put 't_user_info','','base_info:sex','female'

0 row(s) in 0.0070 seconds

hbase(main):014:0> put 't_user_info','','extra_info:career','it'

0 row(s) in 0.0090 seconds

hbase(main):015:0> put 't_user_info','','extra_info:career','actoress'

0 row(s) in 0.0090 seconds

hbase(main):016:0> put 't_user_info','','base_info:username','liuyifei'

0 row(s) in 0.0060 seconds

-- 返回该行全部数据

get 't_user_info','行健'

-- 返回该行指定列族：key的值

get 't_user_info','行健', '列族:key'

hbase(main):020:0> get 't_user_info',''

COLUMN                            CELL

 base_info:age                    timestamp=1496568160192, value=19

 base_info:sex                    timestamp=1496567934669, value=female

 base_info:username               timestamp=1496567889554, value=zhangsan

 extra_info:career                timestamp=1496567963992, value=it

4 row(s) in 0.0770 seconds

hbase(main):017:0> scan 't_user_info'

ROW                               COLUMN+CELL

 001                              column=base_info:age, timestamp=1496567924507, value=18

 001                              column=base_info:sex, timestamp=1496567934669, value=female

 001                              column=base_info:username, timestamp=1496567889554, value=zhangsan

 001                              column=extra_info:career, timestamp=1496567963992, value=it

 002                              column=base_info:username, timestamp=1496568034187, value=liuyifei

 002                              column=extra_info:career, timestamp=1496568008631, value=actoress

2 row(s) in 0.0420 seconds

hbase(main):021:0> delete 't_user_info','','base_info:sex'

0 row(s) in 0.0390 seconds

hbase(main):024:0> deleteall 't_user_info',''

0 row(s) in 0.0090 seconds

hbase(main):025:0> get 't_user_info',''

COLUMN                            CELL

0 row(s) in 0.0110 seconds

hbase(main):028:0> disable 't_user_info'

0 row(s) in 2.3640 seconds

hbase(main):029:0> drop 't_user_info'

0 row(s) in 1.2950 seconds

hbase(main):030:0> list

TABLE

0 row(s) in 0.0130 seconds

=> []

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.TableName;

import org.apache.hadoop.hbase.client.Admin;

import org.apache.hadoop.hbase.client.Connection;

import org.apache.hadoop.hbase.client.ConnectionFactory;

import org.apache.hadoop.hbase.regionserver.BloomType;

Connection conn = null;

    @Before

    public void getConn() throws Exception{

        // new Configuration() 加载的是hadoop的配置文件：core-site.xml hdfs-site.xml，不会加载hbase-site.xml
　　　　 // 构建一个连接对象
　　　　 // Hbase提供了HbaseConfiguraton 用来加载hbase-site.xml
　　　　 Configuration conf = HBaseConfiguration.create(); // 会自动加载hbase-site.xml
　　　　 // 客户端查询数据的路由流程可知：客户端需要先链接 Zookeeper 获取索引表

        conf.set("hbase.zookeeper.quorum", "hdp-01:2181,hdp-02:2181,hdp-03:2181");

　　　　 // 创建链接对象

        conn = ConnectionFactory.createConnection(conf);

    }

Connection conn = ConnectionFactory.createConnection(conf);

Admin admin = conn.getAdmin();

admin.createTable(HTableDescriptor descriptor);

@Test

    public void testCreateTable() throws Exception{

        // 从连接中构造一个DDL操作器

        Admin admin = conn.getAdmin();

        // 创建一个表定义描述对象

        HTableDescriptor hTableDescriptor = new HTableDescriptor(TableName.valueOf("user_info"));

        // 创建列族定义描述对象
        // 通过列族描述定义对象，可以设置列族的很多重要属性信息

        HColumnDescriptor hColumnDescriptor_1 = new HColumnDescriptor("base_info");

        hColumnDescriptor_1.setMaxVersions(3); // 设置该列族中存储数据的最大版本数,默认是1

        HColumnDescriptor hColumnDescriptor_2 = new HColumnDescriptor("extra_info");

        // 将列族定义信息对象放入表定义对象中

        hTableDescriptor.addFamily(hColumnDescriptor_1);

        hTableDescriptor.addFamily(hColumnDescriptor_2);

        // 用ddl操作器对象：admin 来建表

        admin.createTable(hTableDescriptor);

        // 关闭连接

        admin.close();

        conn.close();

    }

@Test

    public void testDropTable() throws Exception{

        Admin admin = conn.getAdmin();

        // 停用表

        admin.disableTable(TableName.valueOf("user_info"));

        // 删除表

        admin.deleteTable(TableName.valueOf("user_info"));

        admin.close();

        conn.close();

    }

// 修改表定义--添加一个列族

    @Test

    public void testAlterTable() throws Exception{

        Admin admin = conn.getAdmin();

        // 取出旧的表定义信息

        HTableDescriptor tableDescriptor = admin.getTableDescriptor(TableName.valueOf("user_info"));

        // 新构造一个列族定义

        HColumnDescriptor hColumnDescriptor = new HColumnDescriptor("other_info");

        hColumnDescriptor.setBloomFilterType(BloomType.ROWCOL); // 设置该列族的布隆过滤器类型

        // 将列族定义添加到表定义对象中

        tableDescriptor.addFamily(hColumnDescriptor);

        // 将修改过的表定义交给admin去提交

        admin.modifyTable(TableName.valueOf("user_info"), tableDescriptor);

        admin.close();

        conn.close();

    }

// 获取一个操作指定表的table对象,进行DML操作

Table table = conn.getTable(TableName.valueOf("user_info"));

import org.apache.hadoop.conf.Configuration;

import org.apache.hadoop.hbase.Cell;

import org.apache.hadoop.hbase.CellScanner;

import org.apache.hadoop.hbase.HBaseConfiguration;

import org.apache.hadoop.hbase.TableName;

import org.apache.hadoop.hbase.client.Connection;

import org.apache.hadoop.hbase.client.ConnectionFactory;

import org.apache.hadoop.hbase.client.Delete;

import org.apache.hadoop.hbase.client.Get;

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.client.Table;

import org.apache.hadoop.hbase.util.Bytes;

    /**

     * 增

     * 改:put来覆盖

     * @throws Exception

     */

    @Test

    public void testPut() throws Exception{

        // 获取一个操作指定表的table对象,进行DML操作

        Table table = conn.getTable(TableName.valueOf("user_info"));

        // 构造要插入的数据为一个Put类型(一个put对象只能对应一个rowkey)的对象

        Put put = new Put(Bytes.toBytes("001"));

        put.addColumn(Bytes.toBytes("base_info"), Bytes.toBytes("username"), Bytes.toBytes("张三"));

        put.addColumn(Bytes.toBytes("base_info"), Bytes.toBytes("age"), Bytes.toBytes("18"));

        put.addColumn(Bytes.toBytes("extra_info"), Bytes.toBytes("addr"), Bytes.toBytes("北京"));

        Put put2 = new Put(Bytes.toBytes("002"));

        put2.addColumn(Bytes.toBytes("base_info"), Bytes.toBytes("username"), Bytes.toBytes("李四"));

        put2.addColumn(Bytes.toBytes("base_info"), Bytes.toBytes("age"), Bytes.toBytes("28"));

        put2.addColumn(Bytes.toBytes("extra_info"), Bytes.toBytes("addr"), Bytes.toBytes("上海"));

        ArrayList<Put> puts = new ArrayList<>();

        puts.add(put);

        puts.add(put2);

        // 插进去

        table.put(puts);

        table.close();

        conn.close();

    }

/**

     * 循环插入大量数据

     * @throws Exception

     */

    @Test

    public void testManyPuts() throws Exception{

        Table table = conn.getTable(TableName.valueOf("user_info"));

        ArrayList<Put> puts = new ArrayList<>();

        for(int i=0;i<100000;i++){

            Put put = new Put(Bytes.toBytes(""+i));

            put.addColumn(Bytes.toBytes("base_info"), Bytes.toBytes("username"), Bytes.toBytes("张三"+i));

            put.addColumn(Bytes.toBytes("base_info"), Bytes.toBytes("age"), Bytes.toBytes((18+i)+""));

            put.addColumn(Bytes.toBytes("extra_info"), Bytes.toBytes("addr"), Bytes.toBytes("北京"));

            puts.add(put);

        }

        table.put(puts);

    }

    /**

     * 删

     * @throws Exception

     */

    @Test

    public void testDelete() throws Exception{

        Table table = conn.getTable(TableName.valueOf("user_info"));

        // 构造一个对象封装要删除的数据信息
　　　　 // 全部删除

        Delete delete1 = new Delete(Bytes.toBytes("001"));

　　　　 // 删除指定的key

        Delete delete2 = new Delete(Bytes.toBytes("002"));
　　　　 // qualifier为用户意义上的key，hbase中 family+qualifier 为一个key

        delete2.addColumn(Bytes.toBytes("extra_info"), Bytes.toBytes("addr"));

        ArrayList<Delete> dels = new ArrayList<>();

        dels.add(delete1);

        dels.add(delete2);

        table.delete(dels);

        table.close();

        conn.close();

    }
    

/**

     * 查

     * @throws Exception

     */

    @Test

    public void testGet() throws Exception{

        Table table = conn.getTable(TableName.valueOf("user_info"));

        // Get对象 指定行健
　　　　 Get get = new Get("002".getBytes());

        // 行健为002的全部数据

        Result result = table.get(get);

        // 从结果中取用户指定的某个key的value

        byte[] value = result.getValue("base_info".getBytes(), "age".getBytes());

        System.out.println(new String(value));

        System.out.println("-------------------------");

        // 遍历整行结果中的所有kv单元格
　　　　 // 类似迭代器

        CellScanner cellScanner = result.cellScanner();

        while(cellScanner.advance()){

            Cell cell = cellScanner.current();

            byte[] rowArray = cell.getRowArray();  //本kv所属的行键的字节数组

            byte[] familyArray = cell.getFamilyArray();  //列族名的字节数组

            byte[] qualifierArray = cell.getQualifierArray();  //列名的字节数据

            byte[] valueArray = cell.getValueArray(); // value的字节数组

　　　　　　　// Hbase不仅仅是存储用户数据，同时还会存储很多附加的信息，以上get方法直接将用户数据和附加数据一起返回，若想获取用户信息，需要指定其实偏移量和数据长度　

            System.out.println("行键: "+new String(rowArray,cell.getRowOffset(),cell.getRowLength()));

            System.out.println("列族名: "+new String(familyArray,cell.getFamilyOffset(),cell.getFamilyLength()));

            System.out.println("列名: "+new String(qualifierArray,cell.getQualifierOffset(),cell.getQualifierLength()));

            System.out.println("value: "+new String(valueArray,cell.getValueOffset(),cell.getValueLength()));

        }

        table.close();

        conn.close();

    }
    

/**

     * 按行键范围查询数据

     * @throws Exception

     */

    @Test

    public void testScan() throws Exception{

        Table table = conn.getTable(TableName.valueOf("user_info"));

        // 包含起始行键，不包含结束行键,但是如果真的想查询出末尾的那个行键，那么，可以在末尾行键上拼接一个不可见的字节（\000）
　　　　 // Scan scan = new Scan("10".getBytes(), "10000".getBytes());

        Scan scan = new Scan("10".getBytes(), "10000\001".getBytes());

        ResultScanner scanner = table.getScanner(scan);

        Iterator<Result> iterator = scanner.iterator();

        while(iterator.hasNext()){

            // 拿到一行数据

            Result result = iterator.next();

            // 遍历整行结果中的所有kv单元格

            CellScanner cellScanner = result.cellScanner();

            while(cellScanner.advance()){

                Cell cell = cellScanner.current();

                byte[] rowArray = cell.getRowArray();  //本kv所属的行键的字节数组

                byte[] familyArray = cell.getFamilyArray();  //列族名的字节数组

                byte[] qualifierArray = cell.getQualifierArray();  //列名的字节数据

                byte[] valueArray = cell.getValueArray(); // value的字节数组

                System.out.println("行键: "+new String(rowArray,cell.getRowOffset(),cell.getRowLength()));

                System.out.println("列族名: "+new String(familyArray,cell.getFamilyOffset(),cell.getFamilyLength()));

                System.out.println("列名: "+new String(qualifierArray,cell.getQualifierOffset(),cell.getQualifierLength()));

                System.out.println("value: "+new String(valueArray,cell.getValueOffset(),cell.getValueLength()));

            }

            System.out.println("----------------------");

        }

    }
    

@Test

    public void test(){

        String a = "000";

        String b = "000\0";

        System.out.println(a);

        System.out.println(b);

        byte[] bytes = a.getBytes();

        byte[] bytes2 = b.getBytes();

        System.out.println("");

        }

000

000