2025-11-14 10:10:45,516 - INFO - ya.test - pytest_runtest_setup: ####################################################################################################
2025-11-14 10:10:45,516 - INFO - ya.test - pytest_runtest_setup: test_projection_integer_type_validation[v1-false-client4-year String NOT NULL-True]
2025-11-14 10:10:45,516 - INFO - ya.test - pytest_runtest_setup: ####################################################################################################
2025-11-14 10:10:45,516 - INFO - ya.test - pytest_runtest_setup: Test setup
2025-11-14 10:10:45,625 - INFO - ya.test - pytest_runtest_call: Test call (class_name: test_explicit_partitioning_0.py::TestS3, test_name: test_projection_integer_type_validation[v1-false-client4-year String NOT NULL-True])
2025-11-14 10:10:45,626 - DEBUG - botocore.hooks - _emit: Event choose-service-name: calling handler <function handle_service_name_alias at 0x7f496e4347d0>
2025-11-14 10:10:45,628 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function add_generate_presigned_post at 0x7f496e5404d0>
2025-11-14 10:10:45,628 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function lazy_call.<locals>._handler at 0x7f496d6e8c50>
2025-11-14 10:10:45,629 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function add_generate_presigned_url at 0x7f496e5401d0>
2025-11-14 10:10:45,632 - DEBUG - botocore.endpoint - create_endpoint: Setting s3 timeout as (60, 60)
2025-11-14 10:10:45,637 - DEBUG - botocore.client - _register_legacy_retries: Registering retry handlers for service: s3
2025-11-14 10:10:45,638 - DEBUG - botocore.utils - register: Registering S3 region redirector handler
2025-11-14 10:10:45,639 - DEBUG - boto3.resources.factory - load_from_definition: Loading s3:s3
2025-11-14 10:10:45,640 - DEBUG - boto3.resources.factory - load_from_definition: Loading s3:Bucket
2025-11-14 10:10:45,641 - DEBUG - boto3.resources.model - _load_name_with_category: Renaming Bucket attribute name
2025-11-14 10:10:45,643 - DEBUG - botocore.hooks - _emit: Event creating-resource-class.s3.Bucket: calling handler <function lazy_call.<locals>._handler at 0x7f496d6e96d0>
2025-11-14 10:10:45,643 - DEBUG - boto3.resources.action - __call__: Calling s3:create_bucket with {'Bucket': 'test_projection_integer_type_validation', 'ACL': 'public-read'}
2025-11-14 10:10:45,644 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <function validate_bucket_name at 0x7f496e436690>
2025-11-14 10:10:45,644 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <function remove_bucket_from_url_paths_from_model at 0x7f496e454f50>
2025-11-14 10:10:45,645 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <bound method S3RegionRedirectorv2.annotate_request_context of <botocore.utils.S3RegionRedirectorv2 object at 0x7f4950d7e540>>
2025-11-14 10:10:45,645 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <function generate_idempotent_uuid at 0x7f496e436450>
2025-11-14 10:10:45,645 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <function customize_endpoint_resolver_builtins at 0x7f496e455190>
2025-11-14 10:10:45,645 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <bound method S3RegionRedirectorv2.redirect_from_cache of <botocore.utils.S3RegionRedirectorv2 object at 0x7f4950d7e540>>
2025-11-14 10:10:45,646 - DEBUG - botocore.regions - construct_endpoint: Calling endpoint provider with parameters: {'Bucket': 'test_projection_integer_type_validation', 'Region': 'yandex', 'UseFIPS': False, 'UseDualStack': False, 'Endpoint': 'http://localhost:27318', 'ForcePathStyle': True, 'Accelerate': False, 'UseGlobalEndpoint': False, 'DisableAccessPoints': True, 'DisableMultiRegionAccessPoints': False, 'UseArnRegion': True}
2025-11-14 10:10:45,647 - DEBUG - botocore.regions - construct_endpoint: Endpoint provider result: http://localhost:27318/test_projection_integer_type_validation
2025-11-14 10:10:45,648 - DEBUG - botocore.regions - auth_schemes_to_signing_ctx: Selecting from endpoint provider's list of auth schemes: "sigv4". User selected auth scheme is: "None"
2025-11-14 10:10:45,648 - DEBUG - botocore.regions - auth_schemes_to_signing_ctx: Selected auth type "v4" as "v4" with signing context params: {'region': 'yandex', 'signing_name': 's3', 'disableDoubleEncoding': True}
2025-11-14 10:10:45,649 - DEBUG - botocore.hooks - _emit: Event before-call.s3.CreateBucket: calling handler <function add_expect_header at 0x7f496e436b10>
2025-11-14 10:10:45,649 - DEBUG - botocore.hooks - _emit: Event before-call.s3.CreateBucket: calling handler <function add_recursion_detection_header at 0x7f496e434a10>
2025-11-14 10:10:45,649 - DEBUG - botocore.hooks - _emit: Event before-call.s3.CreateBucket: calling handler <function inject_api_version_header_if_needed at 0x7f496e454590>
2025-11-14 10:10:45,649 - DEBUG - botocore.endpoint - make_request: Making request for OperationModel(name=CreateBucket) with params: {'url_path': '', 'query_string': {}, 'method': 'PUT', 'headers': {'x-amz-acl': 'public-read', 'User-Agent': 'Boto3/1.29.6 md/Botocore#1.31.80 ua/2.0 os/linux#5.15.0-157-generic md/arch#x86_64 lang/python#3.12.9 md/pyimpl#CPython cfg/retry-mode#legacy Botocore/1.31.80 Resource'}, 'body': b'', 'auth_path': '/test_projection_integer_type_validation/', 'url': 'http://localhost:27318/test_projection_integer_type_validation', 'context': {'client_region': 'yandex', 'client_config': <botocore.config.Config object at 0x7f4950dbb0d0>, 'has_streaming_input': False, 'auth_type': 'v4', 's3_redirect': {'redirected': False, 'bucket': 'test_projection_integer_type_validation', 'params': {'Bucket': 'test_projection_integer_type_validation', 'ACL': 'public-read'}}, 'signing': {'region': 'yandex', 'signing_name': 's3', 'disableDoubleEncoding': True}}}
2025-11-14 10:10:45,650 - DEBUG - botocore.hooks - _emit: Event request-created.s3.CreateBucket: calling handler <bound method RequestSigner.handler of <botocore.signers.RequestSigner object at 0x7f4950dbb8a0>>
2025-11-14 10:10:45,651 - DEBUG - botocore.hooks - _emit: Event choose-signer.s3.CreateBucket: calling handler <bound method ClientCreator._default_s3_presign_to_sigv2 of <botocore.client.ClientCreator object at 0x7f4951655640>>
2025-11-14 10:10:45,651 - DEBUG - botocore.hooks - _emit: Event choose-signer.s3.CreateBucket: calling handler <function set_operation_specific_signer at 0x7f496e4362d0>
2025-11-14 10:10:45,652 - DEBUG - botocore.hooks - _emit: Event before-sign.s3.CreateBucket: calling handler <function remove_arn_from_signing_path at 0x7f496e4550d0>
2025-11-14 10:10:45,652 - DEBUG - botocore.auth - add_auth: Calculating signature using v4 auth.
2025-11-14 10:10:45,652 - DEBUG - botocore.auth - add_auth: CanonicalRequest:
PUT
/test_projection_integer_type_validation

host:localhost:27318
x-amz-acl:public-read
x-amz-content-sha256:e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
x-amz-date:20251114T101045Z

host;x-amz-acl;x-amz-content-sha256;x-amz-date
e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
2025-11-14 10:10:45,653 - DEBUG - botocore.auth - add_auth: StringToSign:
AWS4-HMAC-SHA256
20251114T101045Z
20251114/yandex/s3/aws4_request
05e4d500b721bf3f68c712346cc8ae38069e26b913f9452896120be0cc410e15
2025-11-14 10:10:45,653 - DEBUG - botocore.auth - add_auth: Signature:
bc898f4f2f47a2a87a5164d1ae5b5a0b827ba663fa9149fdb609bb3859763c3e
2025-11-14 10:10:45,653 - DEBUG - botocore.hooks - _emit: Event request-created.s3.CreateBucket: calling handler <function add_retry_headers at 0x7f496e454e90>
2025-11-14 10:10:45,654 - DEBUG - botocore.endpoint - _do_get_response: Sending http request: <AWSPreparedRequest stream_output=False, method=PUT, url=http://localhost:27318/test_projection_integer_type_validation, headers={'x-amz-acl': b'public-read', 'User-Agent': b'Boto3/1.29.6 md/Botocore#1.31.80 ua/2.0 os/linux#5.15.0-157-generic md/arch#x86_64 lang/python#3.12.9 md/pyimpl#CPython cfg/retry-mode#legacy Botocore/1.31.80 Resource', 'X-Amz-Date': b'20251114T101045Z', 'X-Amz-Content-SHA256': b'e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855', 'Authorization': b'AWS4-HMAC-SHA256 Credential=key/20251114/yandex/s3/aws4_request, SignedHeaders=host;x-amz-acl;x-amz-content-sha256;x-amz-date, Signature=bc898f4f2f47a2a87a5164d1ae5b5a0b827ba663fa9149fdb609bb3859763c3e', 'amz-sdk-invocation-id': b'ad2bbf24-5595-41f3-ac8a-ecf909eb7c21', 'amz-sdk-request': b'attempt=1', 'Content-Length': '0'}>
2025-11-14 10:10:45,669 - DEBUG - botocore.parsers - parse: Response headers: {'Server': 'Werkzeug/2.2.3 Python/3.12.9', 'Date': 'Fri, 14 Nov 2025 10:10:45 GMT', 'x-amzn-requestid': '4AXwvWyM2qaN5qPUlUm00wnwkcohEaINF9sylWQgaWgj715L3s0t', 'Content-Type': 'text/html; charset=utf-8', 'Content-Length': '193', 'Access-Control-Allow-Origin': '*', 'Connection': 'close'}
2025-11-14 10:10:45,670 - DEBUG - botocore.parsers - parse: Response body:
b'<CreateBucketResponse xmlns="http://s3.amazonaws.com/doc/2006-03-01"><CreateBucketResponse><Bucket>test_projection_integer_type_validation</Bucket></CreateBucketResponse></CreateBucketResponse>'
2025-11-14 10:10:45,671 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.CreateBucket: calling handler <botocore.retryhandler.RetryHandler object at 0x7f4951059500>
2025-11-14 10:10:45,671 - DEBUG - botocore.retryhandler - __call__: No retry needed.
2025-11-14 10:10:45,671 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.CreateBucket: calling handler <bound method S3RegionRedirectorv2.redirect_from_error of <botocore.utils.S3RegionRedirectorv2 object at 0x7f4950d7e540>>
2025-11-14 10:10:45,672 - DEBUG - boto3.resources.action - __call__: Response: {'ResponseMetadata': {'RequestId': '4AXwvWyM2qaN5qPUlUm00wnwkcohEaINF9sylWQgaWgj715L3s0t', 'HTTPStatusCode': 200, 'HTTPHeaders': {'server': 'Werkzeug/2.2.3 Python/3.12.9', 'date': 'Fri, 14 Nov 2025 10:10:45 GMT', 'x-amzn-requestid': '4AXwvWyM2qaN5qPUlUm00wnwkcohEaINF9sylWQgaWgj715L3s0t', 'content-type': 'text/html; charset=utf-8', 'content-length': '193', 'access-control-allow-origin': '*', 'connection': 'close'}, 'RetryAttempts': 0}}
2025-11-14 10:10:45,673 - DEBUG - botocore.hooks - _emit: Event choose-service-name: calling handler <function handle_service_name_alias at 0x7f496e4347d0>
2025-11-14 10:10:45,675 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function add_generate_presigned_post at 0x7f496e5404d0>
2025-11-14 10:10:45,675 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function lazy_call.<locals>._handler at 0x7f496d6e8c50>
2025-11-14 10:10:45,675 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function add_generate_presigned_url at 0x7f496e5401d0>
2025-11-14 10:10:45,678 - DEBUG - botocore.endpoint - create_endpoint: Setting s3 timeout as (60, 60)
2025-11-14 10:10:45,682 - DEBUG - botocore.client - _register_legacy_retries: Registering retry handlers for service: s3
2025-11-14 10:10:45,683 - DEBUG - botocore.utils - register: Registering S3 region redirector handler
2025-11-14 10:10:45,685 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function validate_ascii_metadata at 0x7f496e437710>
2025-11-14 10:10:45,685 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function sse_md5 at 0x7f496e436750>
2025-11-14 10:10:45,685 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function convert_body_to_file_like_object at 0x7f496e454410>
2025-11-14 10:10:45,685 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function validate_bucket_name at 0x7f496e436690>
2025-11-14 10:10:45,686 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function remove_bucket_from_url_paths_from_model at 0x7f496e454f50>
2025-11-14 10:10:45,686 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <bound method S3RegionRedirectorv2.annotate_request_context of <botocore.utils.S3RegionRedirectorv2 object at 0x7f4951055910>>
2025-11-14 10:10:45,686 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function generate_idempotent_uuid at 0x7f496e436450>
2025-11-14 10:10:45,686 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <function customize_endpoint_resolver_builtins at 0x7f496e455190>
2025-11-14 10:10:45,687 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <bound method S3RegionRedirectorv2.redirect_from_cache of <botocore.utils.S3RegionRedirectorv2 object at 0x7f4951055910>>
2025-11-14 10:10:45,687 - DEBUG - botocore.regions - construct_endpoint: Calling endpoint provider with parameters: {'Bucket': 'test_projection_integer_type_validation', 'Region': 'yandex', 'UseFIPS': False, 'UseDualStack': False, 'Endpoint': 'http://localhost:27318', 'ForcePathStyle': True, 'Accelerate': False, 'UseGlobalEndpoint': False, 'DisableMultiRegionAccessPoints': False, 'UseArnRegion': True}
2025-11-14 10:10:45,688 - DEBUG - botocore.regions - construct_endpoint: Endpoint provider result: http://localhost:27318/test_projection_integer_type_validation
2025-11-14 10:10:45,689 - DEBUG - botocore.regions - auth_schemes_to_signing_ctx: Selecting from endpoint provider's list of auth schemes: "sigv4". User selected auth scheme is: "None"
2025-11-14 10:10:45,689 - DEBUG - botocore.regions - auth_schemes_to_signing_ctx: Selected auth type "v4" as "v4" with signing context params: {'region': 'yandex', 'signing_name': 's3', 'disableDoubleEncoding': True}
2025-11-14 10:10:45,690 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function conditionally_calculate_md5 at 0x7f496e64f650>
2025-11-14 10:10:45,690 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function add_expect_header at 0x7f496e436b10>
2025-11-14 10:10:45,690 - DEBUG - botocore.handlers - add_expect_header: Adding expect 100 continue header to request.
2025-11-14 10:10:45,690 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function add_recursion_detection_header at 0x7f496e434a10>
2025-11-14 10:10:45,691 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function inject_api_version_header_if_needed at 0x7f496e454590>
2025-11-14 10:10:45,691 - DEBUG - botocore.endpoint - make_request: Making request for OperationModel(name=PutObject) with params: {'url_path': '/2022-03-05/fruits.csv', 'query_string': {}, 'method': 'PUT', 'headers': {'Content-Type': 'text/plain', 'User-Agent': 'Boto3/1.29.6 md/Botocore#1.31.80 ua/2.0 os/linux#5.15.0-157-generic md/arch#x86_64 lang/python#3.12.9 md/pyimpl#CPython cfg/retry-mode#legacy Botocore/1.31.80', 'Content-MD5': 'N3CmbcSU7yYXwHhfTRLclg==', 'Expect': '100-continue'}, 'body': <_io.BytesIO object at 0x7f4950e4e4a0>, 'auth_path': '/test_projection_integer_type_validation/2022-03-05/fruits.csv', 'url': 'http://localhost:27318/test_projection_integer_type_validation/2022-03-05/fruits.csv', 'context': {'client_region': 'yandex', 'client_config': <botocore.config.Config object at 0x7f4951057f30>, 'has_streaming_input': True, 'auth_type': 'v4', 's3_redirect': {'redirected': False, 'bucket': 'test_projection_integer_type_validation', 'params': {'Body': <_io.BytesIO object at 0x7f4950e4e4a0>, 'Bucket': 'test_projection_integer_type_validation', 'Key': '2022-03-05/fruits.csv', 'ContentType': 'text/plain'}}, 'signing': {'region': 'yandex', 'signing_name': 's3', 'disableDoubleEncoding': True}}}
2025-11-14 10:10:45,692 - DEBUG - botocore.hooks - _emit: Event request-created.s3.PutObject: calling handler <bound method RequestSigner.handler of <botocore.signers.RequestSigner object at 0x7f4951055a50>>
2025-11-14 10:10:45,692 - DEBUG - botocore.hooks - _emit: Event choose-signer.s3.PutObject: calling handler <bound method ClientCreator._default_s3_presign_to_sigv2 of <botocore.client.ClientCreator object at 0x7f4959d369a0>>
2025-11-14 10:10:45,692 - DEBUG - botocore.hooks - _emit: Event choose-signer.s3.PutObject: calling handler <function set_operation_specific_signer at 0x7f496e4362d0>
2025-11-14 10:10:45,693 - DEBUG - botocore.hooks - _emit: Event before-sign.s3.PutObject: calling handler <function remove_arn_from_signing_path at 0x7f496e4550d0>
2025-11-14 10:10:45,694 - DEBUG - botocore.auth - add_auth: Calculating signature using v4 auth.
2025-11-14 10:10:45,694 - DEBUG - botocore.auth - add_auth: CanonicalRequest:
PUT
/test_projection_integer_type_validation/2022-03-05/fruits.csv

