SelectHiveQL with Avro output doesn't handle complex types

Hive supports table columns of complex type, such as Arrays, Structs, Maps, etc. However when using SelectHiveQL with Avro output, the result set is not being converted correctly and an error occurs.

This is a fundamental issue with the way SelectHiveQL attempts to create an Avro schema without having seen any of the rows, since the sub-types of complex items cannot be determined from the SQL type alone.