中的rowkey 获取hbase,如何从HBase表中获取包含（或等于）特定ID的所有行？

I have a method which select the row whose rowkey contains the parameter passed into.

HTable table = new HTable(Bytes.toBytes(objectsTableName), connection);

public List lookUp(String partialId) {

if (partialId.matches("[a-fA-F0-9]+")) {

// create a regular expression from partialId, which can

//match any rowkey that contains partialId as a substring,

//and then get all the row with the specified rowkey

} else {

throw new IllegalArgumentException(

"query must be done with hexadecimal values only");

}

}

I don't know how to finish code above.

I just know the following code can get the row with specified rowkey in Hbase.

String rowkey = "123";

Get get = new Get(Bytes.toBytes(rowkey));

Result result = table.get(get);

解决方案

You can use

public static void main(String[] args) throws IOException {

Configuration conf = HBaseConfiguration.create();

HTable table = new HTable(conf, "demo");

Scan s = new Scan();

Filter f = new RowFilter(CompareOp.EQUAL, new SubstringComparator("abc"));

s.setFilter(f);

ResultScanner rs = table.getScanner(s);

for(Result r : rs){

System.out.println("RowKey : " + Bytes.toString(r.getRow()));

//rest of your logic

}

rs.close();

table.close();

}

The above piece of code will give you all the rows which contain abc as a part of their rowkeys.

HTH