Re: Any difference between LOWER and LCASE

2016-05-11 Thread mahender bigdata
Thanks Dudu, looks like both of them pointing to same class. Let me check if there is any problem with data which is not visible and surprising LCASE is resolving issue but not lower. On 5/10/2016 9:43 PM, Markovitz, Dudu wrote: Hi According to documentation LCASE is a synonym for LOWER. F

RE: Any difference between LOWER and LCASE

2016-05-10 Thread Markovitz, Dudu
Hi According to documentation LCASE is a synonym for LOWER. From what I've seen in the source code, it seems right. https://github.com/apache/hive/blob/f089f2e64241592ecf8144d044bec8a0659ff422/ql/src/java/org/apache/hadoop/hive/ql/exec/FunctionRegistry.java system.registerGenericUDF("lower",