Impala Queries BDA on Large Tables with Snappy Compressed Files Fail with "Error communicating with impalad: TSocket read 0 bytes" (Doc ID 2100191.1)

Last updated on JANUARY 29, 2016

Applies to:

Big Data Appliance Integrated Software - Version 4.2.0 and later
Linux x86-64

Symptoms

Performing queries with Impala in the impala-shell or Hue like "SHOW TABLES, DESCRIBE TABLE ... or SELECT * FROM tables on big tables" with millions of records fail with:

Query: select * from <big-table> limit 10
Error communicating with impalad: TSocket read 0 bytes
Not connected (use CONNECT to establish a connection)
Failed to get error log: 1
Not connected (use CONNECT to establish a connection)

This is followed by the Impala daemon on the node on which the query was run crashing. After some minutes the daemon restarts automatically. It is always the impala coordinator which crashes.

The files accessed by the table contain snappy compressed files.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms