I have a insert statement that works when I do insert into an uncompressed ORC table but when I insert it into a ORC compressed Zlib it throws a vertex error.. is there any way around this?
Here is the error attached
Answer by David Young · Dec 03, 2016 at 06:29 PM
Have you tried other compression like Snappy:
hive> CREATE TABLE SQ4
> ( KPARTint,
> row format delimited
> fields terminated by ','
> stored as orc
> tblproperties ("orc.compress"="SNAPPY",
Create Compressed avro Hive table 1 Answer