Re: Any difference between LOWER and LCASE

2016-05-11 Thread mahender bigdata
ge- From: mahender bigdata [mailto:mahender.bigd...@outlook.com] Sent: Wednesday, May 11, 2016 1:55 AM To: user@hive.apache.org Subject: Any difference between LOWER and LCASE Hi Team, Is there any difference between LOWER and LCASE functions in Hive. For one of the query, when we are using L

RE: Any difference between LOWER and LCASE

2016-05-10 Thread Markovitz, Dudu
able to reproduce it. Thanks Dudu -Original Message- From: mahender bigdata [mailto:mahender.bigd...@outlook.com] Sent: Wednesday, May 11, 2016 1:55 AM To: user@hive.apache.org Subject: Any difference between LOWER and LCASE Hi Team, Is there any difference between LOWER and LCASE func

Any difference between LOWER and LCASE

2016-05-10 Thread mahender bigdata
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