putforIDX2(Bytes.toBytes("row5"), table);
putforIDX2(Bytes.toBytes("row6"), table);
putforIDX3(Bytes.toBytes("row1"), table);
putforIDX3(Bytes.toBytes("row3"), table);
FilterList masterFilter = new FilterList(Operator.MUST_PASS_ALL);
// create the filter
FilterList filter = new FilterList(Operator.MUST_PASS_ONE);
SingleColumnValueFilter iscvf1 =
new SingleColumnValueFilter("cf1".getBytes(), "c1".getBytes(), CompareOp.EQUAL,
"apple".getBytes());
SingleColumnValueFilter iscvf2 =
new SingleColumnValueFilter("cf1".getBytes(), "c2".getBytes(), CompareOp.EQUAL,
"bat".getBytes());
filter.addFilter(iscvf1);
filter.addFilter(iscvf2);
FilterList filter1 = new FilterList(Operator.MUST_PASS_ALL);
iscvf1 =
new SingleColumnValueFilter("cf1".getBytes(), "c3".getBytes(), CompareOp.EQUAL,
"cat".getBytes());
iscvf2 =
new SingleColumnValueFilter("cf1".getBytes(), "c4".getBytes(), CompareOp.EQUAL,
"dog".getBytes());
filter1.addFilter(iscvf1);
filter1.addFilter(iscvf2);
FilterList filter2 = new FilterList(Operator.MUST_PASS_ALL);
iscvf1 =
new SingleColumnValueFilter("cf1".getBytes(), "c5".getBytes(), CompareOp.EQUAL,
"ele".getBytes());
iscvf2 =
new SingleColumnValueFilter("cf1".getBytes(), "c6".getBytes(), CompareOp.EQUAL,
"fan".getBytes());
filter2.addFilter(iscvf1);
filter2.addFilter(iscvf2);
masterFilter.addFilter(filter);
masterFilter.addFilter(filter1);
masterFilter.addFilter(filter2);