hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 김영우 <warwit...@gmail.com>
Subject Re: Query in column name
Date Thu, 18 Jun 2015 08:31:31 GMT
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