hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mohammad Islam <>
Subject Supporting special characters in nested column name
Date Sat, 21 Nov 2015 03:23:40 GMT
Hi,Looks like Hive supports special character (unicode) with "`" in first level column names
since Hive 0.13 (HIVE-6013).Similarly does hive supports special characters in nested column
names? For example, struct<a : int , `_b`:int, `$d` :int). is supported or not?I found
it is throwing exception for Hive 1.1.0.I ran the following three DDLs. Looks like, special
characters are working in first level column names. But in nested level, it works in one case
(starts with '_') but failed when starts with '$'.
Any idea? IS It  a bug or feature by design.

hive> create table test1_mislam(a int, `$b_` int);OKTime taken: 0.036 secondshive> create
table test2_mislam(a int, c struct<x:int, `_y`:int>);
OKTime taken: 0.082 secondshive> create table test3_mislam(a int, c struct<x:int, `$y`:int>);
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.IllegalArgumentException:
Error: name expected at the position 17 of 'int:struct<x:int,$y:int>' but '$' is found.hive> 

View raw message