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.

Impala Queries Failing after Running long.

Impala Queries Failing after Running long.

Support team, Ther are couple of Impala queries running daily as part of a JenKins Job and are failing occassionally,with following errors.

Status: RPC Error ETIMEDOUT

here are the series of events in relevance.

 

I put a property on the Impala Side service earlier on the cloudera Manager to cover RPC Error ETIMEDOUT

But i still receive this error., below is the context to showcase the query.

 

Impala queries are Join intensive with multiple table joins.

I try to increase the Memory parameters, to make run for eg : from 35 gb to 50 GB. i am trying to find  if there are any advance look out options from Cloudera Perspective to nail down,the root cause, if it is beyond memory parameters.

1 REPLY 1

Re: Impala Queries Failing after Running long.

Rising Star
Hi,

We understand your query is failing with RPCTIMEOUT. It could be many reason which can cause timeout.

1. Could you able to check at which point query starts to fail (From Impala daemon log using query profile id)
2. Share the Query profile.

Impala will create a optimised query plan only when it is completely aware about the table stats. Please make sure you have ran "compute stats db.tablename" on all the tables used in that query.

Hope it helps. Let me know if you have any questions

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