[ https://issues.apache.org/jira/browse/DRILL-4264?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16091346#comment-16091346 ]
Volodymyr Vysotskyi commented on DRILL-4264: -------------------------------------------- Yes, these statements are correct. Drill also supports array syntax {{b\['d.e'\]}}. I used it as an example of using field names with dots in the query. No, I meant that we are using the same [FieldReference|https://github.com/apache/drill/blob/90f43bff7a01eaaee6c8861137759b05367dfcf3/logical/src/main/java/org/apache/drill/common/expression/FieldReference.java#L40] class, but in planner we are using [checkSimpleString()|https://github.com/apache/drill/blob/90f43bff7a01eaaee6c8861137759b05367dfcf3/logical/src/main/java/org/apache/drill/common/expression/FieldReference.java#L54] method and at the execution stage we are using constructor [FieldReference()|https://github.com/apache/drill/blob/90f43bff7a01eaaee6c8861137759b05367dfcf3/logical/src/main/java/org/apache/drill/common/expression/FieldReference.java#L64] that checks input string for dots. The code does not combine the map name and nested field names. Nested field names are stored as children of the [NameSegment rootSegment|https://github.com/apache/drill/blob/90f43bff7a01eaaee6c8861137759b05367dfcf3/logical/src/main/java/org/apache/drill/common/expression/SchemaPath.java#L45] in SchemaPath (it is a superclass of FieldReference). So I propose to remove that check. > 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)