Hbase实现Like查询

最新推荐文章于 2021-02-24 01:25:57 发布

panguoyuan

最新推荐文章于 2021-02-24 01:25:57 发布

阅读量4.2k

点赞数

分类专栏： NoSQL数据库笔记大数据平台开发笔记（hadoop|storm|spark）文章标签： hbase api filter

本文链接：https://blog.csdn.net/panguoyuan/article/details/39208131

版权

大数据平台开发笔记（hadoop|storm|spark）同时被 2 个专栏收录

50 篇文章 0 订阅

订阅专栏

NoSQL数据库笔记

5 篇文章 0 订阅

订阅专栏

Hbase的api中可以通过filter来实现like查询

public static void likeQueryByRowkey() throws Exception{
		    Scan scan = new Scan();  
		    RegexStringComparator comp = new RegexStringComparator("(2014-09)");  
		    RowFilter filter = new RowFilter(CompareOp.EQUAL, comp);  
		    scan.setFilter(filter);  
		    scan.setCaching(200);  
		    scan.setCacheBlocks(false);  
		    HTable hTable = new HTable(configuration, "access_page_ip_basis_hour");  
		    ResultScanner scanner = hTable.getScanner(scan);  
		    byte[] fbytes = Bytes.toBytes("columnFamily1");
		    byte[] cbytes = Bytes.toBytes("h_time"); 
		    for (Result r : scanner) {  
		    	AccessPageIpBasisHour o = new AccessPageIpBasisHour();
				for (KeyValue kv : r.raw()) {
					if("pageNum".equals(new String(kv.getQualifier()))){
						o.setPageNum(Integer.parseInt(new String(kv.getValue())));
						String hTime = new String(kv.getRow());
						o.sethTime(hTime);
					}else if("ipNum".equals(new String(kv.getQualifier()))){
						o.setIpNum(Integer.parseInt(new String(kv.getValue())));
					}else if("accessNum".equals(new String(kv.getQualifier()))){
						o.setAccessNum(Integer.parseInt(new String(kv.getValue())));
					}
				}
				System.out.println(o.getAccessNum());
		    }  
	}
	
	public static void likeQueryByColumn() throws Exception{
	        Scan scan = new Scan();  
	        RegexStringComparator comp = new RegexStringComparator("(##2014-09)");  
	        byte[] bytes = Bytes.toBytes("h_time");  
	        Filter filter = new SingleColumnValueFilter(bytes, bytes, CompareOp.EQUAL, comp);  
	        scan.setFilter(filter);  
	        scan.setCaching(200);  
	        scan.setCacheBlocks(false);  
	        HTable hTable = new HTable(configuration, "access_page_ip_basis_hour");  
	        ResultScanner scanner = hTable.getScanner(scan);  
	        for (Result r : scanner) {  
	        	AccessPageIpBasisHour o = new AccessPageIpBasisHour();
				for (KeyValue kv : r.raw()) {
					if("pageNum".equals(new String(kv.getQualifier()))){
						o.setPageNum(Integer.parseInt(new String(kv.getValue())));
						String hTime = new String(kv.getRow());
						o.sethTime(hTime);
					}else if("ipNum".equals(new String(kv.getQualifier()))){
						o.setIpNum(Integer.parseInt(new String(kv.getValue())));
					}else if("accessNum".equals(new String(kv.getQualifier()))){
						o.setAccessNum(Integer.parseInt(new String(kv.getValue())));
					}
				}
				System.out.println(o.gethTime());
	        }  
	    }