2025-11-14 10:10:58,069 - INFO - ya.test - pytest_runtest_setup: ####################################################################################################
2025-11-14 10:10:58,069 - INFO - ya.test - pytest_runtest_setup: test_projection_integer_type_validation[v1-false-client11-year Int64-False]
2025-11-14 10:10:58,070 - INFO - ya.test - pytest_runtest_setup: ####################################################################################################
2025-11-14 10:10:58,070 - INFO - ya.test - pytest_runtest_setup: Test setup
2025-11-14 10:10:58,199 - 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-client11-year Int64-False])
2025-11-14 10:10:58,200 - DEBUG - botocore.hooks - _emit: Event choose-service-name: calling handler <function handle_service_name_alias at 0x7f496e4347d0>
2025-11-14 10:10:58,203 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function add_generate_presigned_post at 0x7f496e5404d0>
2025-11-14 10:10:58,204 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function lazy_call.<locals>._handler at 0x7f496d6e8c50>
2025-11-14 10:10:58,204 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function add_generate_presigned_url at 0x7f496e5401d0>
2025-11-14 10:10:58,211 - DEBUG - botocore.endpoint - create_endpoint: Setting s3 timeout as (60, 60)
2025-11-14 10:10:58,217 - DEBUG - botocore.client - _register_legacy_retries: Registering retry handlers for service: s3
2025-11-14 10:10:58,218 - DEBUG - botocore.utils - register: Registering S3 region redirector handler
2025-11-14 10:10:58,219 - DEBUG - boto3.resources.factory - load_from_definition: Loading s3:s3
2025-11-14 10:10:58,221 - DEBUG - boto3.resources.factory - load_from_definition: Loading s3:Bucket
2025-11-14 10:10:58,222 - DEBUG - boto3.resources.model - _load_name_with_category: Renaming Bucket attribute name
2025-11-14 10:10:58,223 - DEBUG - botocore.hooks - _emit: Event creating-resource-class.s3.Bucket: calling handler <function lazy_call.<locals>._handler at 0x7f496d6e96d0>
2025-11-14 10:10:58,224 - DEBUG - boto3.resources.action - __call__: Calling s3:create_bucket with {'Bucket': 'test_projection_integer_type_validation', 'ACL': 'public-read'}
2025-11-14 10:10:58,225 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <function validate_bucket_name at 0x7f496e436690>
2025-11-14 10:10:58,225 - 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:58,225 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <bound method S3RegionRedirectorv2.annotate_request_context of <botocore.utils.S3RegionRedirectorv2 object at 0x7f496d692e00>>
2025-11-14 10:10:58,226 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <function generate_idempotent_uuid at 0x7f496e436450>
2025-11-14 10:10:58,226 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <function customize_endpoint_resolver_builtins at 0x7f496e455190>
2025-11-14 10:10:58,226 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <bound method S3RegionRedirectorv2.redirect_from_cache of <botocore.utils.S3RegionRedirectorv2 object at 0x7f496d692e00>>
2025-11-14 10:10:58,227 - 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:58,228 - DEBUG - botocore.regions - construct_endpoint: Endpoint provider result: http://localhost:27318/test_projection_integer_type_validation
2025-11-14 10:10:58,228 - 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:58,229 - 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:58,229 - DEBUG - botocore.hooks - _emit: Event before-call.s3.CreateBucket: calling handler <function add_expect_header at 0x7f496e436b10>
2025-11-14 10:10:58,230 - DEBUG - botocore.hooks - _emit: Event before-call.s3.CreateBucket: calling handler <function add_recursion_detection_header at 0x7f496e434a10>
2025-11-14 10:10:58,230 - 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:58,230 - 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 0x7f4950eac970>, '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:58,231 - DEBUG - botocore.hooks - _emit: Event request-created.s3.CreateBucket: calling handler <bound method RequestSigner.handler of <botocore.signers.RequestSigner object at 0x7f4950ead780>>
2025-11-14 10:10:58,232 - 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 0x7f49512fed10>>
2025-11-14 10:10:58,232 - DEBUG - botocore.hooks - _emit: Event choose-signer.s3.CreateBucket: calling handler <function set_operation_specific_signer at 0x7f496e4362d0>
2025-11-14 10:10:58,232 - DEBUG - botocore.hooks - _emit: Event before-sign.s3.CreateBucket: calling handler <function remove_arn_from_signing_path at 0x7f496e4550d0>
2025-11-14 10:10:58,233 - DEBUG - botocore.auth - add_auth: Calculating signature using v4 auth.
2025-11-14 10:10:58,233 - 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:20251114T101058Z

