Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> LIKE Statement

John Omernik 2012-04-04, 13:40
Keith Wiley 2012-05-14, 20:36
Edward Capriolo 2012-05-14, 20:52
Keith Wiley 2012-05-14, 21:36
Copy link to this message
Re: LIKE Statement
Well the link provided isn't really about what I originally asked about.  I
have not come across a SQL implementation (Postgres, MySQL, or MSSQL are
the ones I have experience in) where LIKE was "by default" case sensitive
with wildcards.  That being said, I'm not the type to based my assertions
on my own experience.

That being said, I have understood that in other implementations
users/administrators have the option to specify whether LIKE is case
sensitive (I saw that in the posted link)  Could we have that? If we can't
agree on what other databases are doing, can we at least agree that some
other databases do it differently by default, and for organizations making
the move from a more traditional system to hive, having the option may help
their transition?

On Mon, May 14, 2012 at 4:36 PM, Keith Wiley <[EMAIL PROTECTED]> wrote:

> Thanks for the followup.
> ________________________________________________________________________________
> Keith Wiley     [EMAIL PROTECTED]     keithwiley.com
> music.keithwiley.com
> "I used to be with it, but then they changed what it was.  Now, what I'm
> with
> isn't it, and what's it seems weird and scary to me."
>                                           --  Abe (Grandpa) Simpson
> ________________________________________________________________________________