My bad .. i looked up the code and hive really transforms everything to lower case.
On Wednesday, June 3, 2015 10:02 PM, Renuka Be <renunalin...@gmail.com> wrote: Hi Ankit, Thanks for your reply. I have tried as you suggested it throws below error. FAILED: ParseException line 1:21 cannot recognize input near 'as' ''CustomerId'' 'from' in selection target Query: select customerid as 'CustomerId' from Customers Regards,Renuka On Thu, Jun 4, 2015 at 12:49 AM, Ankit Bhatnagar <ank...@yahoo-inc.com> wrote: modify to say > 'CustomerId' On Wednesday, June 3, 2015 9:44 PM, Renuka Be <renunalin...@gmail.com> wrote: Hi Folks, Here is my query, select customerid as CustomerId from Customers It returns table with column name as 'customerid', ' CustomerId' in the query was not reflected into table. What shall i do to display column name as 'CustomerId'. Regards,Renuka