The following are examples of successful INSERT-SELECT statements.
For AVRO:
CREATE TABLE myAVROTable02( id INT, avroFile DATASET STORAGE FORMAT Avro); INSERT INTO myAVROTable02 SELECT * FROM myAVROTable01;
For CSV:
CREATE TABLE MyCSVTable02( id INT, csvFile DATASET STORAGE FORMAT CSV CHARACTER SET LATIN); INSERT INTO MyCSVTable02 SELECT * FROM MyCSVTable01;