drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John Omernik (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-3922) select * on json document with dot in key name results in failure
Date Mon, 12 Oct 2015 17:43:05 GMT
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)

Mime
View raw message