java实现Hbase中的查询（一）Filter方式

1、需要的jar包：

commons-codec-1.4.jar

commons-logging-1.0.4.jar

hadoop-0.20.2-core.jar

hbase-0.20.6.jar

log4j-1.2.15.jar

zookeeper-3.2.2.jar

2、已有表结构：

1、表名：scores

2、列族：

course:art

course:math

grade:

3、scan 'scores'的内容：

ROW COLUMN+CELL
Jerry column=course:art, timestamp=1301294630194, value=80
Jerry column=course:math, timestamp=1301294630132, value=100
Jerry column=grade:, timestamp=1301294630073, value=2
Jim column=course:art, timestamp=1301294630363, value=97
Jim column=course:math, timestamp=1301294630305, value=100
Jim column=grade:, timestamp=1301294630247, value=3
Tom column=course:art, timestamp=1301294630015, value=97
Tom column=course:math, timestamp=1301294629987, value=87
Tom column=grade:, timestamp=1301294629931, value=1

4、代码：

[java:nogutter] view plain copy

1. packageorg.myhbase;
3. importjava.io.IOException;
4. importjava.util.ArrayList;
5. importjava.util.List;
7. importorg.apache.hadoop.conf.Configuration;
8. importorg.apache.hadoop.hbase.HBaseConfiguration;
9. importorg.apache.hadoop.hbase.KeyValue;
10. importorg.apache.hadoop.hbase.client.Get;
11. importorg.apache.hadoop.hbase.client.HTable;
12. importorg.apache.hadoop.hbase.client.Result;
13. importorg.apache.hadoop.hbase.client.ResultScanner;
14. importorg.apache.hadoop.hbase.client.Scan;
15. importorg.apache.hadoop.hbase.filter.FilterList;
16. importorg.apache.hadoop.hbase.filter.SingleColumnValueFilter;
17. importorg.apache.hadoop.hbase.filter.CompareFilter.CompareOp;
18. importorg.apache.hadoop.hbase.io.Cell;
19. importorg.apache.hadoop.hbase.util.Bytes;
21. publicclassHBaseBasic03{
22. privatestaticHBaseConfigurationhbaseConfig=null;
23. static{
24. Configurationconfig=newConfiguration();
25. config.set("hbase.zookeeper.quorum","192.168.10.149,192.168.10.44,192.168.10.49");
26. config.set("hbase.zookeeper.property.clientPort","2181");
27. hbaseConfig=newHBaseConfiguration(config);
28. }
30. /**
31. *get方式，通过rowKey查询
32. *@paramtablename
33. *@paramrowKey
34. *@throwsIOException
35. */
36. publicstaticvoidselectByRowKey(Stringtablename,StringrowKey)throwsIOException{
37. HTabletable=newHTable(hbaseConfig,tablename);
38. Getg=newGet(Bytes.toBytes(rowKey));
39. Resultr=table.get(g);
40. for(KeyValuekv:r.raw()){
41. System.out.println("column:"+newString(kv.getColumn()));
42. System.out.println("value:"+newString(kv.getValue()));
43. }
44. }
46. /**
47. *get方式，通过rowKey、column查询
48. *@paramtablename
49. *@paramrowKey
50. *@paramcolumn
51. *@throwsIOException
52. */
53. publicstaticvoidselectByRowKeyColumn(Stringtablename,StringrowKey,Stringcolumn)throwsIOException{
54. HTabletable=newHTable(hbaseConfig,tablename);
55. Getg=newGet(Bytes.toBytes(rowKey));
56. g.addColumn(Bytes.toBytes(column));
57. Resultr=table.get(g);
58. for(KeyValuekv:r.raw()){
59. System.out.println("column:"+newString(kv.getColumn()));
60. System.out.println("value:"+newString(kv.getValue()));
61. }
62. }
65. publicstaticvoidselectByFilter(Stringtablename,List<String>arr)throwsIOException{
66. HTabletable=newHTable(hbaseConfig,tablename);
67. FilterListfilterList=newFilterList();
68. Scans1=newScan();
69. for(Stringv:arr){//各个条件之间是“与”的关系
70. String[]s=v.split(",");
71. filterList.addFilter(newSingleColumnValueFilter(Bytes.toBytes(s[0]),
72. Bytes.toBytes(s[1]),
73. CompareOp.EQUAL,Bytes.toBytes(s[2])
74. )
75. );
76. //添加下面这一行后，则只返回指定的cell，同一行中的其他cell不返回
77. //s1.addColumn(Bytes.toBytes(s[0]),Bytes.toBytes(s[1]));
78. }
79. s1.setFilter(filterList);
80. ResultScannerResultScannerFilterList=table.getScanner(s1);
81. for(Resultrr=ResultScannerFilterList.next();rr!=null;rr=ResultScannerFilterList.next()){
82. for(KeyValuekv:rr.list()){
83. System.out.println("row:"+newString(kv.getRow()));
84. System.out.println("column:"+newString(kv.getColumn()));
85. System.out.println("value:"+newString(kv.getValue()));
86. }
87. }
88. }
90. publicstaticvoidmain(String[]args)throwsIOException{
92. //按rowkey查询，查询Tom行的所有cell
93. HBaseBasic03.selectByRowKey("scores","Tom");
95. //按rokey和column来查询，查询Tom行course列族的所有列值
96. HBaseBasic03.selectByRowKeyColumn("scores","Tom","course");
98. //Filter多条件查询，条件：查询course列族中art列值为97，且course列族中math列值为100的行
99. List<String>arr=newArrayList<String>();
100. arr.add("course,art,97");
101. arr.add("course,math,100");
102. HBaseBasic03.selectByFilter("scores",arr);
104. }
106. }