[DRILL-603] Query with single Count(Distinct) and Group-By hangs

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Assignee: Unassigned
• Reporter: Aman Sinha
• Created: 30/Apr/14 01:37
• Updated: 31/Jul/14 06:33
• Resolved: 20/May/14 17:40

Description

Following query hangs :
select count(distinct l_orderkey) from cp.`tpch/lineitem.parquet` group by l_partksy;

No errors are shown the log. The last few entries in the log are as follows:
18:31:11.850 [BitServer-1] DEBUG o.a.d.exec.work.foreman.QueryManager - New fragment status was provided to Foreman of memory_use: 1920000
batches_completed: 1
records_completed: 11919
state: FINISHED
data_processed: 0
handle {
query_id

{ part1: 6663191588966647760 part2: -7786394921952230089 }

major_fragment_id: 2
minor_fragment_id: 3
}
running_time: 219806000

18:31:11.851 [WorkManager-2] DEBUG o.a.d.e.w.f.NonRootStatusReporter - Sending status change message message to remote node: memory_use: 0
batches_completed: 0
records_completed: 0
state: RUNNING
data_processed: 0
handle {
query_id

{ part1: 6663191588966647760 part2: -7786394921952230089 }

major_fragment_id: 1
minor_fragment_id: 3
}
running_time: 1398821471850886000

18:31:11.852 [BitServer-1] DEBUG o.a.d.exec.work.foreman.QueryManager - New fragment status was provided to Foreman of memory_use: 0
batches_completed: 0
records_completed: 0
state: RUNNING
data_processed: 0
handle {
query_id

{ part1: 6663191588966647760 part2: -7786394921952230089 }

major_fragment_id: 1
minor_fragment_id: 3
}
running_time: 1398821471850886000