Yep, it fails on select *: 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) 0: jdbc:drill:zk=local> select * from dfs.`/Users/khahn/drill/apache-drill-1.2.0-SNAPSHOT/sample-data/donuts.json`; *Error: SYSTEM ERROR: UnsupportedOperationException: Field references must be singular names.* *Fragment 0:0* *[Error Id: a1c586cb-c18f-424f-8758-56adb3f540d2 on 10.250.50.31:31010 <http://10.250.50.31:31010>] (state=,code=0)* Kristine Hahn Sr. Technical Writer 415-497-8107 @krishahn skype:krishahn On Mon, Oct 12, 2015 at 10:36 AM, John Omernik <[email protected]> wrote: > 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 > > > > > >
