[jira] [Commented] (KUDU-1452) Add predicate to allow scan based on COLUMN LIKE '%val%'

["Dan Burkert (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/KUDU-1452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15517950#comment-15517950 ] 

Dan Burkert commented on KUDU-1452:
-----------------------------------

For low cardinality tablets we also may want to push {{LIKE %val%}} predicates into a set of primary key bounds, a la KUDU-1291.

> 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: Sub-task
>          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)