dqrun ABI version: 2.44.0 2025-12-06 03:05:06.184 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [default] storage.cpp:189: FileStorage initialized in "/home/runner/.ya/build/build_root/o4ua/005281/r3tmp/tmpXvfCKi/", temporary dir: "/home/runner/.ya/build/build_root/o4ua/005281/r3tmp/tmpXvfCKi/3239434", locks dir:"/home/runner/.ya/build/build_root/o4ua/005281/r3tmp/tmpXvfCKi/locks", files: 0, total size: 0 2025-12-06 03:05:06.190 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [generic] client.cpp:436: Connector[default] endpoint: grpcs://connector.yqv2-dev.cloud.yandex.net:50051 2025-12-06 03:05:06.205 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [http gw] yql_dns_gateway.h:85: Filled DNS resolution table based on provided configuration 2025-12-06 03:05:06.205 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [http gw] yql_dns_gateway.h:126: Started DNS table update 2025-12-06 03:05:06.209 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [DQ] interconnect_helpers.cpp:215: Start listener ::1:31337 socket: 18 2025-12-06 03:05:06.234 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [DQ] service_node.cpp:126: Starting GRPC on 31338 GRpc memory quota was set but disabled due to issues with grpc quoter, to enable it use EnableGRpcMemoryQuota option Parse SQL... Compile program... 2025-12-06 03:05:06.363 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [generic] yql_generic_settings.cpp:61: GenericConfiguration::AddCluster: name = ydb_dev, kind = YDB, database name = , database id = etnejle6hb72cdr6aqps, endpoint = { }, use tls = 1, protocol = NATIVE Run program... 2025-12-06 03:05:06.366 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [DQ] yql_dq_gateway.cpp:605: {dummy_op} OpenSession 2025-12-06 03:05:06.372 INFO dqrun(pid=3239434, tid=0x00007F84171FD640) [DQ] yql_dq_gateway.cpp:633: {dummy_op} OpenSession OK 2025-12-06 03:05:06.373 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [YT] yql_yt_io_discovery.cpp:303: {dummy_op} YtIODiscovery - finish, status: Ok 2025-12-06 03:05:06.374 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [S3] yql_s3_listing_strategy.cpp:1018: {dummy_op} [TLoggingS3ListingStrategy] Going to list request [TS3Lister] TListingRequest{.url=file://./tpc/,.Prefix=h/1/customer/,.Pattern=h/1/customer/*,.PatternType=Wildcard,.Credentials=TS3Credentials{.ServiceAccountAuth=1,.AwsUserPwd=,.AwsSigV4=}} with options TS3ListingOptions{.IsPartitionedDataset=0,.IsConcurrentListing=0} 2025-12-06 03:05:06.375 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [S3] yql_s3_listing_strategy.cpp:236: {dummy_op} [TCompositeS3ListingStrategy] Strategy successfully listed paths. Returning result: 30 objects, 0 path prefixes 2025-12-06 03:05:06.375 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [S3] yql_s3_listing_strategy.cpp:1026: {dummy_op} [TLoggingS3ListingStrategy] Listing took 0.000002s and ended with 30 entries 2025-12-06 03:05:06.375 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [S3] yql_s3_listing_strategy.cpp:1018: {dummy_op} [TLoggingS3ListingStrategy] Going to list request [TS3Lister] TListingRequest{.url=file://./tpc/,.Prefix=h/1/orders/,.Pattern=h/1/orders/*,.PatternType=Wildcard,.Credentials=TS3Credentials{.ServiceAccountAuth=1,.AwsUserPwd=,.AwsSigV4=}} with options TS3ListingOptions{.IsPartitionedDataset=0,.IsConcurrentListing=0} 2025-12-06 03:05:06.377 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [S3] yql_s3_listing_strategy.cpp:236: {dummy_op} [TCompositeS3ListingStrategy] Strategy successfully listed paths. Returning result: 30 objects, 0 path prefixes 2025-12-06 03:05:06.378 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [S3] yql_s3_listing_strategy.cpp:1026: {dummy_op} [TLoggingS3ListingStrategy] Listing took 0.000001s and ended with 30 entries 2025-12-06 03:05:06.378 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [S3] yql_s3_io_discovery.cpp:395: {dummy_op} Pattern h/1/orders/* has 30 items with total size 54575075 2025-12-06 03:05:06.379 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [S3] yql_s3_io_discovery.cpp:395: {dummy_op} Pattern h/1/customer/* has 30 items with total size 10260256 2025-12-06 03:05:06.380 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [YT] yql_yt_io_discovery.cpp:303: {dummy_op} YtIODiscovery - finish, status: Ok 2025-12-06 03:05:06.383 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [RESULT] yql_result_provider.cpp:1415: {dummy_op} RewriteIO 2025-12-06 03:05:06.415 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [RESULT] yql_result_provider.cpp:1154: {dummy_op} Setting result column order: [(c_count->c_count), (custdist->custdist)] 2025-12-06 03:05:06.440 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [S3] yql_s3_dq_integration.cpp:252: {dummy_op} Wrap S3ReadObject! with token: cluster:default_yq-tpc-local 2025-12-06 03:05:06.441 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [S3] yql_s3_dq_integration.cpp:252: {dummy_op} Wrap S3ReadObject! with token: cluster:default_yq-tpc-local 2025-12-06 03:05:06.441 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [DQ] yql_dq_recapture.cpp:111: {dummy_op} DqsRecapture 2025-12-06 03:05:06.447 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [S3] yql_s3_logical_opt.cpp:628: {dummy_op} ExtractMembers over DqSource with S3ParseSettings 2025-12-06 03:05:06.448 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [S3] yql_optimize.cpp:131: {dummy_op} LogicalOptimizer-ExtractMembersOverDqSource 2025-12-06 03:05:06.448 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [S3] yql_s3_logical_opt.cpp:628: {dummy_op} ExtractMembers over DqSource with S3ParseSettings 2025-12-06 03:05:06.448 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [S3] yql_optimize.cpp:131: {dummy_op} LogicalOptimizer-ExtractMembersOverDqSource 2025-12-06 03:05:06.455 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [S3] yql_s3_logical_opt.cpp:434: {dummy_op} Will read from S3 60 files with total size 64835331 bytes 2025-12-06 03:05:06.458 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [S3] yql_optimize.cpp:131: {dummy_op} PhysicalOptimizer-TrimReadWorld 2025-12-06 03:05:06.465 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [S3] yql_s3_logical_opt.cpp:434: {dummy_op} Will read from S3 60 files with total size 64835331 bytes 2025-12-06 03:05:06.466 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [S3] yql_optimize.cpp:131: {dummy_op} PhysicalOptimizer-TrimReadWorld 2025-12-06 03:05:06.469 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [S3] yql_s3_logical_opt.cpp:434: {dummy_op} Will read from S3 60 files with total size 64835331 bytes 2025-12-06 03:05:06.470 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsPhy-BuildStageWithSourceWrap 2025-12-06 03:05:06.470 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsPhy-BuildStageWithSourceWrap 2025-12-06 03:05:06.475 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsLogical-RewriteEquiJoin 2025-12-06 03:05:06.484 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsPhy-BuildFlatmapStage 2025-12-06 03:05:06.491 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsPhy-BuildJoin 2025-12-06 03:05:06.497 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsPhy-PushExtractMembersToStage 2025-12-06 03:05:06.507 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsLogical-RewriteAggregate 2025-12-06 03:05:06.511 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsLogical-RewriteAggregate 2025-12-06 03:05:06.515 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsLogical-RewriteAggregate 2025-12-06 03:05:06.523 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsPhy-PushCombineToStage 2025-12-06 03:05:06.527 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsLogical-RewriteAggregate 2025-12-06 03:05:06.531 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsLogical-RewriteAggregate 2025-12-06 03:05:06.540 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsPhy-BuildShuffleStage 2025-12-06 03:05:06.545 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsPhy-PushExtractMembersToStage 2025-12-06 03:05:06.552 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsPhy-BuildFlatmapStage 2025-12-06 03:05:06.558 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsLogical-RewriteAggregate 2025-12-06 03:05:06.562 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsLogical-RewriteAggregate 2025-12-06 03:05:06.566 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsLogical-RewriteAggregate 2025-12-06 03:05:06.571 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsPhy-PushCombineToStage 2025-12-06 03:05:06.576 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsLogical-RewriteAggregate 2025-12-06 03:05:06.581 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsLogical-RewriteAggregate 2025-12-06 03:05:06.592 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsPhy-BuildShuffleStage 2025-12-06 03:05:06.597 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsPhy-BuildSortStage 2025-12-06 03:05:06.609 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [RESULT] yql_result_provider.cpp:771: {dummy_op} ResPull 2025-12-06 03:05:06.622 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [core] yql_linear_checker.cpp:210: {dummy_op} Scanned 0 static linear types 2025-12-06 03:05:06.623 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [core exec] yql_execution.cpp:61: {dummy_op} Begin, root #213985 2025-12-06 03:05:06.623 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [core exec] yql_execution.cpp:74: {dummy_op} Collect unused nodes for root #213985, status: Ok 2025-12-06 03:05:06.623 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [core exec] yql_execution.cpp:630: {dummy_op} Node #209739 finished execution 2025-12-06 03:05:06.623 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [core exec] yql_execution.cpp:647: {dummy_op} Node #209739 created 0 trackable nodes: 2025-12-06 03:05:06.623 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [core exec] yql_execution.cpp:630: {dummy_op} Node #213973 finished execution 2025-12-06 03:05:06.623 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [core exec] yql_execution.cpp:647: {dummy_op} Node #213973 created 0 trackable nodes: 2025-12-06 03:05:06.631 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [core dq] dq_opt_build.cpp:482: {dummy_op/#213983/#213995} Enabled wide channels for stage with logical id = 211658 2025-12-06 03:05:06.631 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [core dq] dq_opt_build.cpp:482: {dummy_op/#213983/#213995} Enabled wide channels for stage with logical id = 211864 2025-12-06 03:05:06.634 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [core dq] dq_opt_build.cpp:482: {dummy_op/#213983/#213995} Enabled wide channels for stage with logical id = 212648 2025-12-06 03:05:06.637 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [core dq] dq_opt_build.cpp:482: {dummy_op/#213983/#213995} Enabled wide channels for stage with logical id = 213465 2025-12-06 03:05:06.640 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [core dq] dq_opt_build.cpp:482: {dummy_op/#213983/#213995} Enabled wide channels for stage with logical id = 213864 2025-12-06 03:05:06.643 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [core dq] dq_opt_build.cpp:482: {dummy_op/#213983/#213995} Enabled wide channels for stage with logical id = 213876 2025-12-06 03:05:06.723 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [core dq] yql_dq_exectransformer.cpp:379: {dummy_op/#213983/#213995} Setting block status for stage #211658 to Full 2025-12-06 03:05:06.723 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [core dq] yql_dq_exectransformer.cpp:379: {dummy_op/#213983/#213995} Setting block status for stage #211864 to Partial 2025-12-06 03:05:06.724 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [core dq] yql_dq_exectransformer.cpp:379: {dummy_op/#213983/#213995} Setting block status for stage #212648 to None 2025-12-06 03:05:06.725 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [core dq] yql_dq_exectransformer.cpp:379: {dummy_op/#213983/#213995} Setting block status for stage #213465 to None 2025-12-06 03:05:06.727 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [core dq] yql_dq_exectransformer.cpp:379: {dummy_op/#213983/#213995} Setting block status for stage #213864 to None 2025-12-06 03:05:06.729 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [core dq] yql_dq_exectransformer.cpp:379: {dummy_op/#213983/#213995} Setting block status for stage #213876 to None 2025-12-06 03:05:06.730 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [core dq] yql_dq_exectransformer.cpp:379: {dummy_op/#213983/#213995} Setting block status for stage #213964 to None 2025-12-06 03:05:06.740 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [core exec] yql_execution.cpp:519: {dummy_op} Register async execution for node #213983 2025-12-06 03:05:06.740 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [core exec] yql_execution.cpp:89: {dummy_op} Finish, output #213985, status: Async 2025-12-06 03:05:06.743 INFO dqrun(pid=3239434, tid=0x00007F8441D33640) [DQ] executer_actor.cpp:157: {dummy_op} Trying to allocate 7 workers [EnableComputeActor=1] 2025-12-06 03:05:06.746 INFO dqrun(pid=3239434, tid=0x00007F8442838640) [DQ] executer_actor.cpp:415: {dummy_op} 7 workers allocated 2025-12-06 03:05:11.225 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [core exec] yql_execution.cpp:135: {dummy_op} Completed async execution for node #213983 2025-12-06 03:05:11.225 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [DQ] yql_dq_exectransformer.cpp:1526: {dummy_op} Execution Pull complete, duration: 4.601751s 2025-12-06 03:05:11.225 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [core exec] yql_execution.cpp:155: {dummy_op} State is ExecutionComplete after apply async changes for node #213983 2025-12-06 03:05:11.225 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [core exec] yql_execution.cpp:61: {dummy_op} Begin, root #213985 2025-12-06 03:05:11.225 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [core exec] yql_execution.cpp:74: {dummy_op} Collect unused nodes for root #213985, status: Ok 2025-12-06 03:05:11.225 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [core exec] yql_execution.cpp:630: {dummy_op} Node #213984 finished execution 2025-12-06 03:05:11.226 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [core exec] yql_execution.cpp:647: {dummy_op} Node #213984 created 0 trackable nodes: 2025-12-06 03:05:11.226 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [core exec] yql_execution.cpp:630: {dummy_op} Node #213985 finished execution 2025-12-06 03:05:11.226 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [core exec] yql_execution.cpp:647: {dummy_op} Node #213985 created 0 trackable nodes: 2025-12-06 03:05:11.226 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [core exec] yql_execution.cpp:89: {dummy_op} Finish, output #213985, status: Ok 2025-12-06 03:05:11.226 INFO dqrun(pid=3239434, tid=0x00007F846105F380) [core exec] yql_execution.cpp:95: {dummy_op} Creating finalizing transformer, output #213985 Getting results... Done