Query 004a6c5b9995eb48:8891c99000000000
Query (id=004a6c5b9995eb48:8891c99000000000):
Summary:
Session ID: 2849a3d4b36e8cee:df9d96534d8c41ac
Session Type: BEESWAX
Start Time: 2026-09-23 05:57:01.633443000
End Time: 2026-09-23 05:57:01.640167000
Query Type: DML
Query State: FINISHED
Query Status: OK
Impala Version: impalad version 3.2.0-cdh6.3.2 RELEASE (build 1bb9836227301b839a32c6bc230e35439d5984ac)
User: root
Connected User: root
Delegated User:
Network Address: 172.19.5.216:34548
Default Db: default
Sql Statement: INSERT overwrite TABLE educator.event_data_impala_tmp SELECT event_name,count(1) as impala_count,date_time FROM educator.t_event WHERE date_time ='2026-09-22' GROUP BY event_name,date_time
Coordinator: hadoop001:22000
Query Options (set by configuration): CLIENT_IDENTIFIER=Impala Shell v3.2.0-cdh6.3.2 (1bb9836) built on Fri Nov 8 07:22:06 PST 2019
Query Options (set by configuration and planner): NUM_NODES=1,NUM_SCANNER_THREADS=1,RUNTIME_FILTER_MODE=0,MT_DOP=0,CLIENT_IDENTIFIER=Impala Shell v3.2.0-cdh6.3.2 (1bb9836) built on Fri Nov 8 07:22:06 PST 2019
Plan:
----------------
Max Per-Host Resource Reservation: Memory=1.94MB Threads=1
Per-Host Resource Estimates: Memory=10MB
Codegen disabled by planner
Analyzed query: SELECT event_name, count(*) impala_count, date_time FROM
educator.t_event WHERE date_time = '2026-09-22' GROUP BY event_name, date_time
F00:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
| Per-Host Resources: mem-estimate=10.00MB 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
|
01:AGGREGATE [FINALIZE]
| output: count(*)
| 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: 01(GETNEXT), 00(OPEN)
|
00:SCAN HDFS [educator.t_event]
partition predicates: date_time = '2026-09-22'
partitions=0/2317 files=0 size=0B
stored statistics:
table: rows=11759979 size=235.14MB
partitions: 0/0 rows=unavailable
columns: all
extrapolated-rows=disabled max-scan-range-rows=0
mem-estimate=0B mem-reservation=0B thread-reservation=0
tuple-ids=0 row-size=34B cardinality=0
in pipelines: 00(GETNEXT)
----------------
Estimated Per-Host Mem: 10485803
Per Host Min Memory Reservation: hadoop001:22000(1.94 MB)
Request Pool: root.root
Admission result: Admitted immediately
Cluster Memory Admitted: 10.00 MB
ExecSummary:
Operator #Hosts Avg Time Max Time #Rows Est. #Rows Peak Mem Est. Peak Mem Detail
-----------------------------------------------------------------------------------------------------------
F00:HDFS WRITER 1 0.000ns 0.000ns 0 43.00 B
01:AGGREGATE 1 1.000ms 1.000ms 0 0 1.98 MB 10.00 MB FINALIZE
00:SCAN HDFS 1 0.000ns 0.000ns 0 0 0 0 educator.t_event
Errors:
Query Compilation: 1.734ms
- Metadata of all 2 tables cached: 266.483us (266.483us)
- Analysis finished: 637.895us (371.412us)
- Value transfer graph computed: 648.216us (10.321us)
- Single node plan created: 778.998us (130.782us)
- Distributed plan created: 790.113us (11.115us)
- Lineage info computed: 819.364us (29.251us)
- Planning finished: 1.734ms (915.377us)
Query Timeline: 105.004ms
- Query submitted: 0.000ns (0.000ns)
- Planning finished: 2.000ms (2.000ms)
- Submit for admission: 2.000ms (0.000ns)
- Completed admission: 3.000ms (1.000ms)
- Ready to start on 1 backends: 3.000ms (0.000ns)
- All 1 execution backends (1 fragment instances) started: 3.000ms (0.000ns)
- Last row fetched: 7.000ms (4.000ms)
- Released admission control resources: 7.000ms (0.000ns)
- DML data written: 7.000ms (0.000ns)
- DML Metastore update finished: 30.001ms (23.000ms)
- Request finished: 30.001ms (0.000ns)
- Unregister query: 103.004ms (73.002ms)
- AdmissionControlTimeSinceLastUpdate: 77.000ms
- ComputeScanRangeAssignmentTimer: 0.000ns
Frontend:
ImpalaServer:
- ClientFetchWaitTimer: 73.002ms
- MetastoreUpdateTimer: 23.000ms
- RowMaterializationTimer: 0.000ns
Execution Profile 004a6c5b9995eb48:8891c99000000000:(Total: 4.000ms, non-child: 0.000ns, % non-child: 0.00%)
Backend startup latencies: Count: 1, min / max: 0 / 0, 25th %-ile: 0, 50th %-ile: 0, 75th %-ile: 0, 90th %-ile: 0, 95th %-ile: 0, 99.9th %-ile: 0
Slowest backend to start up:
Per Node Peak Memory Usage: hadoop001:22000(1.99 MB)
Per Node Bytes Read: hadoop001:22000(0)
Per Node User Time: hadoop001:22000(0.000ns)
Per Node System Time: hadoop001:22000(0.000ns)
DML Stats:
Partition: Default
NumModifiedRows: 0
BytesWritten: 0
- ExchangeScanRatio: 0.00
- FiltersReceived: 0 (0)
- FinalizationTimer: 2.000ms
- FileDeletionTimer: 0.000ns
- FileMoveTimer: 0.000ns
- Overwrite/PartitionCreationTimer: 1.000ms
- InnerNodeSelectivityRatio: 0.00
- NumBackends: 1 (1)
- NumFragmentInstances: 1 (1)
- NumFragments: 1 (1)
- TotalBytesRead: 0
- TotalBytesSent: 0
- TotalCpuTime: 0.000ns
- TotalInnerBytesSent: 0
- TotalScanBytesSent: 0
Per Node Profiles:
hadoop001:22000:
- ScratchBytesRead: 0
- ScratchBytesWritten: 0
- ScratchFileUsedBytes: 0
- ScratchReads: 0 (0)
- ScratchWrites: 0 (0)
- TotalEncryptionTime: 0.000ns
- TotalReadBlockTime: 0.000ns
Averaged Fragment F00:(Total: 1.000ms, non-child: 0.000ns, % non-child: 0.00%)
split sizes: min: 0, max: 0, avg: 0, stddev: 0
completion times: min:2.000ms max:2.000ms mean: 2.000ms stddev:0.000ns
execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec
num instances: 1
- AverageThreadTokens: 0.00
- BloomFilterBytes: 0
- ExchangeScanRatio: 0.00
- PeakMemoryUsage: 1.99 MB (2082944)
- PeakReservation: 1.94 MB (2031616)
- PeakUsedReservation: 0
- PerHostPeakMemUsage: 1.99 MB (2082944)
- RowsProduced: 0 (0)
- TotalNetworkReceiveTime: 0.000ns
- TotalNetworkSendTime: 0.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 0.000ns
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 0.000ns
- TotalThreadsVoluntaryContextSwitches: 0 (0)
Buffer pool:
- AllocTime: 0.000ns
- CumulativeAllocationBytes: 0
- CumulativeAllocations: 0 (0)
- PeakReservation: 0
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 0
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- ReservationLimit: 0
- SystemAllocTime: 0.000ns
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
Fragment Instance Lifecycle Timings:
- ExecTime: 0.000ns
- ExecTreeExecTime: 0.000ns
- OpenTime: 0.000ns
- ExecTreeOpenTime: 0.000ns
- PrepareTime: 1.000ms
- ExecTreePrepareTime: 1.000ms
HdfsTableSink:
- BytesWritten: 0
- CompressTimer: 0.000ns
- EncodeTimer: 0.000ns
- FilesCreated: 0 (0)
- FinalizePartitionFileTimer: 0.000ns
- HdfsWriteTimer: 0.000ns
- PartitionsCreated: 0 (0)
- PeakMemoryUsage: 0
- RowsInserted: 0 (0)
AGGREGATION_NODE (id=1):(Total: 1.000ms, non-child: 1.000ms, % non-child: 100.00%)
- PeakMemoryUsage: 1.98 MB (2074752)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
GroupingAggregator 0:
- BuildTime: 0.000ns
- GetResultsTime: 0.000ns
- HTResizeTime: 0.000ns
- HashBuckets: 0 (0)
- LargestPartitionPercent: 0 (0)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 1.97 MB (2066560)
- PeakReservation: 1.94 MB (2031616)
- PeakUsedReservation: 0
- RowsRepartitioned: 0 (0)
- RowsReturned: 0 (0)
- SpilledPartitions: 0 (0)
Buffer pool:
- AllocTime: 0.000ns
- CumulativeAllocationBytes: 256.00 KB (262144)
- CumulativeAllocations: 4 (4)
- PeakReservation: 1.94 MB (2031616)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 256.00 KB (262144)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- SystemAllocTime: 0.000ns
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
HDFS_SCAN_NODE (id=0):
- AverageHdfsReadThreadConcurrency: 0.00
- AverageScannerThreadConcurrency: 0.00
- BytesRead: 0
- BytesReadDataNodeCache: 0
- BytesReadLocal: 0
- BytesReadRemoteUnexpected: 0
- BytesReadShortCircuit: 0
- CachedFileHandlesHitCount: 0 (0)
- CachedFileHandlesMissCount: 0 (0)
- CollectionItemsRead: 0 (0)
- DataCacheHitBytes: 0
- DataCacheHitCount: 0 (0)
- DataCacheMissBytes: 0
- DataCacheMissCount: 0 (0)
- DataCachePartialHitCount: 0 (0)
- MaterializeTupleTime(*): 0.000ns
- MaxCompressedTextFileLength: 0
- NumDisksAccessed: 0 (0)
- NumScannerThreadMemUnavailable: 0 (0)
- NumScannerThreadReservationsDenied: 0 (0)
- NumScannerThreadsStarted: 0 (0)
- PeakMemoryUsage: 0
- PeakScannerThreadConcurrency: 0 (0)
- PerReadThreadRawHdfsThroughput: 0.00 /sec
- RemoteScanRanges: 0 (0)
- RowBatchBytesEnqueued: 0
- RowBatchQueueGetWaitTime: 0.000ns
- RowBatchQueuePeakMemoryUsage: 0
- RowBatchQueuePutWaitTime: 0.000ns
- RowBatchesEnqueued: 0 (0)
- RowsRead: 0 (0)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- ScanRangesComplete: 0 (0)
- ScannerIoWaitTime: 0.000ns
- ScannerThreadWorklessLoops: 0 (0)
- ScannerThreadsInvoluntaryContextSwitches: 0 (0)
- ScannerThreadsTotalWallClockTime: 0.000ns
- ScannerThreadsSysTime: 0.000ns
- ScannerThreadsUserTime: 0.000ns
- ScannerThreadsVoluntaryContextSwitches: 0 (0)
- TotalRawHdfsOpenFileTime(*): 0.000ns
- TotalRawHdfsReadTime(*): 0.000ns
- TotalReadThroughput: 0.00 /sec
Buffer pool:
- AllocTime: 0.000ns
- CumulativeAllocationBytes: 0
- CumulativeAllocations: 0 (0)
- PeakReservation: 0
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 0
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- ReservationLimit: 0
- SystemAllocTime: 0.000ns
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
Fragment F00:
Instance 004a6c5b9995eb48:8891c99000000000 (host=hadoop001:22000):(Total: 1.000ms, non-child: 0.000ns, % non-child: 0.00%)
Last report received time: 2026-09-23 05:57:01.638
Fragment Instance Lifecycle Event Timeline: 1.000ms
- Prepare Finished: 1.000ms (1.000ms)
- Open Finished: 1.000ms (0.000ns)
- First Batch Produced: 1.000ms (0.000ns)
- First Batch Sent: 1.000ms (0.000ns)
- ExecInternal Finished: 1.000ms (0.000ns)
- AverageThreadTokens: 0.00
- BloomFilterBytes: 0
- ExchangeScanRatio: 0.00
- PeakMemoryUsage: 1.99 MB (2082944)
- PeakReservation: 1.94 MB (2031616)
- PeakUsedReservation: 0
- PerHostPeakMemUsage: 1.99 MB (2082944)
- RowsProduced: 0 (0)
- TotalNetworkReceiveTime: 0.000ns
- TotalNetworkSendTime: 0.000ns
- TotalStorageWaitTime: 0.000ns
- TotalThreadsInvoluntaryContextSwitches: 0 (0)
- TotalThreadsTotalWallClockTime: 0.000ns
- TotalThreadsSysTime: 0.000ns
- TotalThreadsUserTime: 0.000ns
- TotalThreadsVoluntaryContextSwitches: 0 (0)
Buffer pool:
- AllocTime: 0.000ns
- CumulativeAllocationBytes: 0
- CumulativeAllocations: 0 (0)
- PeakReservation: 0
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 0
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- ReservationLimit: 0
- SystemAllocTime: 0.000ns
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
Fragment Instance Lifecycle Timings:
- ExecTime: 0.000ns
- ExecTreeExecTime: 0.000ns
- OpenTime: 0.000ns
- ExecTreeOpenTime: 0.000ns
- PrepareTime: 1.000ms
- ExecTreePrepareTime: 1.000ms
HdfsTableSink:
- BytesWritten: 0
- CompressTimer: 0.000ns
- EncodeTimer: 0.000ns
- FilesCreated: 0 (0)
- FinalizePartitionFileTimer: 0.000ns
- HdfsWriteTimer: 0.000ns
- PartitionsCreated: 0 (0)
- PeakMemoryUsage: 0
- RowsInserted: 0 (0)
AGGREGATION_NODE (id=1):(Total: 1.000ms, non-child: 1.000ms, % non-child: 100.00%)
ExecOption: Codegen Disabled: disabled due to optimization hints
Node Lifecycle Event Timeline: 1.000ms
- Open Started: 1.000ms (1.000ms)
- Open Finished: 1.000ms (0.000ns)
- First Batch Requested: 1.000ms (0.000ns)
- First Batch Returned: 1.000ms (0.000ns)
- Last Batch Returned: 1.000ms (0.000ns)
- Closed: 1.000ms (0.000ns)
- PeakMemoryUsage: 1.98 MB (2074752)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
GroupingAggregator 0:
- BuildTime: 0.000ns
- GetResultsTime: 0.000ns
- HTResizeTime: 0.000ns
- HashBuckets: 0 (0)
- LargestPartitionPercent: 0 (0)
- MaxPartitionLevel: 0 (0)
- NumRepartitions: 0 (0)
- PartitionsCreated: 16 (16)
- PeakMemoryUsage: 1.97 MB (2066560)
- PeakReservation: 1.94 MB (2031616)
- PeakUsedReservation: 0
- RowsRepartitioned: 0 (0)
- RowsReturned: 0 (0)
- SpilledPartitions: 0 (0)
Buffer pool:
- AllocTime: 0.000ns
- CumulativeAllocationBytes: 256.00 KB (262144)
- CumulativeAllocations: 4 (4)
- PeakReservation: 1.94 MB (2031616)
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 256.00 KB (262144)
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- SystemAllocTime: 0.000ns
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns
HDFS_SCAN_NODE (id=0):
Hdfs split stats (<volume id>:<# splits>/<split lengths>):
ExecOption: Codegen Disabled: disabled due to optimization hints, Codegen enabled: 0 out of 0
Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0%
Node Lifecycle Event Timeline: 1.000ms
- Open Started: 1.000ms (1.000ms)
- Open Finished: 1.000ms (0.000ns)
- First Batch Requested: 1.000ms (0.000ns)
- First Batch Returned: 1.000ms (0.000ns)
- Last Batch Returned: 1.000ms (0.000ns)
- Closed: 1.000ms (0.000ns)
- InitialRangeActualReservation: 0 (Number of samples: 0)
- InitialRangeIdealReservation: 0 (Number of samples: 0)
- ParquetCompressedBytesReadPerColumn: 0 (Number of samples: 0)
- ParquetUncompressedBytesReadPerColumn: 0 (Number of samples: 0)
- AverageHdfsReadThreadConcurrency: 0.00
- AverageScannerThreadConcurrency: 0.00
- BytesRead: 0
- BytesReadDataNodeCache: 0
- BytesReadLocal: 0
- BytesReadRemoteUnexpected: 0
- BytesReadShortCircuit: 0
- CachedFileHandlesHitCount: 0 (0)
- CachedFileHandlesMissCount: 0 (0)
- CollectionItemsRead: 0 (0)
- DataCacheHitBytes: 0
- DataCacheHitCount: 0 (0)
- DataCacheMissBytes: 0
- DataCacheMissCount: 0 (0)
- DataCachePartialHitCount: 0 (0)
- MaterializeTupleTime(*): 0.000ns
- MaxCompressedTextFileLength: 0
- NumDisksAccessed: 0 (0)
- NumScannerThreadMemUnavailable: 0 (0)
- NumScannerThreadReservationsDenied: 0 (0)
- NumScannerThreadsStarted: 0 (0)
- PeakMemoryUsage: 0
- PeakScannerThreadConcurrency: 0 (0)
- PerReadThreadRawHdfsThroughput: 0.00 /sec
- RemoteScanRanges: 0 (0)
- RowBatchBytesEnqueued: 0
- RowBatchQueueGetWaitTime: 0.000ns
- RowBatchQueuePeakMemoryUsage: 0
- RowBatchQueuePutWaitTime: 0.000ns
- RowBatchesEnqueued: 0 (0)
- RowsRead: 0 (0)
- RowsReturned: 0 (0)
- RowsReturnedRate: 0
- ScanRangesComplete: 0 (0)
- ScannerIoWaitTime: 0.000ns
- ScannerThreadWorklessLoops: 0 (0)
- ScannerThreadsInvoluntaryContextSwitches: 0 (0)
- ScannerThreadsTotalWallClockTime: 0.000ns
- ScannerThreadsSysTime: 0.000ns
- ScannerThreadsUserTime: 0.000ns
- ScannerThreadsVoluntaryContextSwitches: 0 (0)
- TotalRawHdfsOpenFileTime(*): 0.000ns
- TotalRawHdfsReadTime(*): 0.000ns
- TotalReadThroughput: 0.00 /sec
Buffer pool:
- AllocTime: 0.000ns
- CumulativeAllocationBytes: 0
- CumulativeAllocations: 0 (0)
- PeakReservation: 0
- PeakUnpinnedBytes: 0
- PeakUsedReservation: 0
- ReadIoBytes: 0
- ReadIoOps: 0 (0)
- ReadIoWaitTime: 0.000ns
- ReservationLimit: 0
- SystemAllocTime: 0.000ns
- WriteIoBytes: 0
- WriteIoOps: 0 (0)
- WriteIoWaitTime: 0.000ns