host;x-amz-acl;x-amz-content-sha256;x-amz-date
e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
2025-11-14 10:10:58,234 - DEBUG - botocore.auth - add_auth: StringToSign:
AWS4-HMAC-SHA256
20251114T101058Z
20251114/yandex/s3/aws4_request
2b9a6d7d969dd5d1ec07fda8a707ceac548eaf9966edfd1ce10301b1def07c77
2025-11-14 10:10:58,234 - DEBUG - botocore.auth - add_auth: Signature:
2d73863a2a96de0e69df25fd07e6ae56e68a4817cc528ef98ba2f076a7f1d9f0
2025-11-14 10:10:58,235 - DEBUG - botocore.hooks - _emit: Event request-created.s3.CreateBucket: calling handler <function add_retry_headers at 0x7f496e454e90>
2025-11-14 10:10:58,235 - 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'20251114T101058Z', '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=2d73863a2a96de0e69df25fd07e6ae56e68a4817cc528ef98ba2f076a7f1d9f0', 'amz-sdk-invocation-id': b'84f54708-cae3-4b35-9da1-1d66fb2c290e', 'amz-sdk-request': b'attempt=1', 'Content-Length': '0'}>
2025-11-14 10:10:58,265 - DEBUG - botocore.parsers - parse: Response headers: {'Server': 'Werkzeug/2.2.3 Python/3.12.9', 'Date': 'Fri, 14 Nov 2025 10:10:58 GMT', 'x-amzn-requestid': 'N70B4B3vEgG6kmY75Pe2AA7teo7cKT8xVVUzaBIWT24tshD7Pd8d', 'Content-Type': 'text/html; charset=utf-8', 'Content-Length': '193', 'Access-Control-Allow-Origin': '*', 'Connection': 'close'}
2025-11-14 10:10:58,266 - 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:58,267 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.CreateBucket: calling handler <botocore.retryhandler.RetryHandler object at 0x7f4950e24560>
2025-11-14 10:10:58,267 - DEBUG - botocore.retryhandler - __call__: No retry needed.
2025-11-14 10:10:58,267 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.CreateBucket: calling handler <bound method S3RegionRedirectorv2.redirect_from_error of <botocore.utils.S3RegionRedirectorv2 object at 0x7f496d692e00>>
2025-11-14 10:10:58,268 - DEBUG - boto3.resources.action - __call__: Response: {'ResponseMetadata': {'RequestId': 'N70B4B3vEgG6kmY75Pe2AA7teo7cKT8xVVUzaBIWT24tshD7Pd8d', 'HTTPStatusCode': 200, 'HTTPHeaders': {'server': 'Werkzeug/2.2.3 Python/3.12.9', 'date': 'Fri, 14 Nov 2025 10:10:58 GMT', 'x-amzn-requestid': 'N70B4B3vEgG6kmY75Pe2AA7teo7cKT8xVVUzaBIWT24tshD7Pd8d', 'content-type': 'text/html; charset=utf-8', 'content-length': '193', 'access-control-allow-origin': '*', 'connection': 'close'}, 'RetryAttempts': 0}}
2025-11-14 10:10:58,269 - DEBUG - botocore.hooks - _emit: Event choose-service-name: calling handler <function handle_service_name_alias at 0x7f496e4347d0>
2025-11-14 10:10:58,277 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function add_generate_presigned_post at 0x7f496e5404d0>
2025-11-14 10:10:58,277 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function lazy_call.<locals>._handler at 0x7f496d6e8c50>
2025-11-14 10:10:58,277 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function add_generate_presigned_url at 0x7f496e5401d0>
2025-11-14 10:10:58,281 - DEBUG - botocore.endpoint - create_endpoint: Setting s3 timeout as (60, 60)
2025-11-14 10:10:58,288 - DEBUG - botocore.client - _register_legacy_retries: Registering retry handlers for service: s3
2025-11-14 10:10:58,289 - DEBUG - botocore.utils - register: Registering S3 region redirector handler
2025-11-14 10:10:58,296 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function validate_ascii_metadata at 0x7f496e437710>
2025-11-14 10:10:58,296 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function sse_md5 at 0x7f496e436750>
2025-11-14 10:10:58,297 - 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:58,297 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function validate_bucket_name at 0x7f496e436690>
2025-11-14 10:10:58,297 - 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:58,297 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <bound method S3RegionRedirectorv2.annotate_request_context of <botocore.utils.S3RegionRedirectorv2 object at 0x7f4951525910>>
2025-11-14 10:10:58,297 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function generate_idempotent_uuid at 0x7f496e436450>
2025-11-14 10:10:58,298 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <function customize_endpoint_resolver_builtins at 0x7f496e455190>
2025-11-14 10:10:58,298 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <bound method S3RegionRedirectorv2.redirect_from_cache of <botocore.utils.S3RegionRedirectorv2 object at 0x7f4951525910>>
2025-11-14 10:10:58,299 - 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:58,300 - DEBUG - botocore.regions - construct_endpoint: Endpoint provider result: http://localhost:27318/test_projection_integer_type_validation
2025-11-14 10:10:58,301 - 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:58,301 - 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:58,302 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function conditionally_calculate_md5 at 0x7f496e64f650>
2025-11-14 10:10:58,302 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function add_expect_header at 0x7f496e436b10>
2025-11-14 10:10:58,302 - DEBUG - botocore.handlers - add_expect_header: Adding expect 100 continue header to request.
2025-11-14 10:10:58,302 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function add_recursion_detection_header at 0x7f496e434a10>
2025-11-14 10:10:58,303 - 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:58,303 - 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 0x7f4951367af0>, '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 0x7f49515257d0>, 'has_streaming_input': True, 'auth_type': 'v4', 's3_redirect': {'redirected': False, 'bucket': 'test_projection_integer_type_validation', 'params': {'Body': <_io.BytesIO object at 0x7f4951367af0>, '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:58,304 - DEBUG - botocore.hooks - _emit: Event request-created.s3.PutObject: calling handler <bound method RequestSigner.handler of <botocore.signers.RequestSigner object at 0x7f4951525aa0>>
2025-11-14 10:10:58,305 - 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 0x7f4951307d00>>
2025-11-14 10:10:58,305 - DEBUG - botocore.hooks - _emit: Event choose-signer.s3.PutObject: calling handler <function set_operation_specific_signer at 0x7f496e4362d0>
2025-11-14 10:10:58,305 - DEBUG - botocore.hooks - _emit: Event before-sign.s3.PutObject: calling handler <function remove_arn_from_signing_path at 0x7f496e4550d0>
2025-11-14 10:10:58,306 - DEBUG - botocore.auth - add_auth: Calculating signature using v4 auth.
2025-11-14 10:10:58,306 - 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:20251114T101058Z

