By saying "OTHER DATABASES" you are implying that all other databases agree on implementation.
I could not find the SQL official spec but anecdotally it seems this is not the case. http://stackoverflow.com/questions/153944/is-sql-syntax-case-sensitive With hive you have like and rlike to chose from so pick your poison :) hive> describe function extended like; OK like(str, pattern) - Checks if str matches pattern Example: > SELECT a.* FROM srcpart a WHERE a.hr like '%2' LIMIT 1; 27 val_27 2008-04-08 12 Time taken: 0.222 seconds hive> describe function extended rlike; OK str rlike regexp - Returns true if str matches regexp and false otherwise Synonyms: regexp Example: > SELECT 'fb' rlike '.*' FROM src LIMIT 1; true Time taken: 0.081 seconds hive> On 5/14/12, Keith Wiley <kwi...@keithwiley.com> wrote: > On Apr 4, 2012, at 06:40 , John Omernik wrote: > >> I think the like statement should be changed to be case-insensitive to >> match it's function in other DBMS Thoughts? > > Out of curiosity, was there any activity on this issue? I see John's > original post in the archives (~5wks ago) with no followups. I'm generally > curious about HiveQL's similarities and differences w.r.t. other SQL > environments, so questions like this are of interest to me as well. > > Cheers! > > ________________________________________________________________________________ > Keith Wiley kwi...@keithwiley.com keithwiley.com > music.keithwiley.com > > "I do not feel obliged to believe that the same God who has endowed us with > sense, reason, and intellect has intended us to forgo their use." > -- Galileo Galilei > ________________________________________________________________________________ > >
