向已经创建好的表添加和删除指定的列族或列。
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(); } }