content-md5:N3CmbcSU7yYXwHhfTRLclg==
content-type:text/plain
host:localhost:27318
x-amz-content-sha256:d9ec952678723e7b44be7f7b160b98addbf1b6aa7e33a7bac583215ee511bbcb
x-amz-date:20251114T101045Z

content-md5;content-type;host;x-amz-content-sha256;x-amz-date
d9ec952678723e7b44be7f7b160b98addbf1b6aa7e33a7bac583215ee511bbcb
2025-11-14 10:10:45,694 - DEBUG - botocore.auth - add_auth: StringToSign:
AWS4-HMAC-SHA256
20251114T101045Z
20251114/yandex/s3/aws4_request
5f223521b4edcd0bc037582d3d33449d457dd509389013cc4b34bdc3b352fad2
2025-11-14 10:10:45,694 - DEBUG - botocore.auth - add_auth: Signature:
4d76a961e6fd4d5db76c680e26940273414c0ef148b8d6fb6486a6d27fd78e0e
2025-11-14 10:10:45,695 - DEBUG - botocore.hooks - _emit: Event request-created.s3.PutObject: calling handler <function add_retry_headers at 0x7f496e454e90>
2025-11-14 10:10:45,695 - DEBUG - botocore.endpoint - _do_get_response: Sending http request: <AWSPreparedRequest stream_output=False, method=PUT, url=http://localhost:27318/test_projection_integer_type_validation/2022-03-05/fruits.csv, headers={'Content-Type': b'text/plain', 'User-Agent': b'Boto3/1.29.6 md/Botocore#1.31.80 ua/2.0 os/linux#5.15.0-157-generic md/arch#x86_64 lang/python#3.12.9 md/pyimpl#CPython cfg/retry-mode#legacy Botocore/1.31.80', 'Content-MD5': b'N3CmbcSU7yYXwHhfTRLclg==', 'Expect': b'100-continue', 'X-Amz-Date': b'20251114T101045Z', 'X-Amz-Content-SHA256': b'd9ec952678723e7b44be7f7b160b98addbf1b6aa7e33a7bac583215ee511bbcb', 'Authorization': b'AWS4-HMAC-SHA256 Credential=key/20251114/yandex/s3/aws4_request, SignedHeaders=content-md5;content-type;host;x-amz-content-sha256;x-amz-date, Signature=4d76a961e6fd4d5db76c680e26940273414c0ef148b8d6fb6486a6d27fd78e0e', 'amz-sdk-invocation-id': b'2f5dfec9-2e6a-4ddb-9832-d569dce50db5', 'amz-sdk-request': b'attempt=1', 'Content-Length': '33'}>
2025-11-14 10:10:45,697 - DEBUG - botocore.awsrequest - _send_output: Waiting for 100 Continue response.
2025-11-14 10:10:45,699 - DEBUG - botocore.awsrequest - _handle_expect_response: 100 Continue response seen, now sending request body.
2025-11-14 10:10:45,704 - DEBUG - botocore.parsers - parse: Response headers: {'Server': 'Werkzeug/2.2.3 Python/3.12.9', 'Date': 'Fri, 14 Nov 2025 10:10:45 GMT', 'ETag': '"3770a66dc494ef2617c0785f4d12dc96"', 'last-modified': 'Fri, 14 Nov 2025 10:10:45 GMT', 'Content-Length': '0', 'x-amzn-requestid': 'hPpyqFgcHe5oiYFSj5myVoeUbR0IMVYPU8SmhTzl964cidAsvqKS', 'Content-Type': 'text/html; charset=utf-8', 'Access-Control-Allow-Origin': '*', 'Connection': 'close'}
2025-11-14 10:10:45,704 - DEBUG - botocore.parsers - parse: Response body:
b''
2025-11-14 10:10:45,705 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.PutObject: calling handler <botocore.retryhandler.RetryHandler object at 0x7f4950e1a090>
2025-11-14 10:10:45,705 - DEBUG - botocore.retryhandler - __call__: No retry needed.
2025-11-14 10:10:45,705 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.PutObject: calling handler <bound method S3RegionRedirectorv2.redirect_from_error of <botocore.utils.S3RegionRedirectorv2 object at 0x7f4951055910>>
2025-11-14 10:10:45,706 - DEBUG - root - wait_bootstrap: Wait for node 1 to bootstrap
2025-11-14 10:10:45,761 - DEBUG - root - wait_bootstrap: Node 1 has been bootstrapped
2025-11-14 10:10:45,794 - DEBUG - root - create_query_impl: Request: content {
  type: ANALYTICS
  name: "simple"
  acl {
    visibility: PRIVATE
  }
  limits {
    execution_timeout {
    }
  }
  text: "\n            pragma s3.UseRuntimeListing=\"false\";\n            \n            $projection =\n            @@\n            {\n                \"projection.enabled\" : true,\n\n                \"projection.year.type\" : \"integer\",\n                \"projection.year.min\" : 2022,\n                \"projection.year.max\" : 2022,\n                \"projection.year.interval\" : 1,\n\n                \"storage.location.template\" : \"${year}-03-05\"\n            }\n            @@;\n            \n            SELECT *\n            FROM `h4018373696498654220_test_projection_integer_type_validationfruitbucket`.`/` WITH\n            (\n                format=csv_with_names,\n                schema=\n                (\n                    Fruit String NOT NULL,\n                    year String NOT NULL\n                ),\n                partitioned_by=(year),\n                projection=$projection\n            )\n            "
  syntax: YQL_V1
}
execute_mode: RUN
idempotency_key: "d211e3a3-084e-4539-92cd-5b6189d87609"

