Hi, I am using Flume to generate events in the default flume avro output format. Bytes in avro schema are stored as array<tinyint> in Hive when I use avroserde for hive . How do I convert array<tinyint> to string to read the flume body data. I am using hive version 0.10
CREATE external TABLE flume_avro_test ROW FORMAT > SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe' > STORED AS > INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat' > OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat' > LOCATION '/testlogs/2013/11/08/17' > TBLPROPERTIES ('avro.schema.literal'='{"type":"record","name":"Event","fields":[{"name":"headers","type":{"type":"map","values":"string"}},{"name":"body","type":"bytes"}]}'); describe flume_avro_test > ; OK headers map<string,string> from deserializer body array<tinyint> from deserializer -- Deepak Subhramanian