hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aihua Xu (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-14194) Investigate optimizing the query compilation of long or-list in where statement
Date Thu, 19 Jan 2017 15:09:26 GMT

     [ 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, we will still have performance issue during compilation.
Investigate if we can optimize it.

  was:
The following query will take long time to compile if the where statement has a long list
of 'or'. Investigate if we can optimize it.

select * from src 
where key = 1
or key =2
or ....



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



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message