[
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)
