[ https://issues.apache.org/jira/browse/HIVE-16407?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15961655#comment-15961655 ]
Sudarshan edited comment on HIVE-16407 at 4/8/17 2:58 AM: ---------------------------------------------------------- Thanks for taking a look [~ashutoshc] . Attached script was missing a ";" in the last line. ( just deleting the attachment and adding it again). Can you confirm if you had added ";" ? was (Author: sudarshans): [~ashutoshc] Attached script was missing a ";" in the last line. ( just deleting the attachment and adding it again). Can you confirm if you had added ";" ? > Compilation of a query with lots of "OR" conditions (like 2200) that check > for "like" condition 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)