Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive, mail # user - Hive doesn't support special characters in column name


Copy link to this message
-
Hive doesn't support special characters in column name
Zhang Xiaoyu 2013-10-08, 18:26
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 test ( user\/hive String);
create table test ( user\\/hive String);
create table test ( user/hive String);

(2)
also, although Hive does allow _ in column name, but it doesn't special
character as begging of the column name
this query fail:
create table test ( _user_hive String);
this is OK:
create table test ( "user_hive" String);

any idea?

Thanks,
Johnny
+
Nitin Pawar 2013-10-08, 19:09
+
Zhang Xiaoyu 2013-10-08, 22:29
+
Edward Capriolo 2013-10-08, 23:55