Make case-insensitive substring search as fast as case-sensitive variant ------------------------------------------------------------------------
Key: HIVE-1747 URL: https://issues.apache.org/jira/browse/HIVE-1747 Project: Hive Issue Type: Improvement Components: Query Processor Affects Versions: 0.7.0 Reporter: John Sichi WHERE str_col like '%XYZ%' is very fast because the pattern matching code is special-cased. However, WHERE str_col rlike '(?i)%XYZ%' is very slow because it goes through the generic Java pattern matching. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.