1.限制条件
scan 'ecpcibimbqm:lijieran',{COLUMNS=>'d'}
scan 'ecpcibimbqm:lijieran',{COLUMNS=>['d','n']}
hbase(main):002:0> scan 'ecpcibimbqm:lijieran',{COLUMNS=>'d'} ROW COLUMN+CELL 000,EZGJPRN2YJP9 column=d:recordType, timestamp=1555064148545, value=FEED_TRAXCP 000,EZGJPRN2YJP9 column=d:venue, timestamp=1555064154049, value=TRAXCP 001,EZGJPRN2YJP9 column=d:BenchmarkCUSIP, timestamp=1555064066607, value=912810SD1 001,EZGJPRN2YJP9 column=d:rawstoreId, timestamp=1555064148298, value=d0df2796-8a50-3672-8c95-e82f509f4afc 001,EZGJPRN2YJP9 column=d:recordId, timestamp=1555064148534, value=43ad4aab-1a09-4200-a061-5794495fbf1a 002,EZGJPRN2YJP9 column=d:BenchmarkISIN, timestamp=1555064066648, value=US9128285G14 003,EZGJPRN2YJP9 column=d:Cusip, timestamp=1555064066796, value=00290FBP9 003,EZGJPRN2YJP9 column=d:InboundMessageDateTime, timestamp=1555064066809, value=2018-11-16T00:00:00Z 003,EZGJPRN2YJP9 column=d:isin, timestamp=1555064066892, value=EZGJPRN2YJP9 004,EZGJPRN2YJP9 column=d:NextCallDate, timestamp=1555064066822, value=46767
scan 'ecpcibimbqm:lijieran',{COLUMNS=>'d:venue'}
hbase(main):003:0> scan 'ecpcibimbqm:lijieran',{COLUMNS=>'d:venue'} ROW COLUMN+CELL 000,EZGJPRN2YJP9 column=d:venue, timestamp=1555064154049, value=TRAXCP 1111 column=d:venue, timestamp=1527499827743, value=BUD
scan 'ecpcibimbqm:lijieran',{COLUMNS=>['d','n'],LIMIT=>1}
hbase(main):012:0> scan 'ecpcibimbqm:lijieran',{COLUMNS=>['d','n'],LIMIT=>1} ROW COLUMN+CELL 000,EZGJPRN2YJP9 column=d:recordType, timestamp=1555064148545, value=FEED_TRAXCP 000,EZGJPRN2YJP9 column=d:venue, timestamp=1555064154049, value=TRAXCP
scan 'ecpcibimbqm:lijieran',{TIMERANGE=>[1555397135751,1555397135795]}
hbase(main):014:0> scan 'ecpcibimbqm:lijieran',{TIMERANGE=>[1555397135751,1555397135795]} ROW COLUMN+CELL e8ab858a-03fa-36de-9791-d19257709 column=d:id[0]/type, timestamp=1555397135751, value=Isin 5dd,H,210,2018-03-14T06:50:11.848 Z e8ab858a-03fa-36de-9791-d19257709 column=d:id[0]/val, timestamp=1555397135761, value=TL0JEQPZ4HZ0 5dd,H,210,2018-03-14T06:50:11.848 Z e8ab858a-03fa-36de-9791-d19257709 column=d:pid, timestamp=1555397135774, value=194809150182 5dd,H,210,2018-03-14T06:50:11.848 Z e8ab858a-03fa-36de-9791-d19257709 column=d:rel[0]/rpid, timestamp=1555397135784, value=194809150183 5dd,H,210,2018-03-14T06:50:11.848 Z
2.filter 过滤部分
PrefixFilter:rowKey前缀过滤
scan 'ecpcibimbqm:lijieran',{FILTER=>"PrefixFilter('003')"}
hbase(main):001:0> scan 'ecpcibimbqm:lijieran',{FILTER=>"PrefixFilter('003')"} ROW COLUMN+CELL 003,EZGJPRN2YJP9 column=d:Cusip, timestamp=1555064066796, value=00290FBP9 003,EZGJPRN2YJP9 column=d:InboundMessageDateTime, timestamp=1555064066809, value=2018-11-16T00:00:00Z 003,EZGJPRN2YJP9 column=d:isin, timestamp=1555064066892, value=EZGJPRN2YJP9
QualifierFilter:列过滤器
QualifierFilter对列的名称进行过滤，而不是列的值。
hbase(main):005:0> scan 'ecpcibimbqm:lijieran',{FILTER=>"PrefixFilter('003') AND QualifierFilter(>=,'binary:Cusip')"} ROW COLUMN+CELL 003,EZGJPRN2YJP9 column=d:Cusip, timestamp=1555064066796, value=00290FBP9 003,EZGJPRN2YJP9 column=d:InboundMessageDateTime, timestamp=1555064066809, value=2018-11-16T00:00:00Z 003,EZGJPRN2YJP9 column=d:isin, timestamp=1555064066892, value=EZGJPRN2YJP9 1 row(s) in 0.0590 seconds hbase(main):006:0> scan 'ecpcibimbqm:lijieran',{FILTER=>"PrefixFilter('003') AND QualifierFilter(=,'binary:Cusip')"} ROW COLUMN+CELL 003,EZGJPRN2YJP9 column=d:Cusip, timestamp=1555064066796, value=00290FBP9
TimestampsFilter:时间戳过滤器
hbase(main):007:0> scan 'ecpcibimbqm:lijieran',{FILTER=>"TimestampsFilter(1555397135751,1555397135795)"} ROW COLUMN+CELL e8ab858a-03fa-36de-9791-d19257709 column=d:id[0]/type, timestamp=1555397135751, value=Isin 5dd,H,210,2018-03-14T06:50:11.848 Z e8ab858a-03fa-36de-9791-d19257709 column=d:rel[1]/rpid, timestamp=1555397135795, value=194809150184 5dd,H,210,2018-03-14T06:50:11.848 Z