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

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.20.2
• Component/s: Storage - JSON
• Assignee: Unassigned
• Reporter: James Turton
• Created: 26/Sep/22 13:42
• Updated: 26/Sep/22 13:42

Description

The query

select tbl.object['info_abc'] from dfs.tmp.`foo.json` tbl;

works on a foo.json containing

{"object": {"id": 123, "info_abc": "foo"}}

but the query

select tbl.object['info.abc'] from dfs.tmp.`foo.json` tbl;

does not work on a foo.json containing

{"object": {"id": 123, "info.abc": "foo"}}