FYI. this seems to be working in 1.6, at least on the Avro data that we have.
On Wed, Mar 23, 2016 at 6:59 PM, Stefán Baxter <[email protected]> wrote: > Hi again, > > What version of Drill are you using? > > Regards, > - Stefán > > On Wed, Mar 23, 2016 at 4:49 PM, Stefán Baxter <[email protected]> > wrote: > >> Hi Johannes, >> >> As great as Drill is the Avro plugin has been a source of frustration for >> us @activitystream. >> >> We have a small UDF library [1] (apache licensed) which contains a >> function can return an array (List<String>) from Avro as a CSV list. >> >> You could use that to roll your own or provide me with a small sample and >> I can create a custom flatten function for you. >> >> The best would be to wait for a fix but this can potentially get you out >> of a rough spot. >> >> [1] https://github.com/activitystream/asdrill >> >> Regards, >> -Stefán >> >> On Wed, Mar 23, 2016 at 9:05 AM, Johannes Schulte < >> [email protected]> wrote: >> >>> Hi, >>> >>> when trying to read simple avro arrays with select flatten(array) from >>> dfs... i get the exception >>> >>> SQL Query Error: SYSTEM ERROR: ClassCastException: Cannot cast >>> org.apache.drill.exec.vector.complex.MapVector to >>> org.apache.drill.exec.vector.complex.RepeatedValueVector >>> ^ >>> >>> The type of the array is said to be <UnknownType (2,002)> >>> >>> Is this the expected behaviour? The documentation mostly talsk about json >>> and parquet complex types and i wonder if the avro storage plugin behaves >>> differently. >>> >>> Thanks, >>> >>> Johannes >>> >> >> >
