Reply
New Contributor
Posts: 2
Registered: ‎12-09-2018

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

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)
Highlighted
New Contributor
Posts: 2
Registered: ‎12-09-2018

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

Any one please reply on the above situation?

Posts: 49
Topics: 0
Kudos: 13
Solutions: 5
Registered: ‎07-30-2018

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

Hi Venu,

Please share the query profile to check further.

Thanks
Jerry

Cloudera Employee
Posts: 832
Registered: ‎03-23-2015

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

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