[
https://issues.apache.org/jira/browse/HAWQ-1110?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Oleksandr Diachenko updated HAWQ-1110:
--------------------------------------
Description:
As for now HiveORC profile doesn't use any storage layer optimizations for LIKE
operator.
Current optimization could be applied:
1) Parse first token of LIKE clause before first occurrence of "%" symbol.
2) Apply ORC filter: >=<TOKEN> AND <=<NEXT_TOKEN>
Where NEXT_TOKEN = <TOKEN>.substring(0, <TOKEN>.length() - 2) +
<TOKEN>.substring(<TOKEN>.length() -2, <TOKEN>.length() - 1) + 1
was:
As for now HiveORC profile doesn't use any storage layer optimizations for LIKE
operator.
Current optimization could be applied:
1) Parse first token of LIKE clause before first occurrence of "%" symbol.
2) Apply ORC filter: >=<TOKEN> AND <=<NEXT_TOKEN>
Where NEXT_TOKEN =
> Optimize LIKE operator on storage layer
> ---------------------------------------
>
> Key: HAWQ-1110
> URL: https://issues.apache.org/jira/browse/HAWQ-1110
> Project: Apache HAWQ
> Issue Type: Improvement
> Components: PXF
> Reporter: Oleksandr Diachenko
> Assignee: Oleksandr Diachenko
> Fix For: backlog
>
>
> As for now HiveORC profile doesn't use any storage layer optimizations for
> LIKE operator.
> Current optimization could be applied:
> 1) Parse first token of LIKE clause before first occurrence of "%" symbol.
> 2) Apply ORC filter: >=<TOKEN> AND <=<NEXT_TOKEN>
> Where NEXT_TOKEN = <TOKEN>.substring(0, <TOKEN>.length() - 2) +
> <TOKEN>.substring(<TOKEN>.length() -2, <TOKEN>.length() - 1) + 1
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
