首页 > 其他 > 详细

向已经创建好的表添加和删除指定的列族或列。

时间:2020-11-11 13:53:03      阅读:109      评论:0      收藏:0      [点我收藏+]
import java.io.IOException;

import org.apache.hadoop.conf.Configuration;
import org.apache.hadoop.hbase.HBaseConfiguration;
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.client.Put;
import org.apache.hadoop.hbase.client.Table;


public class C_insertRows {
    public static Configuration configuration;
    public static Connection connection;
    public static Admin admin;
    
    /**
     * @param args
     * @throws IOException 
     */
    public static void main(String[] args) throws IOException {
        // TODO Auto-generated method stub
        insertRow("student", "2015001", "info", "S_name", "Zhangsan");
        insertRow("student", "2015001", "info", "S_sex", "male");
        insertRow("student", "2015001", "info", "S_age", "23");
        insertRow("student", "2015002", "info", "S_name", "Mary");
        insertRow("student", "2015002", "info", "S_sex", "female");
        insertRow("student", "2015002", "info", "S_age", "22");
        insertRow("student", "2015003", "info", "S_name", "Lisi");
        insertRow("student", "2015003", "info", "S_sex", "male");
        insertRow("student", "2015003", "info", "S_age", "20");
        insertRow("SC", "2015001_123001", "SC_score", "", "86");
        insertRow("SC", "2015001_123003", "SC_score", "", "69");
        insertRow("SC", "2015002_123002", "SC_score", "", "77");
        insertRow("SC", "2015002_123003", "SC_score", "", "99");
        insertRow("SC", "2015003_123001", "SC_score", "", "98");
        insertRow("SC", "2015003_123002", "SC_score", "", "95");
        insertRow("Course", "123001", "info", "C_Name", "Math");
        insertRow("Course", "123001", "info", "C_Credit", "2.0");
        insertRow("Course", "123002", "info", "C_Name", "Computer Science");
        insertRow("Course", "123002", "info", "C_Credit", "5.0");
        insertRow("Course", "123003", "info", "C_Name", "English");
        insertRow("Course", "123003", "info", "C_Credit", "3.0");
        B_getAllData show = new B_getAllData();
        show.getTableData("student");
    }
    //建立连接
    public static void init(){
        configuration  = HBaseConfiguration.create();
        configuration.set("hbase.rootdir","hdfs://localhost:9000/hbase");
        try{
            connection = ConnectionFactory.createConnection(configuration);
            admin = connection.getAdmin();
        }catch (IOException e){
            e.printStackTrace();
        }
    }
    //关闭连接
    public static void close(){
        try{
            if(admin != null){
                admin.close();
            }
            if(null != connection){
                connection.close();
            }
        }catch (IOException e){
            e.printStackTrace();
        }
    }

    //C_
    public static void insertRow(String tableName,String rowKey,String colFamily,String col,String val) throws IOException {
        init();
        Table table = connection.getTable(TableName.valueOf(tableName));
        Put put = new Put(rowKey.getBytes());
        put.addColumn(colFamily.getBytes(), col.getBytes(), val.getBytes());
        table.put(put);
        table.close();
        close();
    }
}

 

向已经创建好的表添加和删除指定的列族或列。

原文:https://www.cnblogs.com/MiraculousB/p/13958119.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!