Hi Sudeesh,
Probably I was not clear in my previous email. The error is due to
accessing an array from the SELECT directly, which is not supported by
Drill. My question was, how to overcome this hurdle without using the
performance-hungry FLATTEN keyword or using the array indices (impractical
as
Hi Pradeeban,
Can you post the detailed error message?
First set the option:
> SET `exec.errors.verbose` = true;
And then run the query. The detailed output will point us to where the error
occurred.
Thank you,
Sudheesh
> On Sep 12, 2016, at 10:47 AM, Pradeeban Kathiravelu
Hi,
I have a complex json data stored in Mongo.
The data has nested arrays as shown below .
here when I try to access the geometry field in select queries, the Drill
query fails.
select camic._id, camic.type, camic.parent_id, camic.randval,
camic.creation_date, camic.object_type, camic.x,