content-md5;content-type;host;x-amz-content-sha256;x-amz-date
d9ec952678723e7b44be7f7b160b98addbf1b6aa7e33a7bac583215ee511bbcb
2025-11-14 10:10:58,306 - DEBUG - botocore.auth - add_auth: StringToSign:
AWS4-HMAC-SHA256
20251114T101058Z
20251114/yandex/s3/aws4_request
197c34cb2ebef69089df50c01a3595dc4231c99f5590ac79610d194dc4da915f
2025-11-14 10:10:58,307 - DEBUG - botocore.auth - add_auth: Signature:
dd328e6684c48ca2860465d31ee0bd2e35cca488c4ca18755e04f7b5e325b6ad
2025-11-14 10:10:58,307 - DEBUG - botocore.hooks - _emit: Event request-created.s3.PutObject: calling handler <function add_retry_headers at 0x7f496e454e90>
2025-11-14 10:10:58,307 - 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'20251114T101058Z', '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=dd328e6684c48ca2860465d31ee0bd2e35cca488c4ca18755e04f7b5e325b6ad', 'amz-sdk-invocation-id': b'e20c1c2b-9ad8-4cfa-852d-3b332ef221f6', 'amz-sdk-request': b'attempt=1', 'Content-Length': '33'}>
2025-11-14 10:10:58,312 - DEBUG - botocore.awsrequest - _send_output: Waiting for 100 Continue response.
2025-11-14 10:10:58,316 - DEBUG - botocore.awsrequest - _handle_expect_response: 100 Continue response seen, now sending request body.
2025-11-14 10:10:58,321 - DEBUG - botocore.parsers - parse: Response headers: {'Server': 'Werkzeug/2.2.3 Python/3.12.9', 'Date': 'Fri, 14 Nov 2025 10:10:58 GMT', 'ETag': '"3770a66dc494ef2617c0785f4d12dc96"', 'last-modified': 'Fri, 14 Nov 2025 10:10:58 GMT', 'Content-Length': '0', 'x-amzn-requestid': 'd9QQ0cs8SULiW4q23gc8ODPghPDNd1WSNFEced5NgM3NnxkxWbGE', 'Content-Type': 'text/html; charset=utf-8', 'Access-Control-Allow-Origin': '*', 'Connection': 'close'}
2025-11-14 10:10:58,321 - DEBUG - botocore.parsers - parse: Response body:
b''
2025-11-14 10:10:58,322 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.PutObject: calling handler <botocore.retryhandler.RetryHandler object at 0x7f4950dbb6c0>
2025-11-14 10:10:58,323 - DEBUG - botocore.retryhandler - __call__: No retry needed.
2025-11-14 10:10:58,323 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.PutObject: calling handler <bound method S3RegionRedirectorv2.redirect_from_error of <botocore.utils.S3RegionRedirectorv2 object at 0x7f4951525910>>
2025-11-14 10:10:58,323 - DEBUG - root - wait_bootstrap: Wait for node 1 to bootstrap
2025-11-14 10:10:58,406 - DEBUG - root - wait_bootstrap: Node 1 has been bootstrapped
2025-11-14 10:10:58,480 - 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 `h5689307396129382274_test_projection_integer_type_validationfruitbucket`.`/` WITH\n            (\n                format=csv_with_names,\n                schema=\n                (\n                    Fruit String NOT NULL,\n                    year Int64\n                ),\n                partitioned_by=(year),\n                projection=$projection\n            )\n            "
  syntax: YQL_V1
}
execute_mode: RUN
idempotency_key: "2e0b03ea-82f5-4490-8caf-1ec391f78088"

