11 and 16 are ints. 11.0 and 16.0 are floats in json. Everything in the array needs to be a float.
Sent from my iPad > On May 30, 2018, at 8:29 PM, Padma Penumarthy <[email protected]> wrote: > > [EXTERNAL EMAIL] > > > yes, that is correct. > You can try setting the option “exec.enable_union_type” for that to work with > the caveat that > union type is not fully supported in drill. > > Thanks > Padma > > >> On May 30, 2018, at 7:56 PM, Divya Gehlot <[email protected]> wrote: >> >> Hi, >> I am reading a complex json file, I am getting format doesn't support while >> reading below : >> "Coordinates":[ >> [ >> 23.53, >> 4.99, >> 11 >> ], >> [ >> 35.09, >> 7.7, >> 16 >> ] >> ] >> >> >> Error : Query execution error. Details:[ >>> UNSUPPORTED_OPERATION ERROR: In a list of type FLOAT8, encountered a value >>> of type BIGINT. Drill does not support lists of different types. >>> Line 15 >>> Column 19 >>> Field Coordinates >>> Line 15 >>> Column 19 >>> Field Coordinates >>> Line 15 >>> Column 19 >>> Field Coordinates >>> Fragment 0:0 >> >> >> If I remove the third coordinates(11,16) which is integer it works like >> charm . >> >> Does that means Drill doesn't support values of different data types in >> array list? >> >> Appreciate the help ! >> >> Thanks, >> Divya > This message may contain information that is confidential or privileged. If you are not the intended recipient, please advise the sender immediately and delete this message. See http://www.blackrock.com/corporate/en-us/compliance/email-disclaimers for further information. Please refer to http://www.blackrock.com/corporate/en-us/compliance/privacy-policy for more information about BlackRock’s Privacy Policy. For a list of BlackRock's office addresses worldwide, see http://www.blackrock.com/corporate/en-us/about-us/contacts-locations. © 2018 BlackRock, Inc. All rights reserved.
