You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "James Turton (Jira)" <ji...@apache.org> on 2022/09/26 13:43:00 UTC

[jira] [Created] (DRILL-8319) Cannot query JSON with property names containing a period '.'

James Turton created DRILL-8319:
-----------------------------------

             Summary: Cannot query JSON with property names containing a period '.'
                 Key: DRILL-8319
                 URL: https://issues.apache.org/jira/browse/DRILL-8319
             Project: Apache Drill
          Issue Type: Bug
          Components: Storage - JSON
    Affects Versions: 1.20.2
            Reporter: James Turton


The query
{code:java}
select tbl.object['info_abc'] from dfs.tmp.`foo.json` tbl;{code}
works on a foo.json containing
{noformat}
{"object": {"id": 123, "info_abc": "foo"}}{noformat}
but the query
{code:java}
select tbl.object['info.abc'] from dfs.tmp.`foo.json` tbl;{code}
does not work on a foo.json containing
{noformat}
{"object": {"id": 123, "info.abc": "foo"}}{noformat}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)