2025-11-14 10:10:45,822 - DEBUG - root - create_query_impl: Result: query_id: "ptqudsej4vucrtprodf1"

2025-11-14 10:10:45,851 - DEBUG - root - describe_query: Result: query {
  meta {
    common {
      id: "ptqudsej4vucrtprodf1"
      created_by: "root@builtin"
      modified_by: "root@builtin"
      created_at {
        seconds: 1763115045
        nanos: 801081000
      }
      modified_at {
        seconds: 1763115045
        nanos: 801081000
      }
      revision: 1
    }
    execute_mode: RUN
    status: STARTING
    last_job_query_revision: 1
    last_job_id: "ptjudsej4vucpj6iivop-ptqudsej4vucrtprodf1"
    started_by: "root@builtin"
    submitted_at {
      seconds: 1763115045
      nanos: 801081000
    }
  }
  content {
    type: ANALYTICS
    name: "simple"
    acl {
      visibility: PRIVATE
    }
    limits {
      execution_timeout {
      }
    }
    text: "\n            pragma s3.UseRuntimeListing=\"false\";\n            \n            $projection =\n            @@\n            {\n                \"projection.enabled\" : true,\n\n                \"projection.year.type\" : \"integer\",\n                \"projection.year.min\" : 2022,\n                \"projection.year.max\" : 2022,\n                \"projection.year.interval\" : 1,\n\n                \"storage.location.template\" : \"${year}-03-05\"\n            }\n            @@;\n            \n            SELECT *\n            FROM `h4018373696498654220_test_projection_integer_type_validationfruitbucket`.`/` WITH\n            (\n                format=csv_with_names,\n                schema=\n                (\n                    Fruit String NOT NULL,\n                    year String NOT NULL\n                ),\n                partitioned_by=(year),\n                projection=$projection\n            )\n            "
    syntax: YQL_V1
  }
}

