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 results are loading slowly

Highlighted

impala results are loading slowly

Contributor

Hi,

 

I am running impala on CDH5.4.3. When i query in impala-shell like select * from <tblname> the results are displaying like some records loading and waiting for some milliseconds and rest of records are loading like that 27000 records are loading like buffering. Performance is poor

I dont know whether it is the problem with cache memory or something..

Please help me out


Thanks in advance

 

3 REPLIES 3

Re: impala results are loading slowly

Rising Star

which tool do you use?

if impala-shell, you could try to use -B key.

also, you could try to play with max_result_cache_size parameter.

Highlighted

Re: impala results are loading slowly

Contributor

Hi,

I already changed the value of results_cache_max_size  from 100000 to 10000000...still same result

Highlighted

Re: impala results are loading slowly

Master Collaborator

To better suppot you with performance-related issues, we'd appreciate it if you could post the runtime profile of the slow query.

 

Please see this page on how to get the profile:

http://www.cloudera.com/content/cloudera/en/documentation/core/v5-2-x/topics/impala_explain_plan.htm...

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