Hi 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. Cheers, -Kristoffer
