[
https://issues.apache.org/jira/browse/HIVE-14194?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Aihua Xu updated HIVE-14194:
----------------------------
Description:
If a query has a long OR-list, when possible, the OR-list can be optimized with
IN-list to have better performance during compilation (resolved by HIVE-11424).
{noformat}
select * from src
where key = 1
or key =2
or ....
{noformat}
But for the cases which can't be converted e.g., if it contains {{key < 2}}, we
will still have performance issue during compilation. Investigate if we can
optimize it.
was:
If a query has a long OR-list, when possible, the OR-list can be optimized with
IN-list to have better performance during compilation (resolved by HIVE-11424).
{noformat}
select * from src
where key = 1
or key =2
or ....
{noformat}
But for the cases which can't be converted, we will still have performance
issue during compilation. Investigate if we can optimize it.
> Investigate optimizing the query compilation of long or-list in where
> statement
> --------------------------------------------------------------------------------
>
> Key: HIVE-14194
> URL: https://issues.apache.org/jira/browse/HIVE-14194
> Project: Hive
> Issue Type: Improvement
> Reporter: Aihua Xu
> Assignee: Aihua Xu
> Priority: Major
>
> If a query has a long OR-list, when possible, the OR-list can be optimized
> with IN-list to have better performance during compilation (resolved by
> HIVE-11424).
> {noformat}
> select * from src
> where key = 1
> or key =2
> or ....
> {noformat}
> But for the cases which can't be converted e.g., if it contains {{key < 2}},
> we will still have performance issue during compilation. Investigate if we
> can optimize it.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
