incubator-drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jacques Nadeau <jacq...@apache.org>
Subject Re: Doubt on Querying JSON
Date Tue, 11 Nov 2014 15:22:53 GMT
We're indeed seeing some issues with the current master (development)
branch and flatten functionality.  There a number of open bugs right now
against it.  Can you review the open bugs and see if they describe the
problem you are seeing?

thanks

On Tue, Nov 11, 2014 at 5:35 AM, mufy <mufeed.usman@gmail.com> wrote:

> I have the following.
>
> {
>         "timestamp":1415688106710,
>         "status":"OK",
>         "total":17,
>         "data":[
>                 { "volumename":"a", "actualreplication":[0,0,0],
> "InodesExceededAlarm":0, "ContainersNonLocalAlarm":0 },
>                 { "volumename":"b", "actualreplication":[0,0,0],
> "InodesExceededAlarm":0, "ContainersNonLocalAlarm":0 },
>                 { "volumename":"c", "actualreplication":[0,0,0],
> "InodesExceededAlarm":0, "ContainersNonLocalAlarm":0 }
>                ]
> }
>
> But query results are "partial".
>
> 0: jdbc:drill:zk=n67:5181> select data[0] from `1.json`;
> +------------+
> |   EXPR$0   |
> +------------+
> |
> {"volumename":"a","actualreplication":[0,0,0],"InodesExceededAlarm":0,"ContainersNonLocalAlarm":0}
> |
> +------------+
> 1 row selected (0.139 seconds)
> 0: jdbc:drill:zk=n67:5181> select data[1] from `1.json`;
> +------------+
> |   EXPR$0   |
> +------------+
> |
> {"volumename":"b","actualreplication":[0,0,0],"InodesExceededAlarm":0,"ContainersNonLocalAlarm":0}
> |
> +------------+
> 1 row selected (0.125 seconds)
>
>
>
> 0: jdbc:drill:zk=n67:5181> select * from `1.json`;
> +------------+------------+------------+------------+
> | timestamp  |   status   |   total    |    data    |
> +------------+------------+------------+------------+
> | 1415688106710 | OK         | 17         |
>
> [{"volumename":"a","actualreplication":[0,0,0],"InodesExceededAlarm":0,"ContainersNonLocalAlarm":0},{"volumename":"b","actualreplication":[0,0,0]
> |
> +------------+------------+------------+------------+
> 1 row selected (0.22 seconds)
>
>
>
> 0: jdbc:drill:zk=n67:5181> select timestamp from `1.json`;
> Query failed: Failure while parsing sql.
>
> Error: exception while executing query: Failure while executing query.
> (state=,code=0)
> 0: jdbc:drill:zk=n67:5181> select timestamp[0] from `1.json`;
> Query failed: Failure while parsing sql.
>
> Error: exception while executing query: Failure while executing query.
> (state=,code=0)
> 0: jdbc:drill:zk=n67:5181> select status[0] from `1.json`;
> +------------+
> |   EXPR$0   |
> +------------+
> Query failed: Failure while running fragment.
>
> java.lang.RuntimeException: java.sql.SQLException: Failure while
> executing query.
>     at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2514)
>     at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2148)
>     at sqlline.SqlLine.print(SqlLine.java:1809)
>     at sqlline.SqlLine$Commands.execute(SqlLine.java:3766)
>     at sqlline.SqlLine$Commands.sql(SqlLine.java:3663)
>     at sqlline.SqlLine.dispatch(SqlLine.java:889)
>     at sqlline.SqlLine.begin(SqlLine.java:763)
>     at sqlline.SqlLine.start(SqlLine.java:498)
>     at sqlline.SqlLine.main(SqlLine.java:460)
>

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