2025-11-14 10:10:46,376 - DEBUG - root - describe_query: Result: query {
  meta {
    common {
      id: "ptqudsej4vucrtprodf1"
      created_by: "root@builtin"
      modified_by: "root@builtin"
      created_at {
        seconds: 1763115045
        nanos: 801081000
      }
      modified_at {
        seconds: 1763115045
        nanos: 801081000
      }
      revision: 1
    }
    started_at {
      seconds: 1763115046
      nanos: 248000000
    }
    execute_mode: RUN
    status: RUNNING
    last_job_query_revision: 1
    last_job_id: "ptjudsej4vucpj6iivop-ptqudsej4vucrtprodf1"
    started_by: "root@builtin"
    submitted_at {
      seconds: 1763115045
      nanos: 801081000
    }
  }
  content {
    type: ANALYTICS
    name: "simple"
    acl {
      visibility: PRIVATE
    }
    limits {
      execution_timeout {
      }
    }
    text: "\n            pragma s3.UseRuntimeListing=\"false\";\n            \n            $projection =\n            @@\n            {\n                \"projection.enabled\" : true,\n\n                \"projection.year.type\" : \"integer\",\n                \"projection.year.min\" : 2022,\n                \"projection.year.max\" : 2022,\n                \"projection.year.interval\" : 1,\n\n                \"storage.location.template\" : \"${year}-03-05\"\n            }\n            @@;\n            \n            SELECT *\n            FROM `h4018373696498654220_test_projection_integer_type_validationfruitbucket`.`/` WITH\n            (\n                format=csv_with_names,\n                schema=\n                (\n                    Fruit String NOT NULL,\n                    year String NOT NULL\n                ),\n                partitioned_by=(year),\n                projection=$projection\n            )\n            "
    syntax: YQL_V1
  }
  plan {
    json: "{\"Detailed\":{\"Operations\":[{\"Id\":10,\"Name\":\"DqStage\",\"Streams\":{\"Program\":[{\"Name\":\"DqSourceWideWrap\"},{\"Name\":\"NarrowMap\"}]}},{\"Id\":8,\"Name\":\"DqStage\",\"Streams\":{\"Program\":[]},\"DependsOn\":[10]},{\"Id\":3,\"Name\":\"ResPull!\",\"DependsOn\":[8]},{\"Id\":1,\"Name\":\"Commit!\",\"DependsOn\":[3]}],\"OperationRoot\":1,\"Providers\":[],\"OperationStats\":{\"Commit!\":1,\"DqStage\":2,\"ResPull!\":1}},\"Basic\":{\"nodes\":[{\"id\":10,\"level\":1,\"name\":\"DqStage #10\",\"type\":\"op\"},{\"id\":8,\"level\":2,\"name\":\"DqStage #8\",\"type\":\"op\"},{\"id\":3,\"level\":3,\"name\":\"ResPull!\",\"type\":\"op\"},{\"id\":1,\"level\":4,\"name\":\"Commit!\",\"type\":\"op\"}],\"links\":[{\"source\":10,\"target\":8},{\"source\":8,\"target\":3},{\"source\":3,\"target\":1}]}}"
  }
  result_set_meta {
    column {
      name: "Fruit"
      type {
        type_id: STRING
      }
    }
    column {
      name: "year"
      type {
        type_id: STRING
      }
    }
  }
  ast {
    data: "(\n(let $1 (Configure! world (DataSource \'\"config\") \'\"DqEngine\" \'\"force\"))\n(let $2 (Configure! $1 (DataSource \'\"s3\" \'\"$all\") \'\"Attr\" \'\"useruntimelisting\" \'\"false\"))\n(let $3 (DataSink \'result))\n(let $4 \'\"h4018373696498654220_test_projection_integer_type_validationfruitbucket\")\n(let $5 (DataSource \'\"s3\" $4))\n(let $6 \'\"Paths {\\n  Name: \\\"2022-03-05\\\"\\n  Children {\\n    Name: \\\"fruits.csv\\\"\\n    Size: 33\\n    Read: true\\n  }\\n  IsDirectory: true\\n}\\n\")\n(let $7 (Bool \'\"true\"))\n(let $8 (DataType \'String))\n(let $9 (AsStruct \'(\'\"year\" (StrictCast (Int64 \'\"2022\") $8))))\n(let $10 \'\"cluster:default_h4018373696498654220_test_projection_integer_type_validationfruitbucket\")\n(let $11 (StructType \'(\'\"Fruit\" $8) \'(\'\"year\" $8)))\n(let $12 \'\"\\n            {\\n                \\\"projection.enabled\\\" : true,\\n\\n                \\\"projection.year.type\\\" : \\\"integer\\\",\\n                \\\"projection.year.min\\\" : 2022,\\n                \\\"projection.year.max\\\" : 2022,\\n                \\\"projection.year.interval\\\" : 1,\\n\\n                \\\"storage.location.template\\\" : \\\"${year}-03-05\\\"\\n            }\\n            \")\n(let $13 \'(\'(\'\"partitionedby\" \'\"year\") \'(\'\"projection\" $12) \'(\'\"pathpattern\" \'\"*\") \'(\'\"pathpatternvariant\" \'\"FilePattern\")))\n(let $14 (S3ParseSettings world \'(\'((String $6) $7 $9)) (SecureParam $10) \'\"\" \'\"/ \" \'\"csv_with_names\" $11 (lambda \'($18) $7) $13))\n(let $15 (DqStage \'((DqSource $5 $14)) (lambda \'($19) (block \'(\n  (let $20 (DqSourceWideWrap $19 $5 $11 \'(\'(\'format \'\"csv_with_names\") \'(\'\"extraColumns\" (Replicate $9 (Uint64 \'1))))))\n  (return (NarrowMap $20 (lambda \'($21 $22) (AsStruct \'(\'\"Fruit\" $21) \'(\'\"year\" $22)))))\n))) \'(\'(\'\"_logical_id\" \'200070))))\n(let $16 (DqStage \'((DqCnUnionAll (TDqOutput $15 \'\"0\"))) (lambda \'($23) $23) \'(\'(\'\"_logical_id\" \'200109))))\n(let $17 (ResPull! $2 $3 (Key) (DqCnResult (TDqOutput $16 \'\"0\") \'()) \'(\'(\'type) \'(\'autoref)) \'\"dq\"))\n(return (Commit! (Commit! $17 $3) (DataSink \'\"s3\" $4)))\n)\n"
  }
}

