[
https://issues.apache.org/jira/browse/KUDU-1452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15315675#comment-15315675
]
Sameer Abhyankar commented on KUDU-1452:
----------------------------------------
I havent given a lot of thought to this yet, but I think a viable merge
strategy might exist for every LIKE + <AnyOtherPredicate> combination. I would
think, the merge should simplify to the more restrictive predicate. I need to
give this a little more thought...
On the other hand, I do like the idea of adding an AND/OR variant that holds a
vector of sub-predicates. If not now, I do think it will have to be added
sometime in the future..
> Add predicate to allow scan based on COLUMN LIKE '%val%'
> --------------------------------------------------------
>
> Key: KUDU-1452
> URL: https://issues.apache.org/jira/browse/KUDU-1452
> Project: Kudu
> Issue Type: New Feature
> Components: api, client
> Reporter: Sameer Abhyankar
> Assignee: Sameer Abhyankar
>
> While working on a different issue, I noticed that Kudu currently has no way
> to fetch rows from a table based on the COLUMN LIKE '%value%' filter.
> Most relational DBs will allow lookups based on something like this:
> select c1, c2 from table-a where c3 like '%something%'
> I cant think of an efficient way to do this in Kudu, but I think it would
> still be more efficient than a client fetching all the rows and then doing
> the filtering.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
