Details
-
Bug
-
Status: Open
-
Trivial
-
Resolution: Unresolved
-
0.10.0
-
None
-
None
Description
Hive's like operator seems to be case sensitive.
See https://github.com/apache/hive/blob/trunk/ql/src/java/org/apache/hadoop/hive/ql/udf/UDFLike.java#L164
However, MySQL's like operator is case insensitive. I don't have other DB's (like PostgreSQL) installed and handy but I am guessing their LIKE is case insensitive as well.