Query ac450713a0b17d3c:9ab7ed8f00000000
Status: OK
----------------
Max Per-Host Resource Reservation: Memory=5.94MB Threads=3
Per-Host Resource Estimates: Memory=36MB
WARNING: The following tables have potentially corrupt table statistics.
Drop and re-compute statistics to resolve this problem.
educator.t_event
Analyzed query: SELECT event_name, count(*) impala_count, date_time FROM
educator.t_event WHERE date_time = '2025-06-17' GROUP BY event_name, date_time
F01:PLAN FRAGMENT [HASH(event_name,date_time)] hosts=1 instances=1
| Per-Host Resources: mem-estimate=10.05MB mem-reservation=1.94MB thread-reservation=1
WRITE TO HDFS [educator.event_data_impala_tmp, OVERWRITE=true]
| partitions=1
| mem-estimate=43B mem-reservation=0B thread-reservation=0
|
03:AGGREGATE [FINALIZE]
| output: count:merge(*)
| group by: event_name, date_time
| mem-estimate=10.00MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
| tuple-ids=1 row-size=42B cardinality=0
| in pipelines: 03(GETNEXT), 00(OPEN)
|
02:EXCHANGE [HASH(event_name,date_time)]
| mem-estimate=46.32KB mem-reservation=0B thread-reservation=0
| tuple-ids=1 row-size=42B cardinality=0
| in pipelines: 00(GETNEXT)
|
F00:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
Per-Host Resources: mem-estimate=26.00MB mem-reservation=4.00MB thread-reservation=2
01:AGGREGATE [STREAMING]
| output: count(*)
| group by: event_name, date_time
| mem-estimate=10.00MB mem-reservation=2.00MB spill-buffer=64.00KB thread-reservation=0
| tuple-ids=1 row-size=42B cardinality=0
| in pipelines: 00(GETNEXT)
|
00:SCAN HDFS [educator.t_event, RANDOM]
partition predicates: date_time = '2025-06-17'
partitions=1/1916 files=1 size=1.06MB
stored statistics:
table: rows=11759979 size=235.14MB
partitions: 1/1 rows=0
columns: all
extrapolated-rows=disabled max-scan-range-rows=11759979
mem-estimate=16.00MB mem-reservation=2.00MB thread-reservation=1
tuple-ids=0 row-size=34B cardinality=0
in pipelines: 00(GETNEXT)
----------------