1:创建一个名为HELLO的表:
>create 'HELLO','id','address','info'
2:插入数据:
>put'HELLO','10','info:age','24'
>put'HELLO','12','info:age','24'
>put'HELLO','12','info:city','shanghai'
......
3:删除数据:
>disable 'HELLO'
>is_enabled 'HELLO'
>alter 'HELLO',{NAME=>'id',METHOD=>'delete'}
>enable'HELLO'
删除表:
>disable 'HELLO'
>drop 'HELLO'
>exists 'HELLO'检查表是否存在
4:获取数据:
>get'HELLO','10'
>get'HELLO','10','info'
>get'HELLO','10','info:age'
5:查询表中数据多少行:
>count'HELLO'
6:删除整行:
>deleteall'HELLO','10'
7:增加字段:>incr 'HELLO','10','info:city'
8:scan浏览表中的数据:>scan "HELLO"
ROW COLUMN+CELL
10 column=info:age, timestamp=1513232005994, value=24
12 column=address:city, timestamp=1513143006267, value=hefei
12 column=address:contry, timestamp=1513142953004, value=china
12 column=address:province, timestamp=1513142991236, value=anhui
12 column=info:age, timestamp=1513142508015, value=24
12 column=info:birthday, timestamp=1513142882018, value=2017
12 column=info:company, timestamp=1513142919588, value=hpe
9:scala读取hbase数据
import org.apache.hadoop.hbase.util.Bytes import org.apache.hadoop.hbase.{HColumnDescriptor, HTableDescriptor, TableName, HBaseConfiguration} import org.apache.hadoop.hbase.client._ import org.apache.spark.SparkContext import scala.collection.JavaConversions._ import org.apache.hadoop.fs.Path import kafka.utils.ZkUtils val hbaseConf = HBaseConfiguration.create() hbaseConf.addResource(new Path("/etc/alternatives/hbase-conf/hbase-site.xml")) val zkClientAndConnection = ZkUtils.createZkClientAndConnection(zkUrl, sessionTimeOut, connectionTimeOut) val conn = ConnectionFactory.createConnection(hbaseConf) val hbaseTableName = "HELLO" val table = conn.getTable(TableName.valueOf(hbaseTableName)) //将'10'的age数据改为25 val p = new Put("10".getBytes) p.addColumn("info".getBytes,"age".getBytes,"25".getBytes) table.put(p) //查询某条数据 val g = new Get("10".getBytes) val result = table.get(g) val value = Bytes.toString(result.getValue("info".getBytes,"age".getBytes)) //扫描数据 val scan = new Scan() scan.addColumn("info".getBytes,"age".getBytes) val scanner = table.getScanner(scan) val r = scanner.next() //数据10的信息 Bytes.toString(r.value)//返回结果:String = 25 val r1 = scanner.next() //数据12的信息 Bytes.toString(r1.value)//返回结果:String = 24 //删除某条数据 val d = new Delete("10".getBytes) d.addColumn("info".getBytes,"age".getBytes) table.delete(d) //删除某表 val hbaseConf = HBaseConfiguration.create() hbaseConf.addResource(new Path("/etc/alternatives/hbase-conf/hbase-site.xml")) val conn = ConnectionFactory.createConnection(hbaseConf) val admin = conn.getAdmin() val hbaseTableName = "HELLO" val hbaseTable = TableName.valueOf(hbaseTableName) admin.disableTable(hbaseTable) admin.deleteTable(hbaseTable)