The Prefix filters did not work for me. Actually, performance went down. But I am going to try with fix for HBASE-6870 (suggested by Ted) deployed to our Performance cluster. Regards, - kiru
Kiru Pakkirisamy | webcloudtech.wordpress.com ________________________________ From: lars hofhansl <[email protected]> To: "[email protected]" <[email protected]> Sent: Friday, August 9, 2013 12:55 PM Subject: Re: Hadoop-HBase table hierarchical column scan Take a look at ColumnRangeFilter, (probably better in your case) ColumnPrefixFilter, or MultipleColumnPrefixFilter. Especially the latter two let you efficiently filter on prefixes of columns. Note that if typically scan a subset of the columns, placing these prefixes into the row key will be more efficient, as the scanner can then avoid a full scan. -- Lars ________________________________ From: Narlin M <[email protected]> To: [email protected] Sent: Friday, August 9, 2013 12:44 PM Subject: Hadoop-HBase table hierarchical column scan I am fairly new to the hadoop-hbase environment having started working on it very recently, so I hope I am wording the question correctly. I am trying to read data from a hadoop-hbase table which has only one column family named 'DFLT'. This family contains hierarchical column qualifiers "/source:int64/name:string". I want to read the name column for a particular source value, say 10. How can I achieve this using the Scan class? I tried setting up the scan object as follows: ... byte[] family = Bytes.toBytes("DFLT"); byte[] qualifier = Bytes.toBytes("source:name"); Scan scan = new Scan(); scan.addColumn(family, qualifier); FilterList list = new FilterList(FilterList.Operator.MUST_PASS_ALL); SingleColumnValueFilter filter = new SingleColumnValueFilter(family, Bytes.toBytes("source"), CompareFilter.CompareOp.EQUAL,Bytes.toBytes(10)); list.addFilter(filter); scan.setFilter(list); ... But I do not get any data back with this setup. I am guessing that I am not setting up the hierarchical qualifiers correctly. Any and all pointers will be appreciated. Thanks, Narlin M.
