SQL Sheet- InvalidProtocolBufferException : Protocol message was too large. May be malicious.

Problem

Running a workbook with a very long SQL query within a SQL sheet results in the below error:

Protocol message was too large. May be malicious. Use CodedInputStream.setSizeLimit() to increase the size limit.

Cause 

The IPC message length (bytes) requested by the SQL query is larger than the default value of 64 MB. When the request is larger than the specified maximum data value, the request is rejected by the server immediately.

Solution

Set the maximum IPC length to a larger value by specifying the following parameter in the Custom Properties of the job configuration and re-run the job.

ipc.maximum.data.length=134217728

The above value corresponds to a doubling of the default 64MB to 128MB.