drill-issues mailing list archives

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

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

Volodymyr Vysotskyi commented on DRILL-4264:
--------------------------------------------

[~mandoskippy], the goal of this Jira is to fix the issue which you have mentioned.
With the fix for this Jira query 
{code:sql}
select * from `test.json`;
{code}
where *test.json* is the file from Jira description (it also has dots in the field names)
will return correct result:
{noformat}
+--------------------------------------------------+--------------------------------------------------+
|                      0.0.1                       |                      0.1.2          
            |
+--------------------------------------------------+--------------------------------------------------+
| {"version":"0.0.1","date_created":"2014-03-15"}  | {"version":"0.1.2","date_created":"2014-05-21"}
 |
+--------------------------------------------------+--------------------------------------------------+
{noformat}

> Dots in identifier are not escaped correctly
> --------------------------------------------
>
>                 Key: DRILL-4264
>                 URL: https://issues.apache.org/jira/browse/DRILL-4264
>             Project: Apache Drill
>          Issue Type: Improvement
>          Components: Execution - Codegen
>            Reporter: Alex
>            Assignee: Volodymyr Vysotskyi
>              Labels: doc-impacting
>             Fix For: 1.12.0
>
>
> 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