drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hao Zhu <h...@maprtech.com>
Subject Re: Doubt on Querying JSON
Date Fri, 14 Nov 2014 21:05:36 GMT
Hi Jim,

I verified this issue you mentioned on latest 0.7 build and it is fixed.

0: jdbc:drill:zk=local> select `timestamp` as newtime,flatten(data) as
> newdata from dfs.root.`/Users/hzu/Documents/sharefolder/test2/*.json`;
> +------------+------------+
> |  newtime   |  newdata   |
> +------------+------------+
> | 1415688106710 |
> {"volumename":"a","actualreplication":[0,0,0],"InodesExceededAlarm":0,"ContainersNonLocalAlarm":0}
> |
> | 1415688106710 |
> {"volumename":"b","actualreplication":[0,0,0],"InodesExceededAlarm":0,"ContainersNonLocalAlarm":0}
> |
> | 1415688106710 |
> {"volumename":"c","actualreplication":[0,0,0],"InodesExceededAlarm":0,"ContainersNonLocalAlarm":0}
> |
> | 1415688106710 |
> {"volumename":"a","actualreplication":[0,0,0],"InodesExceededAlarm":0,"ContainersNonLocalAlarm":0}
> |
> | 1415688106710 |
> {"volumename":"b","actualreplication":[0,0,0],"InodesExceededAlarm":0,"ContainersNonLocalAlarm":0}
> |
> | 1415688106710 |
> {"volumename":"c","actualreplication":[0,0,0],"InodesExceededAlarm":0,"ContainersNonLocalAlarm":0}
> |
> +------------+------------+
> 6 rows selected (0.242 seconds)

Thanks,

Hao

On Tue, Nov 11, 2014 at 3:06 PM, Jacques Nadeau <jacques@apache.org> wrote:

> On Tue, Nov 11, 2014 at 12:21 PM, Jim Bates <jbates@maprtech.com> wrote:
>
> > I had trouble with flatten extending past one wile. If you include more
> > than 1 json file in your data set it never seams to finish the command.
> In
> > my case it returned in 20 sec with one file but when the data set had two
> > files it never finiahed after 5 min so I gave up till a later release
> comes
> > along.
> >
>
> Yeah, that'll happen with nightly builds.  Give the build a few days.
> We're testing fixes now to deal with a lot of these issues.
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message