You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Arina Ielchiieva (JIRA)" <ji...@apache.org> on 2017/07/10 10:30:01 UTC

[jira] [Commented] (DRILL-4264) Dots in identifier are not escaped correctly

    [ 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)