[IMPALA-2355] Impala query taking time in unregister query or on Client Fetch Wait time

• Type: New Feature
• Status: Resolved
• Priority: Minor
• Resolution: Not A Bug
• Affects Version/s: Impala 2.2.2
• Assignee: Unassigned
• Reporter: Udyan Sharma
• Created: 17/Sep/15 08:03
• Updated: 22/Sep/15 04:39
• Resolved: 22/Sep/15 04:39

Description

I am running a select query that is fetching only 3 rows but taking 15 mins to provide the resultset. I have gone through the Profile and observed that majority of the time is spend on unregister query or Client fetch wait time. I just want to deep dive to find the exact issue. Can someone please help me in the same.

Query Info

Duration: 15m, 2s
Rows Produced: 3
Bytes Streamed: 182.8 MiB
Client Fetch Wait Time: 15.0m
Client Fetch Wait Time Percentage: 100

Query Timeline

Start execution: 81.43us (81.43us)
Planning finished: 27ms (27ms)
Ready to start remote fragments: 29ms (2ms)
Remote fragments started: 724ms (694ms)
Rows available: 1.16s (440ms)
First row fetched: 1.76s (594ms)
Unregister query: 15.0m (15.0m)