Hey folks, I was contemplating having a LIKE type search on Secondary Indexes.
LIKE_S, S_LIKE and S_LIKE_S (similiar to LIKE '%eg', 'eg% and '%eg%' I am not sure if this has already been discussed or even an existing JIRA or maybe something maybe I could contribute myself? It looks like the best way to-do this would be to add some additional properties to IndexExpression so we know we want to-do a LIKE check pseudo coding my thoughts taking this from ColumnFamilyStore int v = data.metadata().getValueValidator(expression.column_name).compare(column.value(), expression.value); if (!satisfies(v, expression.op)) return false; and make it something like this if (expression.LIKE) { if (!column.MakeItAStringValue().equalsIgnoreCase(express.value)) //this would actually fall into a switch for S_LIKE, LIKE_S, S_LIKE_S return false; else { int v = data.metadata().getValueValidator(expression.column_name).compare(column.value(), expression.value); if (!satisfies(v, expression.op)) return false; } am i on the right track? smoking crack? let me know please /* Joe Stein http://www.linkedin.com/in/charmalloc Twitter: @allthingshadoop */