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 < johannes.schu...@gmail.com> 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 >