array in json with mixed values (int and float)

2016-07-01 Thread Scott Kinney
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 /Powe

Re: array in json with mixed values (int and float)

2016-07-01 Thread Parth Chandra
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 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" :

Re: array in json with mixed values (int and float)

2016-07-01 Thread Scott Kinney
andra 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 wrote: > When ru

Re: array in json with mixed values (int and float)

2016-07-01 Thread Scott Kinney
ubject: Re: array in json with mixed values (int and float) 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. c

Re: array in json with mixed values (int and float)

2016-07-01 Thread Parth Chandra
essly > 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: Scott Kinney > Sent: Friday, July 01, 2016 10:51 AM > To: user

Re: array in json with mixed values (int and float)

2016-07-01 Thread Abdel Hakim Deneche
e 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: