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 functionality


/MS

Reply via email to