hive java创建删除表

在这里插入图片描述

package com.hbase;

import org.apache.hadoop.conf.Configuration;
import org.apache.hadoop.hbase.*;
import org.apache.hadoop.hbase.client.*;
import org.apache.hadoop.hbase.util.Bytes;
import org.junit.Test;

import java.io.IOException;


public class TestHbase {
    public static void main(String[] args) throws IOException {
        Configuration conf= HBaseConfiguration.create();
        conf.set("hbase.zookeeper.quorum","zjgm01:2181,zjgm02:2181,zjgm03:2181");
        HBaseAdmin admin=new HBaseAdmin(conf);
        TableName name=TableName.valueOf("user");
        HTableDescriptor desc=new HTableDescriptor(name);
        HColumnDescriptor baseInfo=new HColumnDescriptor("base_info");
        HColumnDescriptor extraInfo=new HColumnDescriptor("extra_info");
        desc.addFamily(baseInfo);
        desc.addFamily(extraInfo);
    }
    @Test
    public void insertTest() throws IOException {
        Configuration conf=HBaseConfiguration.create();
        conf.set("hbase.zookeeper.quorum","zjgm01:2181,zjgm02:2181,zjgm03:2181");

        HTable user=new HTable(conf,"user");

        Put name=new Put(Bytes.toBytes("0001"));
        name.add(Bytes.toBytes("base_info"),Bytes.toBytes("name"),Bytes.toBytes("hualili"));

        user.put(name);
    }
    @Test
    public void testGet() throws IOException {
        Configuration conf=HBaseConfiguration.create();
        conf.set("hbase.zookeeper.quorum","zjgm01:2181,zjgm02:2181,zjgm03:2181");

        HTable user=new HTable(conf,"user");

        Get row=new Get(Bytes.toBytes("0001"));
        Result result=user.get(row);
        for(KeyValue kv:result.list()){
            String f=new String(kv.getFamily());
            System.out.println(f);
            String name=new String(kv.getQualifier());
            System.out.println(name);
            String v=new String(kv.getValue());
            System.out.println(v);
        }
    }


@Test
    public void testScan() throws IOException {
        Configuration conf=HBaseConfiguration.create();
        conf.set("hbase.zookeeper.quorum","zjgm01:2181,zjgm02:2181,zjgm03:2181");
        HTable user=new HTable(conf,"user");

        Scan scan=new Scan();
        scan.addFamily(Bytes.toBytes("base_info"));
        ResultScanner scanner=user.getScanner(scan);

        for (Result r:scanner){
            byte[]value=r.getValue(Bytes.toBytes("base_info"),Bytes.toBytes("name"));
            //byte[]value1=r.getValue(Bytes.toBytes("base_info"),Bytes.toBytes("age"));
           // System.out.println(new String(value)+"----"+new String(value1));
            System.out.println(new String(value));
        }
        user.close();
    }

    public void delete() throws IOException {
        Configuration conf = HBaseConfiguration.create();
        conf.set("hbase.zookeeper.quorum", "zjgm01:2181,zjgm02:2181,zjgm03:2181");
        HBaseAdmin admin=new HBaseAdmin(conf);
        admin.disableTable("user");
        admin.deleteTable("user");
        admin.close();
    }

    }

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值