dqrun ABI version: 2.44.0 2025-12-06 03:05:20.248 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [default] storage.cpp:189: FileStorage initialized in "/home/runner/.ya/build/build_root/o4ua/005281/r3tmp/tmplReeAQ/", temporary dir: "/home/runner/.ya/build/build_root/o4ua/005281/r3tmp/tmplReeAQ/3241241", locks dir:"/home/runner/.ya/build/build_root/o4ua/005281/r3tmp/tmplReeAQ/locks", files: 0, total size: 0 2025-12-06 03:05:20.255 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [generic] client.cpp:436: Connector[default] endpoint: grpcs://connector.yqv2-dev.cloud.yandex.net:50051 2025-12-06 03:05:20.270 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [http gw] yql_dns_gateway.h:85: Filled DNS resolution table based on provided configuration 2025-12-06 03:05:20.270 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [http gw] yql_dns_gateway.h:126: Started DNS table update 2025-12-06 03:05:20.274 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [DQ] interconnect_helpers.cpp:215: Start listener ::1:31337 socket: 18 2025-12-06 03:05:20.298 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [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:20.426 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [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:20.429 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [DQ] yql_dq_gateway.cpp:605: {dummy_op} OpenSession 2025-12-06 03:05:20.435 INFO dqrun(pid=3241241, tid=0x00007F85F7FFD640) [DQ] yql_dq_gateway.cpp:633: {dummy_op} OpenSession OK 2025-12-06 03:05:20.435 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [YT] yql_yt_io_discovery.cpp:303: {dummy_op} YtIODiscovery - finish, status: Ok 2025-12-06 03:05:20.435 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [S3] yql_s3_listing_strategy.cpp:1018: {dummy_op} [TLoggingS3ListingStrategy] Going to list request [TS3Lister] TListingRequest{.url=file://./tpc/,.Prefix=h/1/supplier/,.Pattern=h/1/supplier/*,.PatternType=Wildcard,.Credentials=TS3Credentials{.ServiceAccountAuth=1,.AwsUserPwd=,.AwsSigV4=}} with options TS3ListingOptions{.IsPartitionedDataset=0,.IsConcurrentListing=0} 2025-12-06 03:05:20.437 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [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:20.437 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [S3] yql_s3_listing_strategy.cpp:1026: {dummy_op} [TLoggingS3ListingStrategy] Listing took 0.000001s and ended with 30 entries 2025-12-06 03:05:20.437 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [S3] yql_s3_listing_strategy.cpp:1018: {dummy_op} [TLoggingS3ListingStrategy] Going to list request [TS3Lister] TListingRequest{.url=file://./tpc/,.Prefix=h/1/partsupp/,.Pattern=h/1/partsupp/*,.PatternType=Wildcard,.Credentials=TS3Credentials{.ServiceAccountAuth=1,.AwsUserPwd=,.AwsSigV4=}} with options TS3ListingOptions{.IsPartitionedDataset=0,.IsConcurrentListing=0} 2025-12-06 03:05:20.438 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [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:20.438 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [S3] yql_s3_listing_strategy.cpp:1026: {dummy_op} [TLoggingS3ListingStrategy] Listing took 0.000001s and ended with 30 entries 2025-12-06 03:05:20.438 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [S3] yql_s3_listing_strategy.cpp:1018: {dummy_op} [TLoggingS3ListingStrategy] Going to list request [TS3Lister] TListingRequest{.url=file://./tpc/,.Prefix=h/1/part/,.Pattern=h/1/part/*,.PatternType=Wildcard,.Credentials=TS3Credentials{.ServiceAccountAuth=1,.AwsUserPwd=,.AwsSigV4=}} with options TS3ListingOptions{.IsPartitionedDataset=0,.IsConcurrentListing=0} 2025-12-06 03:05:20.439 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [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:20.439 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [S3] yql_s3_listing_strategy.cpp:1026: {dummy_op} [TLoggingS3ListingStrategy] Listing took 0.000001s and ended with 30 entries 2025-12-06 03:05:20.439 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [S3] yql_s3_io_discovery.cpp:395: {dummy_op} Pattern h/1/part/* has 30 items with total size 6089692 2025-12-06 03:05:20.440 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [S3] yql_s3_io_discovery.cpp:395: {dummy_op} Pattern h/1/partsupp/* has 30 items with total size 34281114 2025-12-06 03:05:20.440 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [S3] yql_s3_io_discovery.cpp:395: {dummy_op} Pattern h/1/supplier/* has 30 items with total size 825819 2025-12-06 03:05:20.441 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [YT] yql_yt_io_discovery.cpp:303: {dummy_op} YtIODiscovery - finish, status: Ok 2025-12-06 03:05:20.443 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [RESULT] yql_result_provider.cpp:1415: {dummy_op} RewriteIO 2025-12-06 03:05:20.488 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [RESULT] yql_result_provider.cpp:1154: {dummy_op} Setting result column order: [(p_brand->p_brand), (p_type->p_type), (p_size->p_size), (supplier_cnt->supplier_cnt)] 2025-12-06 03:05:20.561 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [S3] yql_s3_dq_integration.cpp:252: {dummy_op} Wrap S3ReadObject! with token: cluster:default_yq-tpc-local 2025-12-06 03:05:20.562 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [S3] yql_s3_dq_integration.cpp:252: {dummy_op} Wrap S3ReadObject! with token: cluster:default_yq-tpc-local 2025-12-06 03:05:20.562 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [S3] yql_s3_dq_integration.cpp:252: {dummy_op} Wrap S3ReadObject! with token: cluster:default_yq-tpc-local 2025-12-06 03:05:20.563 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [DQ] yql_dq_recapture.cpp:111: {dummy_op} DqsRecapture 2025-12-06 03:05:20.571 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [S3] yql_s3_logical_opt.cpp:628: {dummy_op} ExtractMembers over DqSource with S3ParseSettings 2025-12-06 03:05:20.571 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [S3] yql_optimize.cpp:131: {dummy_op} LogicalOptimizer-ExtractMembersOverDqSource 2025-12-06 03:05:20.571 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [S3] yql_s3_logical_opt.cpp:628: {dummy_op} ExtractMembers over DqSource with S3ParseSettings 2025-12-06 03:05:20.571 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [S3] yql_optimize.cpp:131: {dummy_op} LogicalOptimizer-ExtractMembersOverDqSource 2025-12-06 03:05:20.571 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [S3] yql_s3_logical_opt.cpp:628: {dummy_op} ExtractMembers over DqSource with S3ParseSettings 2025-12-06 03:05:20.571 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [S3] yql_optimize.cpp:131: {dummy_op} LogicalOptimizer-ExtractMembersOverDqSource 2025-12-06 03:05:20.580 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [S3] yql_s3_logical_opt.cpp:434: {dummy_op} Will read from S3 90 files with total size 41196625 bytes 2025-12-06 03:05:20.583 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [S3] yql_optimize.cpp:131: {dummy_op} PhysicalOptimizer-TrimReadWorld 2025-12-06 03:05:20.590 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [S3] yql_s3_logical_opt.cpp:434: {dummy_op} Will read from S3 90 files with total size 41196625 bytes 2025-12-06 03:05:20.591 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [S3] yql_optimize.cpp:131: {dummy_op} PhysicalOptimizer-TrimReadWorld 2025-12-06 03:05:20.597 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [S3] yql_s3_logical_opt.cpp:434: {dummy_op} Will read from S3 90 files with total size 41196625 bytes 2025-12-06 03:05:20.598 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [S3] yql_optimize.cpp:131: {dummy_op} PhysicalOptimizer-TrimReadWorld 2025-12-06 03:05:20.601 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [S3] yql_s3_logical_opt.cpp:434: {dummy_op} Will read from S3 90 files with total size 41196625 bytes 2025-12-06 03:05:20.602 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsPhy-BuildStageWithSourceWrap 2025-12-06 03:05:20.602 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsPhy-BuildStageWithSourceWrap 2025-12-06 03:05:20.602 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsPhy-BuildStageWithSourceWrap 2025-12-06 03:05:20.608 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsLogical-RewriteEquiJoin 2025-12-06 03:05:20.619 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsPhy-BuildFlatmapStage 2025-12-06 03:05:20.619 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsPhy-BuildFlatmapStage 2025-12-06 03:05:20.627 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsPhy-BuildJoin 2025-12-06 03:05:20.633 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsPhy-BuildJoin 2025-12-06 03:05:20.640 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsPhy-PushExtractMembersToStage 2025-12-06 03:05:20.652 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsPhy-BuildFlatmapStage 2025-12-06 03:05:20.657 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsLogical-RewriteAggregate 2025-12-06 03:05:20.664 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsLogical-RewriteAggregate 2025-12-06 03:05:20.678 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsPhy-BuildShuffleStage 2025-12-06 03:05:20.685 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [DQ] yql_optimize.cpp:131: {dummy_op} DqsPhy-BuildSortStage 2025-12-06 03:05:20.700 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [RESULT] yql_result_provider.cpp:771: {dummy_op} ResPull 2025-12-06 03:05:20.716 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core] yql_linear_checker.cpp:210: {dummy_op} Scanned 0 static linear types 2025-12-06 03:05:20.717 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core exec] yql_execution.cpp:61: {dummy_op} Begin, root #216021 2025-12-06 03:05:20.717 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core exec] yql_execution.cpp:74: {dummy_op} Collect unused nodes for root #216021, status: Ok 2025-12-06 03:05:20.717 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core exec] yql_execution.cpp:630: {dummy_op} Node #209739 finished execution 2025-12-06 03:05:20.717 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core exec] yql_execution.cpp:647: {dummy_op} Node #209739 created 0 trackable nodes: 2025-12-06 03:05:20.717 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core exec] yql_execution.cpp:630: {dummy_op} Node #216009 finished execution 2025-12-06 03:05:20.717 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core exec] yql_execution.cpp:647: {dummy_op} Node #216009 created 0 trackable nodes: 2025-12-06 03:05:20.726 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core dq] dq_opt_build.cpp:482: {dummy_op/#216019/#216031} Enabled wide channels for stage with logical id = 214613 2025-12-06 03:05:20.726 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core dq] dq_opt_build.cpp:482: {dummy_op/#216019/#216031} Enabled wide channels for stage with logical id = 214322 2025-12-06 03:05:20.729 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core dq] dq_opt_build.cpp:482: {dummy_op/#216019/#216031} Enabled wide channels for stage with logical id = 214803 2025-12-06 03:05:20.730 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core dq] dq_opt_build.cpp:482: {dummy_op/#216019/#216031} Enabled wide channels for stage with logical id = 214655 2025-12-06 03:05:20.733 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core dq] dq_opt_build.cpp:482: {dummy_op/#216019/#216031} Enabled wide channels for stage with logical id = 215190 2025-12-06 03:05:20.737 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core dq] dq_opt_build.cpp:482: {dummy_op/#216019/#216031} Enabled wide channels for stage with logical id = 215892 2025-12-06 03:05:20.740 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core dq] dq_opt_build.cpp:482: {dummy_op/#216019/#216031} Enabled wide channels for stage with logical id = 215904 2025-12-06 03:05:20.806 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core dq] yql_dq_exectransformer.cpp:379: {dummy_op/#216019/#216031} Setting block status for stage #214613 to Partial 2025-12-06 03:05:20.806 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core dq] yql_dq_exectransformer.cpp:379: {dummy_op/#216019/#216031} Setting block status for stage #214322 to Full 2025-12-06 03:05:20.806 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core dq] yql_dq_exectransformer.cpp:379: {dummy_op/#216019/#216031} Setting block status for stage #214655 to Partial 2025-12-06 03:05:20.807 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core dq] yql_dq_exectransformer.cpp:379: {dummy_op/#216019/#216031} Setting block status for stage #214803 to None 2025-12-06 03:05:20.809 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core dq] yql_dq_exectransformer.cpp:379: {dummy_op/#216019/#216031} Setting block status for stage #215190 to None 2025-12-06 03:05:20.810 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core dq] yql_dq_exectransformer.cpp:379: {dummy_op/#216019/#216031} Setting block status for stage #215892 to None 2025-12-06 03:05:20.811 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core dq] yql_dq_exectransformer.cpp:379: {dummy_op/#216019/#216031} Setting block status for stage #215904 to None 2025-12-06 03:05:20.813 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core dq] yql_dq_exectransformer.cpp:379: {dummy_op/#216019/#216031} Setting block status for stage #216000 to None 2025-12-06 03:05:20.825 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core exec] yql_execution.cpp:519: {dummy_op} Register async execution for node #216019 2025-12-06 03:05:20.825 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core exec] yql_execution.cpp:89: {dummy_op} Finish, output #216021, status: Async 2025-12-06 03:05:20.828 INFO dqrun(pid=3241241, tid=0x00007F8622B33640) [DQ] executer_actor.cpp:157: {dummy_op} Trying to allocate 8 workers [EnableComputeActor=1] 2025-12-06 03:05:20.831 INFO dqrun(pid=3241241, tid=0x00007F8623638640) [DQ] executer_actor.cpp:415: {dummy_op} 8 workers allocated 2025-12-06 03:05:23.283 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core exec] yql_execution.cpp:135: {dummy_op} Completed async execution for node #216019 2025-12-06 03:05:23.283 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [DQ] yql_dq_exectransformer.cpp:1526: {dummy_op} Execution Pull complete, duration: 2.566505s 2025-12-06 03:05:23.403 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core exec] yql_execution.cpp:155: {dummy_op} State is ExecutionComplete after apply async changes for node #216019 2025-12-06 03:05:23.403 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core exec] yql_execution.cpp:61: {dummy_op} Begin, root #216021 2025-12-06 03:05:23.403 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core exec] yql_execution.cpp:74: {dummy_op} Collect unused nodes for root #216021, status: Ok 2025-12-06 03:05:23.406 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core exec] yql_execution.cpp:630: {dummy_op} Node #216020 finished execution 2025-12-06 03:05:23.406 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core exec] yql_execution.cpp:647: {dummy_op} Node #216020 created 0 trackable nodes: 2025-12-06 03:05:23.406 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core exec] yql_execution.cpp:630: {dummy_op} Node #216021 finished execution 2025-12-06 03:05:23.406 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core exec] yql_execution.cpp:647: {dummy_op} Node #216021 created 0 trackable nodes: 2025-12-06 03:05:23.406 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core exec] yql_execution.cpp:89: {dummy_op} Finish, output #216021, status: Ok 2025-12-06 03:05:23.406 INFO dqrun(pid=3241241, tid=0x00007F8641EB2380) [core exec] yql_execution.cpp:95: {dummy_op} Creating finalizing transformer, output #216021 Getting results... Done