2025-11-14 10:10:58,534 - DEBUG - root - create_query_impl: Result: query_id: "ptqudsej4jr2e8c7p59d"

2025-11-14 10:10:58,563 - DEBUG - root - describe_query: Result: query {
  meta {
    common {
      id: "ptqudsej4jr2e8c7p59d"
      created_by: "root@builtin"
      modified_by: "root@builtin"
      created_at {
        seconds: 1763115058
        nanos: 492973000
      }
      modified_at {
        seconds: 1763115058
        nanos: 492973000
      }
      revision: 1
    }
    execute_mode: RUN
    status: STARTING
    last_job_query_revision: 1
    last_job_id: "ptjudsej4jr2bunjf366-ptqudsej4jr2e8c7p59d"
    started_by: "root@builtin"
    submitted_at {
      seconds: 1763115058
      nanos: 492973000
    }
  }
  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 `h5689307396129382274_test_projection_integer_type_validationfruitbucket`.`/` WITH\n            (\n                format=csv_with_names,\n                schema=\n                (\n                    Fruit String NOT NULL,\n                    year Int64\n                ),\n                partitioned_by=(year),\n                projection=$projection\n            )\n            "
    syntax: YQL_V1
  }
}

2025-11-14 10:10:59,092 - DEBUG - root - describe_query: Result: ... (repeated, see above) ...
2025-11-14 10:10:59,641 - DEBUG - root - describe_query: Result: query {
  meta {
    common {
      id: "ptqudsej4jr2e8c7p59d"
      created_by: "root@builtin"
      modified_by: "root@builtin"
      created_at {
        seconds: 1763115058
        nanos: 492973000
      }
      modified_at {
        seconds: 1763115058
        nanos: 492973000
      }
      revision: 1
    }
    started_at {
      seconds: 1763115059
      nanos: 268000000
    }
    execute_mode: RUN
    status: FAILING
    last_job_query_revision: 1
    last_job_id: "ptjudsej4jr2bunjf366-ptqudsej4jr2e8c7p59d"
    started_by: "root@builtin"
    submitted_at {
      seconds: 1763115058
      nanos: 492973000
    }
  }
  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 `h5689307396129382274_test_projection_integer_type_validationfruitbucket`.`/` WITH\n            (\n                format=csv_with_names,\n                schema=\n                (\n                    Fruit String NOT NULL,\n                    year Int64\n                ),\n                partitioned_by=(year),\n                projection=$projection\n            )\n            "
    syntax: YQL_V1
  }
  plan {
    json: "{\"Detailed\":{\"Operations\":[{\"Id\":1,\"Name\":\"Commit!\"}],\"OperationRoot\":1,\"Providers\":[],\"OperationStats\":{\"Commit!\":1}},\"Basic\":{\"nodes\":[{\"id\":1,\"level\":1,\"name\":\"Commit!\",\"type\":\"op\"}],\"links\":[]}}"
  }
  issue {
    message: "Query failed with code ABORTED at 2025-11-14T10:10:59.460956Z"
    severity: 1
    issues {
      message: "Run query failed: Error"
      severity: 1
      issues {
        message: "Type annotation"
        issue_code: 1030
        severity: 1
        issues {
          position {
            row: 19
            column: 18
          }
          message: "At function: S3ReadObject!"
          end_position {
            row: 19
            column: 18
          }
          severity: 1
          issues {
            position {
              row: 22
              column: 17
            }
            message: "Projection column \"year\" has invalid type Optional<Int64>"
            end_position {
              row: 22
              column: 17
            }
            severity: 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 \'\"h5689307396129382274_test_projection_integer_type_validationfruitbucket\")\n(let $4 \'\"\\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 $5 \'(\'(\'\"partitionedby\" \'\"year\") \'(\'\"projection\" $4) \'(\'directories) \'(\'\"pathpattern\" \'\"*\") \'(\'\"pathpatternvariant\" \'\"FilePattern\")))\n(let $6 (S3Object \'(\'((String \'\"Paths {\\n  Name: \\\"2022-03-05\\\"\\n  Read: true\\n  IsDirectory: true\\n}\\n\") (Bool \'\"true\") (AsStruct \'(\'\"year\" (StrictCast (Int64 \'\"2022\") (OptionalType (DataType \'Int64))))))) \'\"csv_with_names\" $5))\n(let $7 (S3ReadObject! $2 (DataSource \'\"s3\" $3) $6 (StructType \'(\'\"Fruit\" (DataType \'String)) \'(\'\"year\" (OptionalType (DataType \'Int64)))) \'\"/ \" (lambda \'($12) (Bool \'\"true\")) \'(\'\"Fruit\" \'\"year\")))\n(let $8 (DataSink \'result))\n(let $9 (Right! $7))\n(let $10 (ResWrite! (Left! $7) $8 (Key) (RemovePrefixMembers (RemoveSystemMembers (PersistableRepr (SqlProject $9 \'((SqlProjectStarItem (TypeOf $9) \'\"\" (lambda \'($13) $13) \'()))))) \'(\'_yql_sys_)) \'(\'(\'type) \'(\'autoref))))\n(let $11 \'\"h5689307396129382274_test_projection_integer_type_validationfruitbucket\")\n(return (Commit! (Commit! $10 $8) (DataSink \'\"s3\" $11)))\n)\n"
  }
}

2025-11-14 10:11:00,196 - DEBUG - root - describe_query: Result: ... (repeated, see above) ...
2025-11-14 10:11:00,708 - DEBUG - root - describe_query: Result: query {
  meta {
    common {
      id: "ptqudsej4jr2e8c7p59d"
      created_by: "root@builtin"
      modified_by: "root@builtin"
      created_at {
        seconds: 1763115058
        nanos: 492973000
      }
      modified_at {
        seconds: 1763115058
        nanos: 492973000
      }
      revision: 1
    }
    started_at {
      seconds: 1763115059
      nanos: 268000000
    }
    finished_at {
      seconds: 1763115060
      nanos: 304000000
    }
    execute_mode: RUN
    status: FAILED
    last_job_query_revision: 1
    last_job_id: "ptjudsej4jr2bunjf366-ptqudsej4jr2e8c7p59d"
    started_by: "root@builtin"
    submitted_at {
      seconds: 1763115058
      nanos: 492973000
    }
  }
  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 `h5689307396129382274_test_projection_integer_type_validationfruitbucket`.`/` WITH\n            (\n                format=csv_with_names,\n                schema=\n                (\n                    Fruit String NOT NULL,\n                    year Int64\n                ),\n                partitioned_by=(year),\n                projection=$projection\n            )\n            "
    syntax: YQL_V1
  }
  plan {
    json: "{\"Detailed\":{\"Operations\":[{\"Id\":1,\"Name\":\"Commit!\"}],\"OperationRoot\":1,\"Providers\":[],\"OperationStats\":{\"Commit!\":1}},\"Basic\":{\"nodes\":[{\"id\":1,\"level\":1,\"name\":\"Commit!\",\"type\":\"op\"}],\"links\":[]}}"
  }
  issue {
    message: "Query failed with code ABORTED at 2025-11-14T10:10:59.460956Z"
    severity: 1
    issues {
      message: "Run query failed: Error"
      severity: 1
      issues {
        message: "Type annotation"
        issue_code: 1030
        severity: 1
        issues {
          position {
            row: 19
            column: 18
          }
          message: "At function: S3ReadObject!"
          end_position {
            row: 19
            column: 18
          }
          severity: 1
          issues {
            position {
              row: 22
              column: 17
            }
            message: "Projection column \"year\" has invalid type Optional<Int64>"
            end_position {
              row: 22
              column: 17
            }
            severity: 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 \'\"h5689307396129382274_test_projection_integer_type_validationfruitbucket\")\n(let $4 \'\"\\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 $5 \'(\'(\'\"partitionedby\" \'\"year\") \'(\'\"projection\" $4) \'(\'directories) \'(\'\"pathpattern\" \'\"*\") \'(\'\"pathpatternvariant\" \'\"FilePattern\")))\n(let $6 (S3Object \'(\'((String \'\"Paths {\\n  Name: \\\"2022-03-05\\\"\\n  Read: true\\n  IsDirectory: true\\n}\\n\") (Bool \'\"true\") (AsStruct \'(\'\"year\" (StrictCast (Int64 \'\"2022\") (OptionalType (DataType \'Int64))))))) \'\"csv_with_names\" $5))\n(let $7 (S3ReadObject! $2 (DataSource \'\"s3\" $3) $6 (StructType \'(\'\"Fruit\" (DataType \'String)) \'(\'\"year\" (OptionalType (DataType \'Int64)))) \'\"/ \" (lambda \'($12) (Bool \'\"true\")) \'(\'\"Fruit\" \'\"year\")))\n(let $8 (DataSink \'result))\n(let $9 (Right! $7))\n(let $10 (ResWrite! (Left! $7) $8 (Key) (RemovePrefixMembers (RemoveSystemMembers (PersistableRepr (SqlProject $9 \'((SqlProjectStarItem (TypeOf $9) \'\"\" (lambda \'($13) $13) \'()))))) \'(\'_yql_sys_)) \'(\'(\'type) \'(\'autoref))))\n(let $11 \'\"h5689307396129382274_test_projection_integer_type_validationfruitbucket\")\n(return (Commit! (Commit! $10 $8) (DataSink \'\"s3\" $11)))\n)\n"
  }
}

2025-11-14 10:11:00,726 - DEBUG - root - describe_query: Result: ... (repeated, see above) ...
2025-11-14 10:11:00,726 - INFO - root - test_projection_integer_type_validation: AST: (
(let $1 (Configure! world (DataSource '"config") '"DqEngine" '"force"))
(let $2 (Configure! $1 (DataSource '"s3" '"$all") '"Attr" '"useruntimelisting" '"false"))
(let $3 '"h5689307396129382274_test_projection_integer_type_validationfruitbucket")
(let $4 '"\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            ")
(let $5 '('('"partitionedby" '"year") '('"projection" $4) '('directories) '('"pathpattern" '"*") '('"pathpatternvariant" '"FilePattern")))
(let $6 (S3Object '('((String '"Paths {\n  Name: \"2022-03-05\"\n  Read: true\n  IsDirectory: true\n}\n") (Bool '"true") (AsStruct '('"year" (StrictCast (Int64 '"2022") (OptionalType (DataType 'Int64))))))) '"csv_with_names" $5))
(let $7 (S3ReadObject! $2 (DataSource '"s3" $3) $6 (StructType '('"Fruit" (DataType 'String)) '('"year" (OptionalType (DataType 'Int64)))) '"/ " (lambda '($12) (Bool '"true")) '('"Fruit" '"year")))
(let $8 (DataSink 'result))
(let $9 (Right! $7))
(let $10 (ResWrite! (Left! $7) $8 (Key) (RemovePrefixMembers (RemoveSystemMembers (PersistableRepr (SqlProject $9 '((SqlProjectStarItem (TypeOf $9) '"" (lambda '($13) $13) '()))))) '('_yql_sys_)) '('('type) '('autoref))))
(let $11 '"h5689307396129382274_test_projection_integer_type_validationfruitbucket")
(return (Commit! (Commit! $10 $8) (DataSink '"s3" $11)))
)

2025-11-14 10:11:00,729 - INFO - ya.test - pytest_runtest_teardown: Test teardown
