Re: Hive doesn't support special characters in column name

2013-10-08 Thread Edward Capriolo
It is fairly common not to allow variable names to begin with an _. Also many frameworks like thrift and protobuf have similar rules. Compilers have similar rules as well. It is not going to be an easy change to make, spaces are bad for sure. It is probably easier to write some code to map special

Re: Hive doesn't support special characters in column name

2013-10-08 Thread Zhang Xiaoyu
Thanks, Nitin, If I modify the antlr file to allow column name accept those special characters. What side effect potentially could be ? Will it possible break the query parsing? Johnny On Tue, Oct 8, 2013 at 12:09 PM, Nitin Pawar wrote: > In hive the column names are restricted by alpha-numeric

Re: Hive doesn't support special characters in column name

2013-10-08 Thread Nitin Pawar
In hive the column names are restricted by alpha-numeric and _ (and not beginning with _) Why it was done ? For my understanding, to avoid the unnecessary complexity in query parsing or grammer building. hive dev will have definite answer :) On Tue, Oct 8, 2013 at 11:56 PM, Zhang Xiaoyu wrote:

Hive doesn't support special characters in column name

2013-10-08 Thread Zhang Xiaoyu
Hi, The columns in my Hive table had better include some special characters like / # - However, I found Hive doesn't allow it, and doesn't allow using \ as escape character. all below query fail (1) create table test ( "user\/hive" String); create table test ( "user\\/hive" String); create table