You are mixing INTs with FLOATs in the list.. 25.42, << float 37.29, << float 10 << int
Change 10 to 10.0 -----Original Message----- From: Paul Rogers [mailto:[email protected]] Sent: Monday, June 11, 2018 8:48 PM To: [email protected] Subject: Re: UnsupportedOperationException: Unsupported type LIST [EXTERNAL EMAIL] Hi Divya, Drill will use a (non-repeated) List if it sees a 2D or higher array. Looks like the "Coordinates" field is a 2D array, so Drill will use a List. That the List type is unsupported means that, somewhere else in Drill, there is an operator that does not support the List type. That is actually not very surprising; the List type was a late addition that is not fully supported everywhere. Can you tell from the stack trace in the Drill log which operator is failing? Thanks, - Paul On Monday, June 11, 2018, 10:31:57 AM PDT, Kunal Khatua <[email protected]> wrote: I'm wondering if this JIRA is related the issue you are facing: https://urldefense.proofpoint.com/v2/url?u=https-3A__issues.apache.org_jira_browse_DRILL-2D2241&d=DwICaQ&c=zUO0BtkCe66yJvAZ4cAvZg&r=SpeiLeBTifecUrj1SErsTRw4nAqzMxT043sp_gndNeI&m=2SXuHFWVceRYagCWm_62ubIVkJl2r6Q69vFYz_u418g&s=9P8QWNkIqz3Itg-3LKAGXJZR0fz2dZJjWxtKxCWc_tk&e= On 6/11/2018 9:44:32 AM, Kunal Khatua <[email protected]> wrote: Can you share the stack trace as well? On 6/11/2018 3:12:07 AM, Divya Gehlot <[email protected]> wrote: Hi , I am trying to convert the complex json format to Parquet and I am getting below erro : SYSTEM ERROR: UnsupportedOperationException: Unsupported type LIST Fragment 0:0 JSON File format as below : { "results":[ { "_id":"5b1a3374fb4365076b4d48a8", "Session":"5b1a3369000000001200080d", "Gateway":"02422d207f0b", "Device":234, "Client":0, "Category":2555, "LastUpdate":1528443567, "Coordinates":[ [ 0, 0, 0 ], [ 25.42, 37.29, 10 ], [ 25.42, 37.29, 10 ], [ 25.42, 37.29, 10 ], [ 25.42, 37.29, 19 ], [ 25.43, 37.3, 37 ], [ 25.43, 37.3, 46 ], [ 25.43, 37.3, 46 ] ], "Start":1528443753, "End":1528443878, "Plan":{ "id":11, "name":"Level 49" } }, { "_id":"5b1a3170fb4365076b4", "Session":"5b1a315e0000000012000", "Gateway":"02422d207f0b", "Device":153, "Client":0, "Category":0, "LastUpdate":1528443869, "Coordinates":[ [ 0, 0, 0 ], [ 28.48, 38.88, 11 ], [ 28.48, 38.88, 22 ], [ 28.49, 38.89, 34 ], [ 28.49, 38.89, 47 ], [ 28.49, 38.89, 48 ], [ 0, 0, 0 ], [ 26.54, 32.83, 11 ], [ 26.54, 32.83, 23 ], [ 26.54, 32.83, 23 ], [ 26.54, 32.83, 10 ], [ 26.54, 32.83, 21 ], [ 26.55, 32.84, 30 ], [ 26.55, 32.84, 40 ], [ 26.55, 32.84, 51 ], [ 26.55, 32.84, 61 ], [ 26.55, 32.84, 72 ], [ 26.55, 32.84, 83 ], [ 26.55, 32.84, 83 ], [ 0, 0, 1 ], [ 28.48, 38.88, 11 ], [ 28.48, 38.88, 11 ], [ 28.48, 38.88, 20 ], [ 26.54, 32.83, 28 ], [ 27.19, 34.85, 37 ], [ 26.55, 32.84, 47 ], [ 27.19, 34.85, 58 ], [ 27.19, 34.85, 68 ], [ 27.19, 34.85, 78 ], [ 26.55, 32.84, 87 ], [ 26.55, 32.84, 97 ], [ 26.55, 32.84, 106 ], [ 26.55, 32.84, 107 ], [ 26.54, 32.83, 10 ], [ 26.54, 32.83, 21 ], [ 26.54, 32.83, 21 ], [ 0, 0, 0 ], [ 26.54, 32.83, 9 ], [ 26.54, 32.83, 18 ], [ 26.55, 32.84, 27 ], [ 26.55, 32.84, 27 ] ], "Start":1528443230, "End":1528443869, "Plan":{ "id":11, "name":"Level 49" } } ], "total":46 } 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.
