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 are very slow, Intially it willl be fast and then it will be slow

Impala queries are very slow, Intially it willl be fast and then it will be slow

New Contributor
Query a34dba182ee0ccda:84446a3000000000: 0% Complete (0 out of 28796)
Query a34dba182ee0ccda:84446a3000000000: 0% Complete (0 out of 28796)
Query a34dba182ee0ccda:84446a3000000000: 39% Complete (11499 out of 28796)
Query a34dba182ee0ccda:84446a3000000000: 46% Complete (13420 out of 28796)
Query a34dba182ee0ccda:84446a3000000000: 53% Complete (15336 out of 28796)
Query a34dba182ee0ccda:84446a3000000000: 57% Complete (16578 out of 28796)
Query a34dba182ee0ccda:84446a3000000000: 57% Complete (16627 out of 28796)
Query a34dba182ee0ccda:84446a3000000000: 57% Complete (16640 out of 28796)
Query a34dba182ee0ccda:84446a3000000000: 57% Complete (16687 out of 28796)
Query a34dba182ee0ccda:84446a3000000000: 61% Complete (17848 out of 28796)
Query a34dba182ee0ccda:84446a3000000000: 62% Complete (17887 out of 28796)
Query a34dba182ee0ccda:84446a3000000000: 62% Complete (18035 out of 28796)
Query a34dba182ee0ccda:84446a3000000000: 62% Complete (18093 out of 28796)
Query a34dba182ee0ccda:84446a3000000000: 64% Complete (18643 out of 28796)
Query a34dba182ee0ccda:84446a3000000000: 65% Complete (18742 out of 28796)
Query a34dba182ee0ccda:84446a3000000000: 65% Complete (18855 out of 28796)
Query a34dba182ee0ccda:84446a3000000000: 65% Complete (18904 out of 28796)
Query a34dba182ee0ccda:84446a3000000000: 68% Complete (19837 out of 28796)
3 REPLIES 3

Re: Impala queries are very slow, Intially it willl be fast and then it will be slow

New Contributor

Any one please reply on the above situation?

Re: Impala queries are very slow, Intially it willl be fast and then it will be slow

Rising Star
Hi Venu,

Please share the query profile to check further.

Thanks
Jerry

Highlighted

Re: Impala queries are very slow, Intially it willl be fast and then it will be slow

Guru
You should provide more info, that output does not really mean anything. It can be slow just because data is too big.

As Jerry pointed out, Impala profile can help here. Please let the query finish before collecting the profile, otherwise, the profile might not be accurate.

Cheers