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 <j...@omernik.com> 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
>
