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)