[jira] [Issue Comment Deleted] (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:all-tabpanel ]

Dan Burkert updated KUDU-1452:
------------------------------
    Comment: was deleted

(was: This is a great point.  Perhaps adding an `And` variant that holds a vector of sub-predicates could fix this?  Merge(Equality, Like(%val)) => And([Equality, Like(%val)).)

> 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)