That looks promising but didn't work.

________________________________
Scott Kinney | DevOps
stem   |   m  510.282.1299
100 Rollins Road, Millbrae, California 94030

This e-mail and/or any attachments contain Stem, Inc. confidential and 
proprietary information and material for the sole use of the intended 
recipient(s). Any review, use or distribution that has not been expressly 
authorized by Stem, Inc. is strictly prohibited. If you are not the intended 
recipient, please contact the sender and delete all copies. Thank you.

________________________________________
From: Parth Chandra <pchan...@maprtech.com>
Sent: Friday, July 01, 2016 10:43 AM
To: user@drill.apache.org
Subject: Re: array in json with mixed values (int and float)

I haven't tried this myself, but setting store.json.read_numbers_as_double
to true might help.



On Fri, Jul 1, 2016 at 9:27 AM, Scott Kinney <scott.kin...@stem.com> wrote:

> When running a query on a json file via the api returns an error that i
> dont see when running the same query in the REPL.
>
> "errorMessage" : "UNSUPPORTED_OPERATION ERROR: In a list of type FLOAT8,
> encountered a value of type BIGINT. Drill does not support lists of
> different types.\n\nFile
> /PowerBladeAvahi.1.telemetry/json/telemetry_flatstore_3_2_prod-telemetry-w2-9_1.log-1437722221.json.gz\nRecord
> 1\nLine  1\nColumn  502\nField  soc\nFragment 0:0\n\n[Error Id:
> be38e1c4-b1c0-4d55-9ab1-fe4ebdc44a9e on ops-apachedrill:31010]"
>
>
> I pulled the line out of the file. There is a key 'foo': [ 99, 99.1, 99.8
> ].
> Is there a way get drill to handle this? Maybe treat all ints as floats?
>
>
> ________________________________
> Scott Kinney | DevOps
> stem <http://www.stem.com/>   |   m  510.282.1299
> 100 Rollins Road, Millbrae, California 94030
>
> This e-mail and/or any attachments contain Stem, Inc. confidential and
> proprietary information and material for the sole use of the intended
> recipient(s). Any review, use or distribution that has not been expressly
> authorized by Stem, Inc. is strictly prohibited. If you are not the
> intended recipient, please contact the sender and delete all copies. Thank
> you.
>

Reply via email to