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 <[email protected]> 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
>