[jira] [Created] (DRILL-3922) select * on json document with dot in key name results in failure

[John Omernik (JIRA)]

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)