[ 
https://issues.apache.org/jira/browse/IMPALA-14737?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Zoltán Borók-Nagy updated IMPALA-14737:
---------------------------------------
    Description: 
Iceberg's 
[https://github.com/apache/iceberg/blob/main/api/src/main/java/org/apache/iceberg/expressions/Expressions.java]
 supports more possibilities than what we currently use.

The most important one is probably
 * startsWith()

I.e., when we have the following predicate: {{string_col LIKE 'asdf%xyz'}}

We should push down:
 * startsWith("string_col", "asdf")

I.e., the non-wildcard prefix of the string.

It should work for UTF-8 strings as well.

  was:
Iceberg's 
[https://github.com/apache/iceberg/blob/main/api/src/main/java/org/apache/iceberg/expressions/Expressions.java]
 supports more possibilities than what we currently use.

The most important one is probably
 * startsWith()

I.e., when we have the following predicate: {{string_col LIKE 'asdf%xyz'}}

We should push down:
 * startsWith("string_col", "asdf")

I.e., the non-wildcard prefix of the string.

It should work for UTF-8 strings.


> Pushdown LIKE predicates to Iceberg
> -----------------------------------
>
>                 Key: IMPALA-14737
>                 URL: https://issues.apache.org/jira/browse/IMPALA-14737
>             Project: IMPALA
>          Issue Type: Improvement
>            Reporter: Zoltán Borók-Nagy
>            Priority: Major
>              Labels: impala-iceberg, ramp-up
>
> Iceberg's 
> [https://github.com/apache/iceberg/blob/main/api/src/main/java/org/apache/iceberg/expressions/Expressions.java]
>  supports more possibilities than what we currently use.
> The most important one is probably
>  * startsWith()
> I.e., when we have the following predicate: {{string_col LIKE 'asdf%xyz'}}
> We should push down:
>  * startsWith("string_col", "asdf")
> I.e., the non-wildcard prefix of the string.
> It should work for UTF-8 strings as well.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to