Mailing-List: contact issues-help@drill.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.apache.org
Date: Mon, 10 Jul 2017 10:30:01 +0000 (UTC)
From: "Arina Ielchiieva (JIRA)" <jira@apache.org>
To: issues@drill.apache.org
Message-ID: <JIRA.12929429.1452591635000.206149.1499682601503@Atlassian.JIRA>
In-Reply-To: <JIRA.12929429.1452591635000@Atlassian.JIRA>
References: <JIRA.12929429.1452591635000@Atlassian.JIRA> <JIRA.12929429.1452591635904@jira-lw-us.apache.org>
Subject: [jira] [Commented] (DRILL-4264) Dots in identifier are not escaped
 correctly
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
archived-at: Mon, 10 Jul 2017 10:38:52 -0000


    [ https://issues.apache.org/jira/browse/DRILL-4264?page=3Dcom.atlassian=
.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D1608=
0129#comment-16080129 ]=20

Arina Ielchiieva commented on DRILL-4264:
-----------------------------------------

Some useful notes provided by [~Paul.Rogers]:

1. Escape mechanism for dots in names. (See this for how it is done in [JSO=
N|https://stackoverflow.com/questions/2577172/how-to-get-json-objects-value=
-if-its-name-contains-dots]. Can we support table[=E2=80=9C1.2.3=E2=80=9D] =
syntax in Drill?)

2. Dots in column names: Identify the issue (Drill attaches meaning to the =
dots.) Research SQL escape characters. How do other products handle this? G=
iven that these names come from JSON, can we use Javascript syntax (table[=
=E2=80=9C1.2.3=E2=80=9D])? How do we ensure current behavior does not break=
? Experiment to see what works.


> Dots in identifier are not escaped correctly
> --------------------------------------------
>
>                 Key: DRILL-4264
>                 URL: https://issues.apache.org/jira/browse/DRILL-4264
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Codegen
>            Reporter: Alex
>            Assignee: Volodymyr Vysotskyi
>
> If you have some json data like this...
> {code:javascript}
>     {
>       "0.0.1":{
>         "version":"0.0.1",
>         "date_created":"2014-03-15"
>       },
>       "0.1.2":{
>         "version":"0.1.2",
>         "date_created":"2014-05-21"
>       }
>     }
> {code}
> ... there is no way to select any of the rows since their identifiers con=
tain dots and when trying to select them, Drill throws the following error:
> Error: SYSTEM ERROR: UnsupportedOperationException: Unhandled field refer=
ence "0.0.1"; a field reference identifier must not have the form of a qual=
ified name
> This must be fixed since there are many json data files containing dots i=
n some of the keys (e.g. when specifying version numbers etc)


--
This message was sent by Atlassian JIRA
(v6.4.14#64029)