[
https://issues.apache.org/jira/browse/KUDU-1452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15315674#comment-15315674
]
Sameer Abhyankar commented on KUDU-1452:
----------------------------------------
I have played with the C++ STL regex and its pretty good. We can certainly use
it for this particular case.
I do get the point about arbitrary regex evaluation leaving a little too much
to user discretion. However, I think the risks are similar to what we have with
SQL like/REGEXP predicates. The worst you can do is a full table scan. Even
without full regex, you can do a full tablescan with a '%' filter.
> 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)
