I have written one Avro ser/des library for Hive to read/write Avro binary data file, which does not contain the Avro schema. And I copied this library into $HIVE/lib.
When I query the Hive external table, which uses my customized ser/des library, (e.g., select * from user_avro), it works as expected.
However if I insert data into that Hive external table like "INSERT OVERWRITE TABLE user_avro SELECT * FROM user), it complains that the my customized ser/des class cannot be found.
This output difference from Hive console is that the second one is launching MapReduce job.
Does anyone know where I need to copy this customized ser/des library except $HIVE/lib?
Many thanks in advance.