Re: Query in column name

2015-06-18 Thread Renuka Be
Hi 김영우, Thanks for your reply. It work for me. Regards, Renuka N On Thu, Jun 18, 2015 at 4:31 AM, 김영우 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

Re: Query in column name

2015-06-18 Thread 김영우
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, Ju

Query in column name

2015-06-17 Thread Renuka Be
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