[ https://issues.apache.org/jira/browse/HIVE-16407?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sudarshan updated HIVE-16407: ----------------------------- Attachment: issue_reproduce.sql > 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 > Attachments: issue_reproduce.sql > > > 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)