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