I've just recently started working with Impala and I'm running into an issue. If I run the following code in either the impala-shell or hue:
INSERT INTO orderdataagg_dav SELECT * FROM orderdataagg_dav_csv2;
I get this error:
Writing to table format AVRO is not supported. Use query option ALLOW_UNSUPPORTED_FORMATS to override.
What I'm trying to accomplish is moving data from a table that's Stored as Textfile to a different table that's Stored As Avro. From the Googleing I've done it looks like this is do able. So I'm wondering what I'm missing. Any help would be greatly appreciated.