hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sudarshan (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-16407) Compilation of a query with lots of conditions (like 2200) in a where clause can take a lot of time
Date Fri, 07 Apr 2017 18:28:41 GMT
Sudarshan created HIVE-16407:
--------------------------------

             Summary: Compilation of a query with lots of conditions (like 2200) in a where
clause can take a lot of time
                 Key: HIVE-16407
                 URL: https://issues.apache.org/jira/browse/HIVE-16407
             Project: Hive
          Issue Type: Improvement
          Components: HiveServer2
            Reporter: Sudarshan


Following is the table structure.

----
create table test_hello (
a string);
----

A query that involves lots of "OR" conditions can in a "where" clause, can take a really long
time to compile. It doesn't finishes compilation in even 30 to 40 minutes. 

++++
select * from test_hello
where
(
a like '%1%'  or 
<Repeat above line 2000 times>
a like '%1%' 
)
+++++


(Attaching the entire script to the Jira)



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message