had created table as such
create table foo(
) stored as orc tblproperties(“orc.compress”=”snappy”);
but when i went to populate the table using an “insert overwrite table foo select * from …” statement then i faced an error.
turns out i should have used “SNAPPY” instead of “snappy”. case matters.