You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "John Omernik (JIRA)" <ji...@apache.org> on 2015/10/12 19:43:05 UTC
[jira] [Created] (DRILL-3922) select * on json document with dot in
key name results in failure
John Omernik created DRILL-3922:
-----------------------------------
Summary: select * on json document with dot in key name results in failure
Key: DRILL-3922
URL: https://issues.apache.org/jira/browse/DRILL-3922
Project: Apache Drill
Issue Type: Bug
Components: Storage - JSON
Affects Versions: 1.1.0, 1.2.0
Reporter: John Omernik
Fix For: Future
If there is a dot in the key name of a json field, and the user issues a select * from `path/to/file.json` it will result a system error: "Unsupported Operation Exception: Field references must be singular names"
To reproduce:
{"hello":"goodbye", "yousayyes":"Isayno"}
Works fine
{"hello.yoko":"goodbye", "yousayyes":"Isayno"}
Fails.
Note, this is only if you do select * if you do select `hello.yoko` from file then it will work fine.
The select * is needed to help with data exploration.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)