Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive vertex error when I insert into orc zlib compression

Hive vertex error when I insert into orc zlib compression

Contributor

Hi All,

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

hive-error.txt

1 REPLY 1
Highlighted

Re: Hive vertex error when I insert into orc zlib compression

New Contributor

Have you tried other compression like Snappy:

hive> CREATE TABLE SQ4

> ( KPARTint,

>KSEQint,

.

>SORTBINint,

>SORTPACK int,

>SORTCHAR string,

>S4string,

.

>S8string)

> row format delimited

> fields terminated by ','

> stored as orc

> tblproperties ("orc.compress"="SNAPPY",

> 'orc.block.size'='268435456');

Don't have an account?
Coming from Hortonworks? Activate your account here