hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From aloharich <rich.al...@gmail.com>
Subject scan with ColumnPrefixFilter, but return all columns that match
Date Thu, 02 Jul 2015 17:10:23 GMT
i'm still designing and coming up to speed with hbase, trying to use a
columnprefix filter to find rows/keys that have a certain family:column key,
and then get all  the data for that key.

so the goal would be, assuming there was a table like this (example)

> create 'cars' , 'interior', 'exterior'

Then assuming there was a bunch of rows with cars with a key by license
plate (i know, this example is contrived and silly), and I wanted to find
all keys/rows (and their data) that have a exterior:sunroof key, and then
all of their rows of data (still coming up to speed on the terminology here,
so welcome suggestion on what I've gotten wrong ;-)

12345   column=interior:radio value=foo
12345   column=interior:seat value=bar
12345   column=exterior:sunroof value=foo
22345   column=exterior:wheels value=two
22345   column=interior:radio value=bar

     scan 'cars', { COLUMNS => ['exterior'], LIMIT => 10, FILTER =>
"(ColumnPrefixFilter('sunroof')" }   

Now that scan works and finds just the 12345 key, but i'd also like to get
all the other data about the key in a single scan. Currently I have to get
the rows/keys, then  another scan for each to find all their associated
data.

Wondering if there is one way, in such a scenerio to get all the data, based
on a column:key existing in a row?

Thanks,

Rich




--
View this message in context: http://apache-hbase.679495.n3.nabble.com/scan-with-ColumnPrefixFilter-but-return-all-columns-that-match-tp4072862.html
Sent from the HBase User mailing list archive at Nabble.com.

Mime
View raw message