Kristine, if you have that handy, with the first topping to top.ping, can you try select * just to validate that it's failing like the data I am seeing fail? Once I get confirmation, I'll file a JIRA.
On Mon, Oct 12, 2015 at 12:12 PM, Kristine Hahn <[email protected]> wrote: > Using the donuts.json > < > https://github.com/apache/drill/blob/master/exec/java-exec/src/test/resources > > > file, I changed the first topping to top.ping and was able to query > successfully using back ticks like this: > > select `top.ping`[3].type from > > > dfs.`/Users/khahn/drill/apache-drill-1.2.0-SNAPSHOT/sample-data/donuts.json`; > > +-----------------+ > > | EXPR$0 | > > +-----------------+ > > | Powdered Sugar | > > | null | > > | null | > > | null | > > | null | > > *+-----------------+* > > 5 rows selected (0.108 seconds) > > Kristine Hahn > Sr. Technical Writer > 415-497-8107 @krishahn skype:krishahn > > > On Mon, Oct 12, 2015 at 9:45 AM, John Omernik <[email protected]> wrote: > > > I am getting some data that seems well formed, except for there are dots > in > > some of the key names. > > > > Basically, something like ip.src seems to be making it fail with a "Field > > References must be singular names" > > > > I am using the MapR Packaged Drill 1.2. > > > > > > I can prove this out with > > > > {"hello":"goodbye", "yousayyes":"isayno"} > > > > works fine but > > > > {"hello.yoko":"goodbye", "yousayyes":"isayno"} > > > > Screams loudly that there is a failure. > > > > Is there a way we could handle dots in the key name on JSON? > > > > John > > >