2025-11-14 10:10:46,908 - DEBUG - root - describe_query: Result: query {
  meta {
    common {
      id: "ptqudsej4vucrtprodf1"
      created_by: "root@builtin"
      modified_by: "root@builtin"
      created_at {
        seconds: 1763115045
        nanos: 801081000
      }
      modified_at {
        seconds: 1763115045
        nanos: 801081000
      }
      revision: 1
    }
    started_at {
      seconds: 1763115046
      nanos: 248000000
    }
    finished_at {
      seconds: 1763115046
      nanos: 540000000
    }
    execute_mode: RUN
    status: COMPLETED
    last_job_query_revision: 1
    last_job_id: "ptjudsej4vucpj6iivop-ptqudsej4vucrtprodf1"
    result_expire_at {
      seconds: 1763201446
      nanos: 238338000
    }
    started_by: "root@builtin"
    submitted_at {
      seconds: 1763115045
      nanos: 801081000
    }
  }
  content {
    type: ANALYTICS
    name: "simple"
    acl {
      visibility: PRIVATE
    }
    limits {
      execution_timeout {
      }
    }
    text: "\n            pragma s3.UseRuntimeListing=\"false\";\n            \n            $projection =\n            @@\n            {\n                \"projection.enabled\" : true,\n\n                \"projection.year.type\" : \"integer\",\n                \"projection.year.min\" : 2022,\n                \"projection.year.max\" : 2022,\n                \"projection.year.interval\" : 1,\n\n                \"storage.location.template\" : \"${year}-03-05\"\n            }\n            @@;\n            \n            SELECT *\n            FROM `h4018373696498654220_test_projection_integer_type_validationfruitbucket`.`/` WITH\n            (\n                format=csv_with_names,\n                schema=\n                (\n                    Fruit String NOT NULL,\n                    year String NOT NULL\n                ),\n                partitioned_by=(year),\n                projection=$projection\n            )\n            "
    syntax: YQL_V1
  }
  plan {
    json: "{\"Detailed\":{\"Operations\":[{\"Id\":10,\"Name\":\"DqStage\",\"Streams\":{\"Program\":[{\"Name\":\"DqSourceWideWrap\"},{\"Name\":\"NarrowMap\"}]}},{\"Id\":8,\"Name\":\"DqStage\",\"Streams\":{\"Program\":[]},\"DependsOn\":[10]},{\"Id\":3,\"Name\":\"ResPull!\",\"DependsOn\":[8]},{\"Id\":1,\"Name\":\"Commit!\",\"DependsOn\":[3]}],\"OperationRoot\":1,\"Providers\":[],\"OperationStats\":{\"Commit!\":1,\"DqStage\":2,\"ResPull!\":1}},\"Basic\":{\"nodes\":[{\"id\":10,\"level\":1,\"name\":\"DqStage #10\",\"type\":\"op\"},{\"id\":8,\"level\":2,\"name\":\"DqStage #8\",\"type\":\"op\"},{\"id\":3,\"level\":3,\"name\":\"ResPull!\",\"type\":\"op\"},{\"id\":1,\"level\":4,\"name\":\"Commit!\",\"type\":\"op\"}],\"links\":[{\"source\":10,\"target\":8},{\"source\":8,\"target\":3},{\"source\":3,\"target\":1}]}}"
  }
  statistics {
    json: "{\"Graph=0\":{\"Tasks\":{\"sum\":2,\"count\":2,\"avg\":1,\"max\":1,\"min\":1},\"CpuTimeUs\":{\"sum\":\"0.15s\",\"count\":2,\"avg\":\"79ms\",\"max\":\"0.15s\",\"min\":\"2ms\"},\"IngressBytes\":{\"sum\":33,\"count\":1,\"avg\":33,\"max\":33,\"min\":33},\"IngressRows\":{\"sum\":1,\"count\":1,\"avg\":1,\"max\":1,\"min\":1},\"InputBytes\":{\"sum\":17,\"count\":1,\"avg\":17,\"max\":17,\"min\":17},\"InputRows\":{\"sum\":1,\"count\":1,\"avg\":1,\"max\":1,\"min\":1},\"OutputBytes\":{\"sum\":34,\"count\":2,\"avg\":17,\"max\":17,\"min\":17},\"OutputRows\":{\"sum\":2,\"count\":2,\"avg\":1,\"max\":1,\"min\":1},\"ResultBytes\":{\"sum\":17,\"count\":1,\"avg\":17,\"max\":17,\"min\":17},\"ResultRows\":{\"sum\":1,\"count\":1,\"avg\":1,\"max\":1,\"min\":1},\"MaxMemoryUsage\":{\"sum\":262144,\"count\":2,\"avg\":131072,\"max\":131072,\"min\":131072},\"IngressQueuedBytes\":{\"sum\":0,\"count\":2,\"avg\":0,\"max\":0,\"min\":0},\"IngressQueuedRows\":{\"sum\":0,\"count\":2,\"avg\":0,\"max\":0,\"min\":0}}}"
  }
  result_set_meta {
    column {
      name: "Fruit"
      type {
        type_id: STRING
      }
    }
    column {
      name: "year"
      type {
        type_id: STRING
      }
    }
    rows_count: 1
  }
  ast {
    data: "(\n(let $1 (Configure! world (DataSource \'\"config\") \'\"DqEngine\" \'\"force\"))\n(let $2 (Configure! $1 (DataSource \'\"s3\" \'\"$all\") \'\"Attr\" \'\"useruntimelisting\" \'\"false\"))\n(let $3 (DataSink \'result))\n(let $4 \'\"h4018373696498654220_test_projection_integer_type_validationfruitbucket\")\n(let $5 (DataSource \'\"s3\" $4))\n(let $6 \'\"Paths {\\n  Name: \\\"2022-03-05\\\"\\n  Children {\\n    Name: \\\"fruits.csv\\\"\\n    Size: 33\\n    Read: true\\n  }\\n  IsDirectory: true\\n}\\n\")\n(let $7 (Bool \'\"true\"))\n(let $8 (DataType \'String))\n(let $9 (AsStruct \'(\'\"year\" (StrictCast (Int64 \'\"2022\") $8))))\n(let $10 \'\"cluster:default_h4018373696498654220_test_projection_integer_type_validationfruitbucket\")\n(let $11 (StructType \'(\'\"Fruit\" $8) \'(\'\"year\" $8)))\n(let $12 \'\"\\n            {\\n                \\\"projection.enabled\\\" : true,\\n\\n                \\\"projection.year.type\\\" : \\\"integer\\\",\\n                \\\"projection.year.min\\\" : 2022,\\n                \\\"projection.year.max\\\" : 2022,\\n                \\\"projection.year.interval\\\" : 1,\\n\\n                \\\"storage.location.template\\\" : \\\"${year}-03-05\\\"\\n            }\\n            \")\n(let $13 \'(\'(\'\"partitionedby\" \'\"year\") \'(\'\"projection\" $12) \'(\'\"pathpattern\" \'\"*\") \'(\'\"pathpatternvariant\" \'\"FilePattern\")))\n(let $14 (S3ParseSettings world \'(\'((String $6) $7 $9)) (SecureParam $10) \'\"\" \'\"/ \" \'\"csv_with_names\" $11 (lambda \'($18) $7) $13))\n(let $15 (DqStage \'((DqSource $5 $14)) (lambda \'($19) (block \'(\n  (let $20 (DqSourceWideWrap $19 $5 $11 \'(\'(\'format \'\"csv_with_names\") \'(\'\"extraColumns\" (Replicate $9 (Uint64 \'1))))))\n  (return (NarrowMap $20 (lambda \'($21 $22) (AsStruct \'(\'\"Fruit\" $21) \'(\'\"year\" $22)))))\n))) \'(\'(\'\"_logical_id\" \'200070))))\n(let $16 (DqStage \'((DqCnUnionAll (TDqOutput $15 \'\"0\"))) (lambda \'($23) $23) \'(\'(\'\"_logical_id\" \'200109))))\n(let $17 (ResPull! $2 $3 (Key) (DqCnResult (TDqOutput $16 \'\"0\") \'()) \'(\'(\'type) \'(\'autoref)) \'\"dq\"))\n(return (Commit! (Commit! $17 $3) (DataSink \'\"s3\" $4)))\n)\n"
  }
}

2025-11-14 10:10:46,935 - DEBUG - root - test_projection_integer_type_validation: columns {
  name: "Fruit"
  type {
    type_id: STRING
  }
}
columns {
  name: "year"
  type {
    type_id: STRING
  }
}
rows {
  items {
    bytes_value: "Banana"
  }
  items {
    bytes_value: "2022"
  }
}

2025-11-14 10:10:46,938 - INFO - ya.test - pytest_runtest_teardown: Test teardown
