hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mahender bigdata <>
Subject Any difference between LOWER and LCASE
Date Tue, 10 May 2016 22:54:56 GMT
Hi Team,

Is there any difference between LOWER and LCASE functions in Hive. For 
one of the query, when we are using LOWER in where condition, it is 
failing to match record. When we changed to LCASE, it started matching. 
I surprised to see differences in LOWER and LCASE. Can any one know why 
there 2 function for same functionality. Is there any thing to do with 
any special or Unicode characters where Lower and LCASE differs in 


View raw message