Hive query string case

Question

Is there a way to get all the types of string cases while doing this:

select count(word) from table where word="abcd"

Actually when doing this, it is not the same as this:

select count(word) from table where word="ABCD"

Answer 1

Ignoring the case in a where clause is very simple. You can, for example, convert both sides of the comparison to all caps notation:

SELECT COUNT(word) 
FROM   table 
WHERE  UPPER(word)=UPPER('ABCD')

Regardless of the capitalization used for the search term , the UPPER function makes them match as desired.