Mailing-List: contact issues-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Sun, 7 May 2017 06:37:04 +0000 (UTC)
From: "Lefty Leverenz (JIRA)" <jira@apache.org>
To: issues@hive.apache.org
Message-ID: <JIRA.12786322.1427488061000.145225.1494139024307@Atlassian.JIRA>
In-Reply-To: <JIRA.12786322.1427488061000@Atlassian.JIRA>
References: <JIRA.12786322.1427488061000@Atlassian.JIRA> <JIRA.12786322.1427488061807@jira-lw-us.apache.org>
Subject: [jira] [Commented] (HIVE-10120) Disallow create table with
 dot/colon in column name
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
archived-at: Sun, 07 May 2017 06:37:10 -0000


    [ https://issues.apache.org/jira/browse/HIVE-10120?page=3Dcom.atlassian=
.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D1599=
9703#comment-15999703 ]=20

Lefty Leverenz commented on HIVE-10120:
---------------------------------------

Thanks for offering to do the documentation, [~dmarkovitz].  It's long over=
due.

> Disallow create table with dot/colon in column name
> ---------------------------------------------------
>
>                 Key: HIVE-10120
>                 URL: https://issues.apache.org/jira/browse/HIVE-10120
>             Project: Hive
>          Issue Type: Improvement
>          Components: Parser
>            Reporter: Pengcheng Xiong
>            Assignee: Pengcheng Xiong
>              Labels: TODOC1.2
>             Fix For: 1.2.0
>
>         Attachments: HIVE-10120.01.patch, HIVE-10120.02.patch
>
>
> Since we don't allow users to query column names with dot in the middle s=
uch as emp.no, don't allow users to create tables with such columns that ca=
nnot be queried. Fix the documentation to reflect this fix.
> Here is an example. Consider this table:
> {code}
> CREATE TABLE a (`emp.no` string);
> select `emp.no` from a; fails with this message:
> FAILED: RuntimeException java.lang.RuntimeException: cannot find field em=
p from [0:emp.no]
> {code}
> The hive documentation needs to be fixed:
> {code}
>  (https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL) se=
ems to  indicate that any Unicode character can go between the backticks in=
 the select statement, but it doesn=E2=80=99t like the dot/colon or even se=
lect * when there is a column that has a dot/colon.=20
> {code}


--
This message was sent by Atlassian JIRA
(v6.3.15#6346)