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)
