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
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
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:
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