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

   



  

Reply via email to