Addressing serialization errors

Resolve serialization errors in query plans by adjusting table properties or contacting support.

Condition

Queries fail with errors, for example:
org.apache.hadoop.ipc.RpcException: RPC response exceeds maximum data length.

Cause

Specific table properties, such as impala_intermediate_stats_chunk, can cause serialization issues in query plans.

Remedy

  1. DESCRIBE FORMATTED <table_name>;
    Check if the impala_intermediate_stats_chunk property exists for a table by running the above command.
  2. SET hive.plan.mapwork.serialization.skip.properties=impala_intermediate_stats_chunk.*;
    If the property exists, set the above parameter in the Beeline prompt to resolve the issue.
  3. If the impala_intermediate_stats_chunk property does not exist, contact Cloudera support.