hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Renuka Be <renunalin...@gmail.com>
Subject Re: Query in column name
Date Thu, 18 Jun 2015 10:11:04 GMT
Hi 김영우,

Thanks for your reply. It work for me.

Regards,
Renuka N

On Thu, Jun 18, 2015 at 4:31 AM, 김영우 <warwithin@gmail.com> wrote:

> If you are running Hive .13+, use *backticks*.
>
> {quote}
> > create table x (`col name` string);
> No rows affected (0.148 seconds)
> > select `col name` from x;
>
> {quote}
>
> You can refer to Hive wiki for details,
> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL
>
> HTH,
> Youngwoo
>
> On Thu, Jun 18, 2015 at 2:14 PM, Renuka Be <renunalinibe@gmail.com> wrote:
>
>> Hi Folks,
>>
>> I have tried column name like (Order Details) with space, it cause error.
>> Is there any way to mention column name with sapce.
>>
>> Regards,
>> Renuka N
>>
>
>

Mime
View raw message