hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kristoffer Sjögren <sto...@gmail.com>
Subject Schema design for filters
Date Thu, 27 Jun 2013 17:59:41 GMT

Working with the standard filtering mechanism to scan rows that have
columns matching certain criterias.

There are columns of numeric (integer and decimal) and string types. These
columns are single or multi-valued like "1", "2", "1,2,3", "a", "b" or
"a,b,c" - not sure what the separator would be in the case of list types.
Maybe none?

I would like to compose the following queries to filter out rows that does
not match.

- contains(String column, String value)
  Single valued column that String.contain() provided value.

- equal(String column, Object value)
  Single valued column that Object.equals() provided value.
  Value is either string or numeric type.

- greaterThan(String column, java.lang.Number value)
  Single valued column that > provided numeric value.

- in(String column, Object value...)
  Multi-valued column have values that Object.equals() all provided values.
  Values are of string or numeric type.

How would I design a schema that can take advantage of the already existing
filters and comparators to accomplish this?

Already looked at the string and binary comparators but fail to see how to
solve this in a clean way for multi-valued column values.

Im aware of custom filters but would like to avoid it if possible.


  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message