Seems like a bug to me. On Fri, Oct 10, 2014 at 6:42 AM, mufy <[email protected]> wrote:
> The below works. > > 0: jdbc:drill:zk=n67:5181> select Reservations[0].OwnerId as ID, > Reservations[0].ReservationId as RID from dfs.`aws.json`; > +------------+------------+ > | ID | RID | > +------------+------------+ > | 898107336781 | r-48a03243 | > +------------+------------+ > 1 row selected (0.217 seconds) > > > But when I dig a little deeper into my nested JSON to do a multiple column > aliasing it fails. > > > 0: jdbc:drill:zk=n67:5181> select Reservations[0].Instances[0].InstanceId > as ID, Reservations[0].Instances[0].PrivateDnsName as IP from > dfs.`aws.json`; > Query failed: Failure while running fragment. index: -4, length: 4 > (expected: range(0, 16384)) [fea47ee2-f588-4fbf-bb2b-113e25c71779] > > Error: exception while executing query: Failure while trying to get next > result batch. (state=,code=0) > > > Although I'm able to reach the elements into the nested JSON individually. > > > 0: jdbc:drill:zk=n67:5181> select Reservations[0].Instances[0].InstanceId > as ID from dfs.`aws.json`; > +------------+ > | ID | > +------------+ > | i-85d5e28e | > +------------+ > 1 row selected (0.182 seconds) > > 0: jdbc:drill:zk=n67:5181> select > Reservations[0].Instances[0].PrivateDnsName as IP from dfs.`aws.json`; > +------------+ > | IP | > +------------+ > | ip-10-253-11-180.us-west-2.compute.internal | > +------------+ > 1 row selected (0.174 seconds) > > Is it my query or a bug? >
