Vivek, You can see the version in two places 1. https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-StringFunctions
string initcap(string A) Returns string, with the first letter of each word in uppercase, all other letters in lowercase. Words are delimited by whitespace. (As of Hive 1.1.0.) if you click on 1.1.0 it will open HIVE-3405 JIRA 2. if you open https://issues.apache.org/jira/browse/HIVE-3405 it also says Fix Version/s: 1.1.0 HIVE-3405 code commit is here https://github.com/apache/hive/commit/effa734360129524ac7628759cb4a8e8b5de05de On Wed, Apr 1, 2015 at 10:38 AM, vivek veeramani < [email protected]> wrote: > Thank you Sanjiv. I've reached out to our Infrastructure vendor to check > what build we're on currently and if we can get the 1.1.0 version. But was > just curious to know, is there a way we can see the build version? > > Thanks, > Vivek > > On Wed, Apr 1, 2015 at 7:14 PM, @Sanjiv Singh <[email protected]> > wrote: > >> >> Available in build 1.1.0 >> <https://issues.apache.org/jira/browse/HIVE/fixforversion/12329363> >> >> JIRA : https://issues.apache.org/jira/browse/HIVE-3405 >> >> >> >> Regards >> Sanjiv Singh >> Mob : +091 9990-447-339 >> >> >> On Wed, Apr 1, 2015 at 6:24 PM, vivek veeramani < >> [email protected]> wrote: >> >>> Hi, >>> >>> I'm a relatively new user to Hive and was trying to format a column of >>> String datatype from Uppercase to Camel-case. I could see the INITCAP() >>> function in the language manual, and also could find related notes on JIRA >>> stating it is available. But for some reason when I run my query it shows >>> an invalid function error, and the show functions does not list the >>> function. I'm running Hive 0.13. Is there any setting I need to enable >>> this? >>> >>> Please advice what needs to be done in order to use this function. >>> >>> -- >>> Thanks in advance, >>> Vivek Veeramani >>> >>> >>> cell : +91-9632 975 975 >>> +91-9895 277 101 >>> >> >> > > > -- > Thanks , > Vivek Veeramani > > > cell : +91-9632 975 975 > +91-9895 277 101 >
