You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Sudarshan (JIRA)" <ji...@apache.org> on 2017/04/07 18:28:41 UTC

[jira] [Created] (HIVE-16407) Compilation of a query with lots of conditions (like 2200) in a where clause can take a lot of time

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)