Query (id=44451860f00da9da:4e46a8f500000000): Summary: Session ID: 3f4673c0877483bf:37098a4976c83ca8 Session Type: HIVESERVER2 HiveServer2 Protocol Version: V6 Start Time: 2023-10-22 08:33:48.956069000 End Time: 2023-10-22 08:33:48.988978000 Duration: 32.909ms (32909 us) Query Type: QUERY Query State: EXCEPTION Impala Query State: ERROR Query Status: Unable to open scanner for node with id '0' for Kudu table 'impala::member.qyexternaluserdetailinfo_new': Invalid argument: No such column: shopnick Impala Version: impalad version 4.3.0-RELEASE RELEASE (build 056a9cc26f40cd491b52f5fa80d73646680ac13e) User: root Connected User: root Delegated User: Network Address: 192.168.134.132:36242 Default Db: member Sql Statement: select count(1) from member.qyexternaluserdetailinfo_new where ( mainshopnick = "xxxxx" and ownercorpid in ("xxxxx", "") and shoptype not in ("35", "56") and isDelete = 0 and thirdnick != "" and thirdnick is not null ) Coordinator: bigdata-test01:27000 Query Options (set by configuration): TIMEZONE=Asia/Shanghai,CLIENT_IDENTIFIER=Impala Shell v4.3.0-RELEASE (056a9cc) built on Mon Oct 9 09:58:17 CST 2023,USE_LOCAL_TZ_FOR_UNIX_TIMESTAMP_CONVERSIONS=1,CONVERT_LEGACY_HIVE_PARQUET_UTC_TIMESTAMPS=1 Query Options (set by configuration and planner): MT_DOP=0,TIMEZONE=Asia/Shanghai,CLIENT_IDENTIFIER=Impala Shell v4.3.0-RELEASE (056a9cc) built on Mon Oct 9 09:58:17 CST 2023,SPOOL_QUERY_RESULTS=0,USE_LOCAL_TZ_FOR_UNIX_TIMESTAMP_CONVERSIONS=1,CONVERT_LEGACY_HIVE_PARQUET_UTC_TIMESTAMPS=1,MINMAX_FILTER_THRESHOLD=0.5,MINMAX_FILTERING_LEVEL=PAGE Plan: ---------------- Max Per-Host Resource Reservation: Memory=0B Threads=3 Per-Host Resource Estimates: Memory=10MB WARNING: The following tables are missing relevant table and/or column statistics. member.qyexternaluserdetailinfo_new Analyzed query: SELECT count(*) FROM member.qyexternaluserdetailinfo_new WHERE (mainshopnick = 'xxxxx' AND ownercorpid IN ('xxxxx', '') AND shoptype NOT IN ('35', '56') AND isDelete = CAST(0 AS INT) AND thirdnick != '' AND thirdnick IS NOT NULL) F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 | Per-Host Resources: mem-estimate=32.00KB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | output exprs: count(*) | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 03:AGGREGATE [FINALIZE] | output: count:merge(*) | mem-estimate=16.00KB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 | tuple-ids=1 row-size=8B cardinality=1 | in pipelines: 03(GETNEXT), 01(OPEN) | 02:EXCHANGE [UNPARTITIONED] | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 | tuple-ids=1 row-size=8B cardinality=1 | in pipelines: 01(GETNEXT) | F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=3.02MB mem-reservation=0B thread-reservation=2 01:AGGREGATE | output: count(*) | mem-estimate=16.00KB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 | tuple-ids=1 row-size=8B cardinality=1 | in pipelines: 01(GETNEXT), 00(OPEN) | 00:SCAN KUDU [member.qyexternaluserdetailinfo_new] predicates: shoptype NOT IN ('35', '56'), thirdnick != '' kudu predicates: thirdnick IS NOT NULL, isDelete = CAST(0 AS INT), ownercorpid IN ('xxxxx', ''), mainshopnick = 'xxxxx' mem-estimate=3.00MB mem-reservation=0B thread-reservation=1 tuple-ids=0 row-size=32B cardinality=0 in pipelines: 00(GETNEXT) ---------------- Estimated Per-Host Mem: 10485760 Tables Missing Stats: member.qyexternaluserdetailinfo_new Request Pool: default-pool Per Host Min Memory Reservation: bigdata-test02:27000(0) bigdata-test03:27000(0) bigdata-test01:27000(0) Per Host Number of Fragment Instances: bigdata-test02:27000(1) bigdata-test03:27000(1) bigdata-test01:27000(2) Admission result: Admitted immediately Cluster Memory Admitted: 30.00 MB Executor Group: default ExecSummary: Operator #Hosts #Inst Avg Time Max Time #Rows Est. #Rows Peak Mem Est. Peak Mem Detail ------------------------------------------------------------------------------------------------------------------------------------------ F01:ROOT 1 1 0.000ns 0.000ns 0 0 03:AGGREGATE 1 1 0.000ns 0.000ns 0 1 4.00 KB 16.00 KB FINALIZE 02:EXCHANGE 1 1 0.000ns 0.000ns 0 1 0 16.00 KB UNPARTITIONED F00:EXCHANGE SENDER 3 3 0.000ns 0.000ns 16.00 KB 48.00 KB 01:AGGREGATE 3 3 0.000ns 0.000ns 0 1 16.00 KB 16.00 KB 00:SCAN KUDU 3 3 666.714us 1.000ms 0 0 16.00 KB 3.00 MB member.qyexternaluserdetailinfo_new Errors: Query Compilation: 7.732ms - Metadata of all 1 tables cached: 699.737us (699.737us) - Analysis finished: 2.649ms (1.950ms) - Authorization finished (noop): 2.773ms (123.242us) - Value transfer graph computed: 2.880ms (107.728us) - Single node plan created: 6.148ms (3.267ms) - Runtime filters computed: 6.361ms (212.830us) - Distributed plan created: 6.402ms (41.354us) - Planning finished: 7.732ms (1.329ms) Query Timeline: 111.011ms - Query submitted: 0.000ns (0.000ns) - Planning finished: 9.000ms (9.000ms) - Submit for admission: 9.000ms (0.000ns) - Completed admission: 10.001ms (1.000ms) - Ready to start on 3 backends: 10.001ms (0.000ns) - All 3 execution backends (4 fragment instances) started: 11.001ms (1.000ms) - Execution error: 33.003ms (22.002ms) - Released admission control resources: 33.003ms (0.000ns) - Rows available: 33.003ms (0.000ns) - Unregister query: 111.011ms (78.008ms) - AdmissionControlTimeSinceLastUpdate: 88.000ms - ComputeScanRangeAssignmentTimer: 0.000ns Frontend: Referenced Tables: member.qyexternaluserdetailinfo_new - ExecutorGroupsConsidered: 1 (1) Executor group 1: Verdict: Match - MemoryAsk: 30.00 MB (31457280) - MemoryMax: 8589934592.00 GB (9223372036854775807) ImpalaServer: - ClientFetchWaitTimeStats: 0.000ns (Number of samples: 0) - ClientFetchWaitTimer: 0.000ns - NumRowsFetched: 0 (0) - NumRowsFetchedFromCache: 0 (0) - RPCCount: 5 (5) - RPCReadTimer: 7.000us - RPCWriteTimer: 60.000us - RowMaterializationRate: 0 - RowMaterializationTimer: 0.000ns Execution Profile 44451860f00da9da:4e46a8f500000000: Number of filters: 0 Filter routing table: ID Src. Node Tgt. Node(s) Target type Partition filter Pending (Expected) First arrived Completed Enabled Bloom Size Est fpp Min value Max value In-list size ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Backend startup latencies: Count: 3, sum: 2ms, min / max: 0 / 1ms, 25th %-ile: 0, 50th %-ile: 1ms, 75th %-ile: 1ms, 90th %-ile: 1ms, 95th %-ile: 1ms, 99.9th %-ile: 1ms Slowest backend to start up: bigdata-test03:27000 Per Node Peak Memory Usage: bigdata-test01:27000(68.00 KB) bigdata-test03:27000(0) bigdata-test02:27000(56.00 KB) Per Node Bytes Read: bigdata-test01:27000(0) bigdata-test03:27000(0) bigdata-test02:27000(0) Per Node User Time: bigdata-test01:27000(21.531ms) bigdata-test03:27000(0.000ns) bigdata-test02:27000(21.062ms) Per Node System Time: bigdata-test01:27000(0.000ns) bigdata-test03:27000(0.000ns) bigdata-test02:27000(0.000ns) - ExchangeScanRatio: 0.00 - FiltersReceived: 0 (0) - FinalizationTimer: 0.000ns - InnerNodeSelectivityRatio: 0.00 - NumBackends: 3 (3) - NumCompletedBackends: 2 (2) - NumFragmentInstances: 4 (4) - NumFragments: 2 (2) - TotalBytesRead: 0 - TotalBytesSent: 0 - TotalCpuTime: 42.593ms - TotalInnerBytesSent: 0 - TotalScanBytesSent: 0 Per Node Profiles: bigdata-test01: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 F01: CodeGen: - CodegenCacheLookupTime: 0.000ns - CodegenCacheSaveTime: 0.000ns - CodegenCompileThreadInvoluntaryContextSwitches: 0 (0) - CodegenCompileThreadTotalWallClockTime: 0.000ns - CodegenCompileThreadSysTime: 0.000ns - CodegenCompileThreadUserTime: 0.000ns - CodegenCompileThreadVoluntaryContextSwitches: 0 (0) - CodegenInvoluntaryContextSwitches: 0 (0) - CodegenTotalWallClockTime: 20.002ms - CodegenSysTime: 0.000ns - CodegenUserTime: 20.903ms - CodegenVoluntaryContextSwitches: 1 (1) - CompileTime: 0.000ns - FunctionPruneTime: 2.000ms - InactiveTotalTime: 0.000ns - IrGenerationTime: 0.000ns - LoadTime: 0.000ns - MainThreadCodegenTime: 3.000ms - ModuleBitcodeGenTime: 0.000ns - ModuleBitcodeSize: 3.09 MB (3245240) - NumCachedFunctions: 1 (1) - NumFunctions: 1 (1) - NumInstructions: 14 (14) - OptimizationTime: 0.000ns - PeakMemoryUsage: 0 - PrepareTime: 17.001ms - TotalTime: 20.002ms Fragment F00: CodeGen: - CodegenCacheLookupTime: 1.000ms - CodegenCacheSaveTime: 0.000ns - CodegenCompileThreadInvoluntaryContextSwitches: 0 (0) - CodegenCompileThreadTotalWallClockTime: 0.000ns - CodegenCompileThreadSysTime: 0.000ns - CodegenCompileThreadUserTime: 0.000ns - CodegenCompileThreadVoluntaryContextSwitches: 0 (0) - CodegenInvoluntaryContextSwitches: 0 (0) - CodegenTotalWallClockTime: 20.002ms - CodegenSysTime: 0.000ns - CodegenUserTime: 19.998ms - CodegenVoluntaryContextSwitches: 0 (0) - CompileTime: 0.000ns - FunctionPruneTime: 2.000ms - InactiveTotalTime: 0.000ns - IrGenerationTime: 0.000ns - LoadTime: 0.000ns - MainThreadCodegenTime: 4.000ms - ModuleBitcodeGenTime: 1.000ms - ModuleBitcodeSize: 3.09 MB (3245240) - NumCachedFunctions: 22 (22) - NumFunctions: 22 (22) - NumInstructions: 422 (422) - OptimizationTime: 0.000ns - PeakMemoryUsage: 0 - PrepareTime: 16.001ms - TotalTime: 20.002ms bigdata-test03: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: CodeGen: - CodegenCacheLookupTime: 1.000ms - CodegenCacheSaveTime: 0.000ns - CodegenCompileThreadInvoluntaryContextSwitches: 0 (0) - CodegenCompileThreadTotalWallClockTime: 0.000ns - CodegenCompileThreadSysTime: 0.000ns - CodegenCompileThreadUserTime: 0.000ns - CodegenCompileThreadVoluntaryContextSwitches: 0 (0) - CodegenInvoluntaryContextSwitches: 0 (0) - CodegenTotalWallClockTime: 24.000ms - CodegenSysTime: 0.000ns - CodegenUserTime: 23.876ms - CodegenVoluntaryContextSwitches: 0 (0) - CompileTime: 0.000ns - FunctionPruneTime: 3.000ms - InactiveTotalTime: 0.000ns - IrGenerationTime: 1.000ms - LoadTime: 0.000ns - MainThreadCodegenTime: 5.000ms - ModuleBitcodeGenTime: 1.000ms - ModuleBitcodeSize: 3.09 MB (3245240) - NumCachedFunctions: 22 (22) - NumFunctions: 22 (22) - NumInstructions: 422 (422) - OptimizationTime: 0.000ns - PeakMemoryUsage: 0 - PrepareTime: 19.000ms - TotalTime: 24.000ms bigdata-test02: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: CodeGen: - CodegenCacheLookupTime: 1.000ms - CodegenCacheSaveTime: 0.000ns - CodegenCompileThreadInvoluntaryContextSwitches: 0 (0) - CodegenCompileThreadTotalWallClockTime: 0.000ns - CodegenCompileThreadSysTime: 0.000ns - CodegenCompileThreadUserTime: 0.000ns - CodegenCompileThreadVoluntaryContextSwitches: 0 (0) - CodegenInvoluntaryContextSwitches: 0 (0) - CodegenTotalWallClockTime: 20.000ms - CodegenSysTime: 0.000ns - CodegenUserTime: 19.717ms - CodegenVoluntaryContextSwitches: 0 (0) - CompileTime: 0.000ns - FunctionPruneTime: 2.000ms - InactiveTotalTime: 0.000ns - IrGenerationTime: 1.000ms - LoadTime: 0.000ns - MainThreadCodegenTime: 4.000ms - ModuleBitcodeGenTime: 1.000ms - ModuleBitcodeSize: 3.09 MB (3245240) - NumCachedFunctions: 22 (22) - NumFunctions: 22 (22) - NumInstructions: 422 (422) - OptimizationTime: 0.000ns - PeakMemoryUsage: 0 - PrepareTime: 16.000ms - TotalTime: 20.000ms Averaged Fragment F01: split sizes: min: 0, max: 0, avg: 0, stddev: 0 completion times: min:23.002ms max:23.002ms mean: 23.002ms 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: 23.002ms - ExchangeScanRatio: 0.00 - ExecutionRate: 0.00 /sec - InactiveTotalTime: 0.000ns - PeakMemoryUsage: 12.00 KB (12288) - PeakReservation: 0 - PeakUsedReservation: 0 - PerHostPeakMemUsage: 68.00 KB (69632) - 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) - TotalTime: 0.000ns Fragment Instance Lifecycle Timings: - OpenTime: 0.000ns - ExecTreeOpenTime: 0.000ns - PrepareTime: 0.000ns - ExecTreePrepareTime: 0.000ns PLAN_ROOT_SINK: - CreateResultSetTime: 0.000ns - InactiveTotalTime: 0.000ns - PeakMemoryUsage: 0 - RowsSent: 0 (0) - RowsSentRate: 0 - TotalTime: 0.000ns AGGREGATION_NODE (id=3): - InactiveTotalTime: 0.000ns - PeakMemoryUsage: 4.00 KB (4096) - RowsReturned: 0 (0) - RowsReturnedRate: 0 - TotalTime: 0.000ns NonGroupingAggregator 0: - BuildTime: 0.000ns - InactiveTotalTime: 0.000ns - PeakMemoryUsage: 4.00 KB (4096) - RowsReturned: 0 (0) - TotalTime: 0.000ns EXCHANGE_NODE (id=2): - ConvertRowBatchTime: 0.000ns - InactiveTotalTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 0 (0) - RowsReturnedRate: 0 - TotalTime: 0.000ns 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 - SystemAllocTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns Dequeue: - FirstBatchWaitTime: 0.000ns - TotalBytesDequeued: 0 - TotalGetBatchTime: 0.000ns - DataWaitTime: 0.000ns Enqueue: - DispatchTime: 0.000ns (Number of samples: 0) - DeserializeRowBatchTime: 0.000ns - TotalBatchesEnqueued: 0 (0) - TotalBatchesReceived: 0 (0) - TotalBytesReceived: 0 - TotalEarlySenders: 0 (0) - TotalEosReceived: 0 (0) - TotalHasDeferredRPCsTime: 0.000ns - TotalRPCsDeferred: 0 (0) Coordinator Fragment F01: Instance 44451860f00da9da:4e46a8f500000000 (host=bigdata-test01:27000): Last report received time: 2023-10-22 08:33:48.988 Fragment Instance Lifecycle Event Timeline: 1.000ms - Prepare Finished: 1.000ms (1.000ms) - AverageThreadTokens: 0.00 - BytesAssigned: 0 - CompletionTime: 23.002ms - ExchangeScanRatio: 0.00 - ExecutionRate: 0.00 /sec - InactiveTotalTime: 0.000ns - PeakMemoryUsage: 12.00 KB (12288) - PeakReservation: 0 - PeakUsedReservation: 0 - PerHostPeakMemUsage: 68.00 KB (69632) - 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) - TotalTime: 0.000ns Fragment Instance Lifecycle Timings: - OpenTime: 0.000ns - ExecTreeOpenTime: 0.000ns - PrepareTime: 0.000ns - ExecTreePrepareTime: 0.000ns PLAN_ROOT_SINK: - CreateResultSetTime: 0.000ns - InactiveTotalTime: 0.000ns - PeakMemoryUsage: 0 - RowsSent: 0 (0) - RowsSentRate: 0 - TotalTime: 0.000ns AGGREGATION_NODE (id=3): Node Lifecycle Event Timeline: 21.002ms - Open Started: 21.002ms (21.002ms) - InactiveTotalTime: 0.000ns - PeakMemoryUsage: 4.00 KB (4096) - RowsReturned: 0 (0) - RowsReturnedRate: 0 - TotalTime: 0.000ns NonGroupingAggregator 0: - BuildTime: 0.000ns - InactiveTotalTime: 0.000ns - PeakMemoryUsage: 4.00 KB (4096) - RowsReturned: 0 (0) - TotalTime: 0.000ns EXCHANGE_NODE (id=2): Node Lifecycle Event Timeline: 21.002ms - Open Started: 21.002ms (21.002ms) - ConvertRowBatchTime: 0.000ns - InactiveTotalTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 0 (0) - RowsReturnedRate: 0 - TotalTime: 0.000ns 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 - SystemAllocTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns Dequeue: - FirstBatchWaitTime: 0.000ns - TotalBytesDequeued: 0 - TotalGetBatchTime: 0.000ns - DataWaitTime: 0.000ns Enqueue: - DispatchTime: 0.000ns (Number of samples: 0) - DeserializeRowBatchTime: 0.000ns - TotalBatchesEnqueued: 0 (0) - TotalBatchesReceived: 0 (0) - TotalBytesReceived: 0 - TotalEarlySenders: 0 (0) - TotalEosReceived: 0 (0) - TotalHasDeferredRPCsTime: 0.000ns - TotalRPCsDeferred: 0 (0) Averaged Fragment F00 [3 instances]:(Total: 21.501ms, non-child: 20.501ms, % non-child: 95.35%) split sizes: min: 0, max: 0, avg: 0, stddev: 0 completion times: min:22.002ms max:23.002ms mean: 22.335ms stddev:471.454us execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec num instances: 3 - AverageThreadTokens: 0.00 - BytesAssigned: 0 - CompletionTime: 22.502ms - ExchangeScanRatio: 0.00 - ExecutionRate: 0.00 /sec - InactiveTotalTime: 0.000ns - PeakMemoryUsage: 56.00 KB (57344) - PeakReservation: 0 - PeakUsedReservation: 0 - PerHostPeakMemUsage: 62.00 KB (63488) - RowsProduced: 0 (0) - TotalNetworkReceiveTime: 0.000ns - TotalNetworkSendTime: 0.000ns - TotalStorageWaitTime: 1.500ms - TotalThreadsInvoluntaryContextSwitches: 0 (0) - TotalThreadsTotalWallClockTime: 24.001ms - TotalThreadsSysTime: 0.000ns - TotalThreadsUserTime: 21.296ms - TotalThreadsVoluntaryContextSwitches: 7 (7) - TotalTime: 21.501ms Fragment Instance Lifecycle Timings [3 instances]: - OpenTime: 21.001ms - ExecTreeOpenTime: 1.000ms - PrepareTime: 0.000ns - ExecTreePrepareTime: 0.000ns KrpcDataStreamSender (dst_id=2) [3 instances]: - NetworkThroughput: 0.00 /sec (Number of samples: 0) - RpcNetworkTime: 0.000ns (Number of samples: 0) - RpcRecvrTime: 0.000ns (Number of samples: 0) - EosSent: 0 (0) - InactiveTotalTime: 0.000ns - PeakMemoryUsage: 16.00 KB (16384) - RowsSent: 0 (0) - RpcFailure: 0 (0) - RpcRetry: 0 (0) - SerializeBatchTime: 0.000ns - TotalBytesSent: 0 - TotalTime: 0.000ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=1) [3 instances]:(Total: 1.000ms, non-child: 0.000ns, % non-child: 0.00%) - InactiveTotalTime: 0.000ns - PeakMemoryUsage: 16.00 KB (16384) - RowsReturned: 0 (0) - RowsReturnedRate: 0 - TotalTime: 1.000ms NonGroupingAggregator 0 [3 instances]: - BuildTime: 0.000ns - InactiveTotalTime: 0.000ns - PeakMemoryUsage: 8.00 KB (8192) - RowsReturned: 0 (0) - TotalTime: 0.000ns KUDU_SCAN_NODE (id=0) [3 instances]:(Total: 1.000ms, non-child: 1.000ms, % non-child: 100.00%) - AverageScannerThreadConcurrency: 0.00 - BytesRead: 0 - InactiveTotalTime: 0.000ns - KuduClientTime: 1.500ms - KuduRemoteScanTokens: 0 (0) - KuduScannerCfileCacheHitBytes: 0 - KuduScannerCfileCacheMissBytes: 0 - KuduScannerCpuSysTime: 0.000ns - KuduScannerCpuUserTime: 0.000ns - KuduScannerQueueDurationTime: 0.000ns - KuduScannerTotalDurationTime: 0.000ns - MaterializeTupleTime: 0.000ns - NumScannerThreadMemUnavailable: 0 (0) - NumScannerThreadsStarted: 3 (3) - PeakMemoryUsage: 16.00 KB (16384) - PeakScannerThreadConcurrency: 3 (3) - RowBatchBytesEnqueued: 0 - RowBatchQueueGetWaitTime: 0.000ns - RowBatchQueuePeakMemoryUsage: 0 - RowBatchQueuePutWaitTime: 0.000ns - RowBatchesEnqueued: 0 (0) - RowsRead: 0 (0) - RowsReturned: 0 (0) - RowsReturnedRate: 0 - ScanRangesComplete: 0 (0) - ScannerThreadsInvoluntaryContextSwitches: 0 (0) - ScannerThreadsTotalWallClockTime: 3.000ms - ScannerThreadsSysTime: 0.000ns - ScannerThreadsUserTime: 551.000us - ScannerThreadsVoluntaryContextSwitches: 3 (3) - TotalKuduScanRoundTrips: 0 (0) - TotalReadThroughput: 0.00 /sec - TotalTime: 1.000ms Fragment F00: Instance 44451860f00da9da:4e46a8f500000003 (host=bigdata-test01:27000): Last report received time: 2023-10-22 08:33:48.988 Hdfs split stats (<volume id>:<# splits>/<split lengths>): Fragment Instance Lifecycle Event Timeline: 22.002ms - Prepare Finished: 1.000ms (1.000ms) - ExecInternal Finished: 22.002ms (21.002ms) - AverageThreadTokens: 0.00 - BytesAssigned: 0 - CompletionTime: 23.002ms - ExchangeScanRatio: 0.00 - ExecutionRate: 0.00 /sec - InactiveTotalTime: 0.000ns - PeakMemoryUsage: 56.00 KB (57344) - PeakReservation: 0 - PeakUsedReservation: 0 - PerHostPeakMemUsage: 68.00 KB (69632) - RowsProduced: 0 (0) - TotalNetworkReceiveTime: 0.000ns - TotalNetworkSendTime: 0.000ns - TotalStorageWaitTime: 1.000ms - TotalThreadsInvoluntaryContextSwitches: 0 (0) - TotalThreadsTotalWallClockTime: 24.002ms - TotalThreadsSysTime: 0.000ns - TotalThreadsUserTime: 21.531ms - TotalThreadsVoluntaryContextSwitches: 8 (8) - TotalTime: 22.002ms Fragment Instance Lifecycle Timings: - OpenTime: 21.002ms - ExecTreeOpenTime: 1.000ms - PrepareTime: 0.000ns - ExecTreePrepareTime: 0.000ns KrpcDataStreamSender (dst_id=2): ExecOption: Unpartitioned Sender Codegen Disabled: not needed - NetworkThroughput: 0.00 /sec (Number of samples: 0) - RpcNetworkTime: 0.000ns (Number of samples: 0) - RpcRecvrTime: 0.000ns (Number of samples: 0) - EosSent: 0 (0) - InactiveTotalTime: 0.000ns - PeakMemoryUsage: 16.00 KB (16384) - RowsSent: 0 (0) - RpcFailure: 0 (0) - RpcRetry: 0 (0) - SerializeBatchTime: 0.000ns - TotalBytesSent: 0 - TotalTime: 0.000ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=1): Node Lifecycle Event Timeline: 22.002ms - Open Started: 21.002ms (21.002ms) - Open Finished: 22.002ms (1.000ms) - Closed: 22.002ms (0.000ns) - InactiveTotalTime: 0.000ns - PeakMemoryUsage: 16.00 KB (16384) - RowsReturned: 0 (0) - RowsReturnedRate: 0 - TotalTime: 1.000ms NonGroupingAggregator 0: ExecOption: Codegen Enabled - BuildTime: 0.000ns - InactiveTotalTime: 0.000ns - PeakMemoryUsage: 8.00 KB (8192) - RowsReturned: 0 (0) - TotalTime: 0.000ns KUDU_SCAN_NODE (id=0): Table Name: member.qyexternaluserdetailinfo_new Node Lifecycle Event Timeline: 22.002ms - Open Started: 21.002ms (21.002ms) - Open Finished: 21.002ms (0.000ns) - First Batch Requested: 21.002ms (0.000ns) - First Batch Returned: 22.002ms (1.000ms) - Last Batch Returned: 22.002ms (0.000ns) - Closed: 22.002ms (0.000ns) - AverageScannerThreadConcurrency: 0.00 - BytesRead: 0 - InactiveTotalTime: 0.000ns - KuduClientTime: 1.000ms - KuduRemoteScanTokens: 0 (0) - KuduScannerCfileCacheHitBytes: 0 - KuduScannerCfileCacheMissBytes: 0 - KuduScannerCpuSysTime: 0.000ns - KuduScannerCpuUserTime: 0.000ns - KuduScannerQueueDurationTime: 0.000ns - KuduScannerTotalDurationTime: 0.000ns - MaterializeTupleTime: 0.000ns - NumScannerThreadMemUnavailable: 0 (0) - NumScannerThreadsStarted: 3 (3) - PeakMemoryUsage: 16.00 KB (16384) - PeakScannerThreadConcurrency: 3 (3) - RowBatchBytesEnqueued: 0 - RowBatchQueueGetWaitTime: 0.000ns - RowBatchQueuePeakMemoryUsage: 0 - RowBatchQueuePutWaitTime: 0.000ns - RowBatchesEnqueued: 0 (0) - RowsRead: 0 (0) - RowsReturned: 0 (0) - RowsReturnedRate: 0 - ScanRangesComplete: 0 (0) - ScannerThreadsInvoluntaryContextSwitches: 0 (0) - ScannerThreadsTotalWallClockTime: 3.000ms - ScannerThreadsSysTime: 0.000ns - ScannerThreadsUserTime: 606.000us - ScannerThreadsVoluntaryContextSwitches: 3 (3) - TotalKuduScanRoundTrips: 0 (0) - TotalReadThroughput: 0.00 /sec - TotalTime: 1.000ms Instance 44451860f00da9da:4e46a8f500000002 (host=bigdata-test02:27000): Last report received time: 2023-10-22 08:33:48.988 Hdfs split stats (<volume id>:<# splits>/<split lengths>): Fragment Instance Lifecycle Event Timeline: 21.000ms - Prepare Finished: 0.000ns (0.000ns) - ExecInternal Finished: 21.000ms (21.000ms) - AverageThreadTokens: 0.00 - BytesAssigned: 0 - CompletionTime: 22.002ms - ExchangeScanRatio: 0.00 - ExecutionRate: 0.00 /sec - InactiveTotalTime: 0.000ns - PeakMemoryUsage: 56.00 KB (57344) - PeakReservation: 0 - PeakUsedReservation: 0 - PerHostPeakMemUsage: 56.00 KB (57344) - RowsProduced: 0 (0) - TotalNetworkReceiveTime: 0.000ns - TotalNetworkSendTime: 0.000ns - TotalStorageWaitTime: 2.000ms - TotalThreadsInvoluntaryContextSwitches: 0 (0) - TotalThreadsTotalWallClockTime: 24.000ms - TotalThreadsSysTime: 0.000ns - TotalThreadsUserTime: 21.062ms - TotalThreadsVoluntaryContextSwitches: 7 (7) - TotalTime: 21.000ms Fragment Instance Lifecycle Timings: - OpenTime: 21.000ms - ExecTreeOpenTime: 1.000ms - PrepareTime: 0.000ns - ExecTreePrepareTime: 0.000ns KrpcDataStreamSender (dst_id=2): ExecOption: Unpartitioned Sender Codegen Disabled: not needed - NetworkThroughput: 0.00 /sec (Number of samples: 0) - RpcNetworkTime: 0.000ns (Number of samples: 0) - RpcRecvrTime: 0.000ns (Number of samples: 0) - EosSent: 0 (0) - InactiveTotalTime: 0.000ns - PeakMemoryUsage: 16.00 KB (16384) - RowsSent: 0 (0) - RpcFailure: 0 (0) - RpcRetry: 0 (0) - SerializeBatchTime: 0.000ns - TotalBytesSent: 0 - TotalTime: 0.000ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=1): Node Lifecycle Event Timeline: 21.000ms - Open Started: 20.000ms (20.000ms) - Open Finished: 21.000ms (1.000ms) - Closed: 21.000ms (0.000ns) - InactiveTotalTime: 0.000ns - PeakMemoryUsage: 16.00 KB (16384) - RowsReturned: 0 (0) - RowsReturnedRate: 0 - TotalTime: 1.000ms NonGroupingAggregator 0: ExecOption: Codegen Enabled - BuildTime: 0.000ns - InactiveTotalTime: 0.000ns - PeakMemoryUsage: 8.00 KB (8192) - RowsReturned: 0 (0) - TotalTime: 0.000ns KUDU_SCAN_NODE (id=0): Table Name: member.qyexternaluserdetailinfo_new Node Lifecycle Event Timeline: 21.000ms - Open Started: 20.000ms (20.000ms) - Open Finished: 20.000ms (0.000ns) - First Batch Requested: 20.000ms (0.000ns) - First Batch Returned: 21.000ms (1.000ms) - Last Batch Returned: 21.000ms (0.000ns) - Closed: 21.000ms (0.000ns) - AverageScannerThreadConcurrency: 0.00 - BytesRead: 0 - InactiveTotalTime: 0.000ns - KuduClientTime: 2.000ms - KuduRemoteScanTokens: 0 (0) - KuduScannerCfileCacheHitBytes: 0 - KuduScannerCfileCacheMissBytes: 0 - KuduScannerCpuSysTime: 0.000ns - KuduScannerCpuUserTime: 0.000ns - KuduScannerQueueDurationTime: 0.000ns - KuduScannerTotalDurationTime: 0.000ns - MaterializeTupleTime: 0.000ns - NumScannerThreadMemUnavailable: 0 (0) - NumScannerThreadsStarted: 3 (3) - PeakMemoryUsage: 16.00 KB (16384) - PeakScannerThreadConcurrency: 3 (3) - RowBatchBytesEnqueued: 0 - RowBatchQueueGetWaitTime: 0.000ns - RowBatchQueuePeakMemoryUsage: 0 - RowBatchQueuePutWaitTime: 0.000ns - RowBatchesEnqueued: 0 (0) - RowsRead: 0 (0) - RowsReturned: 0 (0) - RowsReturnedRate: 0 - ScanRangesComplete: 0 (0) - ScannerThreadsInvoluntaryContextSwitches: 0 (0) - ScannerThreadsTotalWallClockTime: 3.000ms - ScannerThreadsSysTime: 0.000ns - ScannerThreadsUserTime: 496.000us - ScannerThreadsVoluntaryContextSwitches: 3 (3) - TotalKuduScanRoundTrips: 0 (0) - TotalReadThroughput: 0.00 /sec - TotalTime: 1.000ms Instance 44451860f00da9da:4e46a8f500000001 (host=bigdata-test03:27000): Last report received time: 2023-10-22 08:33:48.965 - BytesAssigned: 0 - CompletionTime: 22.002ms - ExecutionRate: 0.00 /sec - InactiveTotalTime: 0.000ns - TotalTime: 0.000ns