Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (nike.apache.org: domain of sanjiv.is.on@gmail.com
 designates 74.125.82.44 as permitted sender)
MIME-Version: 1.0
Reply-To: sanjiv.is.on@gmail.com
In-Reply-To: 
 <CAAKG=6feEk9zEPcmmQmPe3QXep9m-HxqG6HopFy4q2MN0K2V4A@mail.gmail.com>
References: 
 <CAAKG=6feEk9zEPcmmQmPe3QXep9m-HxqG6HopFy4q2MN0K2V4A@mail.gmail.com>
From: "@Sanjiv Singh" <sanjiv.is.on@gmail.com>
Date: Wed, 1 Apr 2015 19:14:39 +0530
Message-ID: 
 <CAAef+M5JyKLok_QuVHTz+sai7++yKLgnb+7fqt64h9_X6Kr9cw@mail.gmail.com>
Subject: Re: CamelCase using InitCap Function in Hive 0.13
To: "user@hive.apache.org" <user@hive.apache.org>
Content-Type: multipart/alternative; boundary=f46d044289e8e342bd0512a9eb71

--f46d044289e8e342bd0512a9eb71
Content-Type: text/plain; charset=UTF-8

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 <vivek.veeramani87@gmail.com
> 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
>

--f46d044289e8e342bd0512a9eb71
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><br><div>Available in build <strong class=3D""></strong>
                <span id=3D"fixfor-val" class=3D"">
                                            <span style=3D"height:auto" cla=
ss=3D"" id=3D"fixVersions-field">
                                                            <a href=3D"http=
s://issues.apache.org/jira/browse/HIVE/fixforversion/12329363" title=3D"1.1=
.0 ">1.1.0</a></span><br><br></span></div><div>JIRA :=C2=A0 <a href=3D"http=
s://issues.apache.org/jira/browse/HIVE-3405">https://issues.apache.org/jira=
/browse/HIVE-3405</a><br><br><br><br clear=3D"all"><div class=3D"gmail_extr=
a"><div><div><div dir=3D"ltr">Regards<br>Sanjiv Singh<br>Mob :=C2=A0 +091 9=
990-447-339<br><br></div></div></div>
<br><div class=3D"gmail_quote">On Wed, Apr 1, 2015 at 6:24 PM, vivek veeram=
ani <span dir=3D"ltr">&lt;<a href=3D"mailto:vivek.veeramani87@gmail.com" ta=
rget=3D"_blank">vivek.veeramani87@gmail.com</a>&gt;</span> wrote:<br><block=
quote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1=
px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">Hi,<div><br></=
div><div>I&#39;m a relatively new user to Hive and was trying to format a c=
olumn of String datatype from Uppercase to Camel-case. I could see the INIT=
CAP() 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 s=
hows an invalid function error, and the show functions does not list the fu=
nction. I&#39;m running Hive 0.13. Is there any setting I need to enable th=
is?=C2=A0</div><div><br></div><div>Please advice what needs to be done in o=
rder to use this function.<span><font color=3D"#888888"><br clear=3D"all"><=
div><br></div>-- <br><div><div dir=3D"ltr">Thanks in advance,<br>Vivek Veer=
amani<br><br><br>cell : +91-9632 975 975<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 +91=
-9895 277 101</div></div>
</font></span></div></div>
</blockquote></div><br></div></div></div>

--f46d044289e8e342bd0512a9eb71--