Query (id=e24791f1aedd02db:eda26dcf00000000): DEBUG MODE WARNING: Query profile created while running a DEBUG build of Impala. Use RELEASE builds to measure query performance. Summary: Session ID: d9412ad4767cf4c9:49413936941c65a3 Session Type: HIVESERVER2 HiveServer2 Protocol Version: V6 Start Time: 2023-08-22 10:32:22.165118000 End Time: 2023-08-22 10:32:22.467882000 Duration: 302.764ms (302764 us) Query Type: QUERY Query State: FINISHED Impala Query State: FINISHED Query Status: OK Impala Version: impalad version 4.3.0-SNAPSHOT DEBUG (build 1b7b7d8f62860bcb2b44ad453ea4495ae8d9e11a) User: quanlong Connected User: quanlong Delegated User: Network Address: 127.0.0.1:41136 Default Db: default Sql Statement: select 1 Coordinator: quanlong-OptiPlex-BJ:27000 Query Options (set by configuration): TIMEZONE=PRC,CLIENT_IDENTIFIER=impala shell build version not available Query Options (set by configuration and planner): NUM_NODES=1,NUM_SCANNER_THREADS=1,RUNTIME_FILTER_MODE=OFF,MT_DOP=0,TIMEZONE=PRC,CLIENT_IDENTIFIER=impala shell build version not available,SPOOL_QUERY_RESULTS=0 Plan: ---------------- Max Per-Host Resource Reservation: Memory=0B Threads=1 Per-Host Resource Estimates: Memory=10MB Codegen disabled by planner Analyzed query: SELECT CAST(1 AS TINYINT) F00:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 | Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | output exprs: 1 | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 00:UNION constant-operands=1 mem-estimate=0B mem-reservation=0B thread-reservation=0 tuple-ids=0 row-size=1B cardinality=1 in pipelines: ---------------- Estimated Per-Host Mem: 10485760 Request Pool: default-pool Per Host Min Memory Reservation: quanlong-OptiPlex-BJ:27000(0) Per Host Number of Fragment Instances: quanlong-OptiPlex-BJ:27000(1) Admission result: Admitted as a trivial query Cluster Memory Admitted: 10.00 MB Executor Group: empty group (using coordinator only) ExecSummary: Operator #Hosts #Inst Avg Time Max Time #Rows Est. #Rows Peak Mem Est. Peak Mem Detail ------------------------------------------------------------------------------------------------- F00:ROOT 1 1 30.663us 30.663us 0 0 00:UNION 1 1 19.315us 19.315us 1 1 0 0 Errors: Query Compilation: 187.260ms - Metadata of all 0 tables cached: 13.596ms (13.596ms) - Analysis finished: 84.345ms (70.749ms) - Authorization finished (noop): 84.499ms (153.781us) - Value transfer graph computed: 105.314ms (20.815ms) - Single node plan created: 110.919ms (5.605ms) - Distributed plan created: 115.423ms (4.503ms) - Planning finished: 187.260ms (71.837ms) Query Timeline: 306.153ms - Query submitted: 125.578us (125.578us) - Planning finished: 197.022ms (196.897ms) - Submit for admission: 197.377ms (354.222us) - Completed admission: 197.591ms (214.625us) - Ready to start on 1 backends: 197.690ms (98.537us) - All 1 execution backends (1 fragment instances) started: 207.852ms (10.162ms) - Rows available: 209.102ms (1.250ms) - First row fetched: 300.799ms (91.696ms) - Last row fetched: 300.879ms (79.831us) - Released admission control resources: 302.725ms (1.845ms) - Unregister query: 306.153ms (3.427ms) - AdmissionControlTimeSinceLastUpdate: 97.000ms - ComputeScanRangeAssignmentTimer: 0.000ns Frontend: Referenced Tables: - ExecutorGroupsConsidered: 1 (1) Executor group 1: Verdict: Assign to first group because the number of nodes is 1 - MemoryMax: 8589934592.00 GB (9223372036854775807) ImpalaServer: - ClientFetchWaitTimeStats: (Avg: 91.553ms ; Min: 91.553ms ; Max: 91.553ms ; Number of samples: 1) - ClientFetchWaitTimer: 91.553ms - NumRowsFetched: 1 (1) - NumRowsFetchedFromCache: 0 (0) - RPCCount: 6 (6) - RPCReadTimer: 27.000us - RPCWriteTimer: 213.000us - RowMaterializationRate: 419.00 /sec - RowMaterializationTimer: 2.384ms Execution Profile e24791f1aedd02db:eda26dcf00000000: Backend startup latencies: Count: 1, sum: 9ms, min / max: 9ms / 9ms, 25th %-ile: 9ms, 50th %-ile: 9ms, 75th %-ile: 9ms, 90th %-ile: 9ms, 95th %-ile: 9ms, 99.9th %-ile: 9ms Slowest backend to start up: quanlong-OptiPlex-BJ:27000 Per Node Peak Memory Usage: quanlong-OptiPlex-BJ:27000(12.00 KB) Per Node Bytes Read: quanlong-OptiPlex-BJ:27000(0) Per Node User Time: quanlong-OptiPlex-BJ:27000(124.000us) Per Node System Time: quanlong-OptiPlex-BJ:27000(0.000ns) - ExchangeScanRatio: 0.00 - FiltersReceived: 0 (0) - FinalizationTimer: 0.000ns - InnerNodeSelectivityRatio: 0.00 - NumBackends: 1 (1) - NumCompletedBackends: 1 (1) - NumFragmentInstances: 1 (1) - NumFragments: 1 (1) - TotalBytesRead: 0 - TotalBytesSent: 0 - TotalCpuTime: 124.000us - TotalInnerBytesSent: 0 - TotalScanBytesSent: 0 Per Node Profiles: quanlong-OptiPlex-BJ:27000: - AdmissionSlots: 1 (1) - BloomFilterBytes: 0 - InListFilterItems: 0 (0) - ScratchBytesRead: 0 - ScratchBytesReadUseLocalDisk: 0 - ScratchBytesReadUseMem: 0 - ScratchBytesWritten: 0 - ScratchFileUsedBytes: 0 - ScratchReads: 0 (0) - ScratchReadsUseLocalDisk: 0 (0) - ScratchReadsUseMem: 0 (0) - ScratchWrites: 0 (0) - TotalEncryptionTime: 0.000ns - TotalReadBlockTime: 0.000ns - UncompressedScratchBytesWritten: 0 Buffer pool: - AllocTime: 0.000ns - CompressionTime: 0.000ns - CumulativeAllocationBytes: 0 - CumulativeAllocations: 0 (0) - EncryptionTime: 0.000ns - 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 JVM: - GcCount: 0 (0) - GcNumInfoThresholdExceeded: 0 (0) - GcNumWarnThresholdExceeded: 0 (0) - GcTimeMillis: 0 - GcTotalExtraSleepTimeMillis: 0 Fragment F00: Averaged Fragment F00:(Total: 91.830ms, non-child: 69.043us, % non-child: 0.08%) split sizes: min: 0, max: 0, avg: 0, stddev: 0 completion times: min:94.343ms max:94.343ms mean: 94.343ms 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 - BytesAssigned: 0 - CompletionTime: 94.343ms - ExchangeScanRatio: 0.00 - ExecutionRate: 0.00 /sec - InactiveTotalTime: 0.000ns - PeakMemoryUsage: 12.00 KB (12288) - PeakReservation: 0 - PeakUsedReservation: 0 - PerHostPeakMemUsage: 12.00 KB (12288) - RowsProduced: 1 (1) - TotalNetworkReceiveTime: 0.000ns - TotalNetworkSendTime: 0.000ns - TotalStorageWaitTime: 0.000ns - TotalThreadsInvoluntaryContextSwitches: 0 (0) - TotalThreadsTotalWallClockTime: 91.775ms - TotalThreadsSysTime: 0.000ns - TotalThreadsUserTime: 124.000us - TotalThreadsVoluntaryContextSwitches: 1 (1) - TotalTime: 91.830ms Fragment Instance Lifecycle Timings: - ExecTime: 91.777ms - ExecTreeExecTime: 12.733us - OpenTime: 4.811us - ExecTreeOpenTime: 1.079us - PrepareTime: 35.148us - ExecTreePrepareTime: 6.100us PLAN_ROOT_SINK:(Total: 91.742ms, non-child: 30.663us, % non-child: 0.03%) - CreateResultSetTime: 7.138us - InactiveTotalTime: 91.711ms - PeakMemoryUsage: 0 - RowsSent: 1 (1) - RowsSentRate: 10.00 /sec - TotalTime: 91.742ms UNION_NODE (id=0):(Total: 19.315us, non-child: 19.315us, % non-child: 100.00%) - InactiveTotalTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 1 (1) - RowsReturnedRate: 51.77 K/sec - TotalTime: 19.315us Coordinator Fragment F00: Instance e24791f1aedd02db:eda26dcf00000000 (host=quanlong-OptiPlex-BJ:27000): Last report received time: 2023-08-22 10:32:22.467 Fragment Instance Lifecycle Event Timeline: 92.014ms - Prepare Finished: 212.063us (212.063us) - Open Finished: 218.065us (6.002us) - First Batch Produced: 232.215us (14.150us) - First Batch Sent: 91.972ms (91.740ms) - ExecInternal Finished: 92.014ms (42.656us) - AverageThreadTokens: 0.00 - BytesAssigned: 0 - CompletionTime: 94.343ms - ExchangeScanRatio: 0.00 - ExecutionRate: 0.00 /sec - InactiveTotalTime: 0.000ns - PeakMemoryUsage: 12.00 KB (12288) - PeakReservation: 0 - PeakUsedReservation: 0 - PerHostPeakMemUsage: 12.00 KB (12288) - RowsProduced: 1 (1) - TotalNetworkReceiveTime: 0.000ns - TotalNetworkSendTime: 0.000ns - TotalStorageWaitTime: 0.000ns - TotalThreadsInvoluntaryContextSwitches: 0 (0) - TotalThreadsTotalWallClockTime: 91.775ms - TotalThreadsSysTime: 0.000ns - TotalThreadsUserTime: 124.000us - TotalThreadsVoluntaryContextSwitches: 1 (1) - TotalTime: 91.830ms Fragment Instance Lifecycle Timings: - ExecTime: 91.777ms - ExecTreeExecTime: 12.733us - OpenTime: 4.811us - ExecTreeOpenTime: 1.079us - PrepareTime: 35.148us - ExecTreePrepareTime: 6.100us PLAN_ROOT_SINK: - CreateResultSetTime: 7.138us - InactiveTotalTime: 91.711ms - PeakMemoryUsage: 0 - RowsSent: 1 (1) - RowsSentRate: 10.00 /sec - TotalTime: 91.742ms UNION_NODE (id=0): Node Lifecycle Event Timeline: 91.986ms - Open Started: 213.475us (213.475us) - Open Finished: 214.096us (621.000ns) - First Batch Requested: 219.581us (5.485us) - First Batch Returned: 231.486us (11.905us) - Last Batch Returned: 231.666us (180.000ns) - Closed: 91.986ms (91.755ms) - InactiveTotalTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 1 (1) - RowsReturnedRate: 51.77 K/sec - TotalTime: 19.315us