HBase条件过滤时注意

在hbase条件过滤时一定要注意，过滤的条件一定要包含在Scan中，否则过滤无效。

 

过滤无效：

 

Scan scan = new Scan();
scan.setCaching(300);
scan.addFamily(HTableConstant.IPJ_STATICS_ACTION_FAMILY);//action
 
scan.addColumn(
		HTableConstant.IPJ_STATICS_ACTION_FAMILY,
		HTableConstant.IPJ_STATICS_APP_ID_QUALIFIER); //action:app_id
scan.addColumn(
		HTableConstant.IPJ_STATICS_ACTION_FAMILY,
		HTableConstant.IPj_STATICS_VERSION_QUALIFIER);//action:version
scan.addColumn(
		HTableConstant.IPJ_STATICS_ACTION_FAMILY,
		HTableConstant.IPj_STATICS_IMEI_QUALIFIER);   //action:imei
scan.addColumn(
		HTableConstant.IPJ_STATICS_ACTION_FAMILY,
		HTableConstant.IPJ_STATICS_DATE_QUALIFIER);   //action:date
 
List<String> array = new ArrayList<String>();
array.add("action,event,应用");
array.add("action,label,启动");
HBaseManager.setAndFilter(scan, array);
 

 

过滤有效：

Scan scan = new Scan();
scan.setCaching(300);
scan.addFamily(HTableConstant.IPJ_STATICS_ACTION_FAMILY)//action
 
scan.addColumn(
		HTableConstant.IPJ_STATICS_ACTION_FAMILY,
		HTableConstant.IPJ_STATICS_APP_ID_QUALIFIER);  //action:app_id
scan.addColumn(
		HTableConstant.IPJ_STATICS_ACTION_FAMILY,
		HTableConstant.IPj_STATICS_VERSION_QUALIFIER); //action:version
scan.addColumn(
		HTableConstant.IPJ_STATICS_ACTION_FAMILY,
		HTableConstant.IPj_STATICS_IMEI_QUALIFIER);    //action:imei
scan.addColumn(
		HTableConstant.IPJ_STATICS_ACTION_FAMILY,
		HTableConstant.IPJ_STATICS_DATE_QUALIFIER);    //action:date
scan.addColumn(
		HTableConstant.IPJ_STATICS_ACTION_FAMILY,
		HTableConstant.IPJ_STATICS_EVENT_QUALIFIER);   //action:event
scan.addColumn(
		HTableConstant.IPJ_STATICS_ACTION_FAMILY,
		HTableConstant.IPJ_STATICS_LABEL_QUALIFIER);   //action:label
 
List<String> array = new ArrayList<String>();
array.add("action,event,应用");
array.add("action,label,启动");
HBaseManager.setAndFilter(scan, array);