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. >
