Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Sat, 21 Nov 2015 03:23:40 +0000 (UTC)
From: Mohammad Islam <mislam77@yahoo.com.INVALID>
Reply-To: Mohammad Islam <mislam77@yahoo.com>
To: User <user@hive.apache.org>, Hive <dev@hive.apache.org>
Message-ID: <1279121024.6704733.1448076220250.JavaMail.yahoo@mail.yahoo.com>
Subject: Supporting special characters in nested column name
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_6704732_1321894346.1448076220244"
References: 
 <1279121024.6704733.1448076220250.JavaMail.yahoo.ref@mail.yahoo.com>

------=_Part_6704732_1321894346.1448076220244
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hi,Looks like Hive supports special character (unicode) with "`" in first l=
evel column names since=C2=A0Hive 0.13=C2=A0(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=C2=A0found it is throwi=
ng exception for Hive 1.1.0.I ran the following three DDLs. Looks like, spe=
cial characters are working in first level column names. But in nested leve=
l, it works in one case (starts with '_') but failed when starts with '$'.
Any idea? IS It =C2=A0a bug or feature by design.
Regards,Mohammad

hive> create table test1_mislam(a int, `$b_` int);OKTime taken: 0.036 secon=
dshive> 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 po=
sition 17 of 'int:struct<x:int,$y:int>' but '$' is found.hive>=C2=A0

=C2=A0
------=_Part_6704732_1321894346.1448076220244--