drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Arina Ielchiieva (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-4264) Dots in identifier are not escaped correctly
Date Mon, 10 Jul 2017 10:30:01 GMT

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

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 [JSON|https://stackoverflow.com/questions/2577172/how-to-get-json-objects-value-if-its-name-contains-dots].
Can we support table[“1.2.3”] 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? Given that these names come from
JSON, can we use Javascript syntax (table[“1.2.3”])? 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 contain dots and
when trying to select them, Drill throws the following error:
> Error: SYSTEM ERROR: UnsupportedOperationException: Unhandled field reference "0.0.1";
a field reference identifier must not have the form of a qualified name
> This must be fixed since there are many json data files containing dots in some of the
keys (e.g. when specifying version numbers etc)



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

Mime
View raw message