[jira] [Updated] (HAWQ-1110) Optimize LIKE operator on storage layer
[ 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: >= AND <= Where NEXT_TOKEN = .substring(0, .length() - 2) + .substring(.length() -2, .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: >= AND <= 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: >= AND <= > Where NEXT_TOKEN = .substring(0, .length() - 2) + > .substring(.length() -2, .length() - 1) + 1 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-1110) Optimize LIKE operator on storage layer
[ https://issues.apache.org/jira/browse/HAWQ-1110?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Goden Yao updated HAWQ-1110: Assignee: Oleksandr Diachenko (was: Lei Chang) > 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: >= AND <= > Where NEXT_TOKEN = -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-1110) Optimize LIKE operator on storage layer
[ 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: >= AND <= Where NEXT_TOKEN = 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: >= AND <= > 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: Lei Chang > 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: >= AND <= > Where NEXT_TOKEN = -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-1110) Optimize LIKE operator on storage layer
[ https://issues.apache.org/jira/browse/HAWQ-1110?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Goden Yao updated HAWQ-1110: Fix Version/s: backlog > 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: Lei Chang > 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: >= AND <= -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-1110) Optimize LIKE operator on storage layer
[ 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: >= AND <= was:As for now HiveORC profile doesn't use any storage layer optimizations for LIKE operator. > 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: Lei Chang > > 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: >= AND <= -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-1110) Optimize LIKE operator on storage layer
[ 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. > 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: Lei Chang > > As for now HiveORC profile doesn't use any storage layer optimizations for > LIKE operator. -- This message was sent by Atlassian JIRA (v6.3.4#6332)