2025-12-12 13:26:17,418 - INFO - ya.test - pytest_runtest_setup: ####################################################################################################
2025-12-12 13:26:17,419 - INFO - ya.test - pytest_runtest_setup: test_projection_date_type_validation[v2-false-client10-year Utf8-False]
2025-12-12 13:26:17,419 - INFO - ya.test - pytest_runtest_setup: ####################################################################################################
2025-12-12 13:26:17,420 - INFO - ya.test - pytest_runtest_setup: Test setup
2025-12-12 13:26:17,496 - INFO - ya.test - pytest_runtest_call: Test call (class_name: test_explicit_partitioning_1.py::TestS3, test_name: test_projection_date_type_validation[v2-false-client10-year Utf8-False])
2025-12-12 13:26:17,497 - DEBUG - botocore.hooks - _emit: Event choose-service-name: calling handler <function handle_service_name_alias at 0x7f74a8b34a10>
2025-12-12 13:26:17,500 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function add_generate_presigned_post at 0x7f74a8c3c710>
2025-12-12 13:26:17,501 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function lazy_call.<locals>._handler at 0x7f74915dc590>
2025-12-12 13:26:17,501 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function add_generate_presigned_url at 0x7f74a8c3c410>
2025-12-12 13:26:17,504 - DEBUG - botocore.endpoint - create_endpoint: Setting s3 timeout as (60, 60)
2025-12-12 13:26:17,508 - DEBUG - botocore.client - _register_legacy_retries: Registering retry handlers for service: s3
2025-12-12 13:26:17,509 - DEBUG - botocore.utils - register: Registering S3 region redirector handler
2025-12-12 13:26:17,511 - DEBUG - boto3.resources.factory - load_from_definition: Loading s3:s3
2025-12-12 13:26:17,512 - DEBUG - boto3.resources.factory - load_from_definition: Loading s3:Bucket
2025-12-12 13:26:17,513 - DEBUG - boto3.resources.model - _load_name_with_category: Renaming Bucket attribute name
2025-12-12 13:26:17,514 - DEBUG - botocore.hooks - _emit: Event creating-resource-class.s3.Bucket: calling handler <function lazy_call.<locals>._handler at 0x7f74915dd0d0>
2025-12-12 13:26:17,514 - DEBUG - boto3.resources.action - __call__: Calling s3:create_bucket with {'Bucket': 'test_projection_date_type_invalid_validation', 'ACL': 'public-read'}
2025-12-12 13:26:17,519 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <function validate_bucket_name at 0x7f74a8b368d0>
2025-12-12 13:26:17,520 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <function remove_bucket_from_url_paths_from_model at 0x7f74a8b59190>
2025-12-12 13:26:17,520 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <bound method S3RegionRedirectorv2.annotate_request_context of <botocore.utils.S3RegionRedirectorv2 object at 0x7f748c1dd4b0>>
2025-12-12 13:26:17,520 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <function generate_idempotent_uuid at 0x7f74a8b36690>
2025-12-12 13:26:17,520 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <function customize_endpoint_resolver_builtins at 0x7f74a8b593d0>
2025-12-12 13:26:17,521 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <bound method S3RegionRedirectorv2.redirect_from_cache of <botocore.utils.S3RegionRedirectorv2 object at 0x7f748c1dd4b0>>
2025-12-12 13:26:17,521 - DEBUG - botocore.regions - construct_endpoint: Calling endpoint provider with parameters: {'Bucket': 'test_projection_date_type_invalid_validation', 'Region': 'yandex', 'UseFIPS': False, 'UseDualStack': False, 'Endpoint': 'http://localhost:29926', 'ForcePathStyle': True, 'Accelerate': False, 'UseGlobalEndpoint': False, 'DisableAccessPoints': True, 'DisableMultiRegionAccessPoints': False, 'UseArnRegion': True}
2025-12-12 13:26:17,522 - DEBUG - botocore.regions - construct_endpoint: Endpoint provider result: http://localhost:29926/test_projection_date_type_invalid_validation
2025-12-12 13:26:17,522 - 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-12-12 13:26:17,523 - 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-12-12 13:26:17,523 - DEBUG - botocore.hooks - _emit: Event before-call.s3.CreateBucket: calling handler <function add_expect_header at 0x7f74a8b36d50>
2025-12-12 13:26:17,524 - DEBUG - botocore.hooks - _emit: Event before-call.s3.CreateBucket: calling handler <function add_recursion_detection_header at 0x7f74a8b34c50>
2025-12-12 13:26:17,524 - DEBUG - botocore.hooks - _emit: Event before-call.s3.CreateBucket: calling handler <function inject_api_version_header_if_needed at 0x7f74a8b587d0>
2025-12-12 13:26:17,524 - 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_date_type_invalid_validation/', 'url': 'http://localhost:29926/test_projection_date_type_invalid_validation', 'context': {'client_region': 'yandex', 'client_config': <botocore.config.Config object at 0x7f748c2dfbc0>, 'has_streaming_input': False, 'auth_type': 'v4', 's3_redirect': {'redirected': False, 'bucket': 'test_projection_date_type_invalid_validation', 'params': {'Bucket': 'test_projection_date_type_invalid_validation', 'ACL': 'public-read'}}, 'signing': {'region': 'yandex', 'signing_name': 's3', 'disableDoubleEncoding': True}}}
2025-12-12 13:26:17,525 - DEBUG - botocore.hooks - _emit: Event request-created.s3.CreateBucket: calling handler <bound method RequestSigner.handler of <botocore.signers.RequestSigner object at 0x7f748c2dc970>>
2025-12-12 13:26:17,525 - 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 0x7f748c4b0560>>
2025-12-12 13:26:17,525 - DEBUG - botocore.hooks - _emit: Event choose-signer.s3.CreateBucket: calling handler <function set_operation_specific_signer at 0x7f74a8b36510>
2025-12-12 13:26:17,526 - DEBUG - botocore.hooks - _emit: Event before-sign.s3.CreateBucket: calling handler <function remove_arn_from_signing_path at 0x7f74a8b59310>
2025-12-12 13:26:17,526 - DEBUG - botocore.auth - add_auth: Calculating signature using v4 auth.
2025-12-12 13:26:17,527 - DEBUG - botocore.auth - add_auth: CanonicalRequest:
PUT
/test_projection_date_type_invalid_validation

host:localhost:29926
x-amz-acl:public-read
x-amz-content-sha256:e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
x-amz-date:20251212T132617Z

host;x-amz-acl;x-amz-content-sha256;x-amz-date
e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
2025-12-12 13:26:17,535 - DEBUG - botocore.auth - add_auth: StringToSign:
AWS4-HMAC-SHA256
20251212T132617Z
20251212/yandex/s3/aws4_request
343387476e07f7c70681fe17eae7f67ac7e1d57d72e968d0c61e4a4df37c25e6
2025-12-12 13:26:17,535 - DEBUG - botocore.auth - add_auth: Signature:
05d449004c635e0b3c358a02219d95153aeac6b3e136b026836fa96390c84e67
2025-12-12 13:26:17,536 - DEBUG - botocore.hooks - _emit: Event request-created.s3.CreateBucket: calling handler <function add_retry_headers at 0x7f74a8b590d0>
2025-12-12 13:26:17,537 - DEBUG - botocore.endpoint - _do_get_response: Sending http request: <AWSPreparedRequest stream_output=False, method=PUT, url=http://localhost:29926/test_projection_date_type_invalid_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'20251212T132617Z', 'X-Amz-Content-SHA256': b'e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855', 'Authorization': b'AWS4-HMAC-SHA256 Credential=key/20251212/yandex/s3/aws4_request, SignedHeaders=host;x-amz-acl;x-amz-content-sha256;x-amz-date, Signature=05d449004c635e0b3c358a02219d95153aeac6b3e136b026836fa96390c84e67', 'amz-sdk-invocation-id': b'9abe43ea-8678-4323-93e8-ebd3aa34242e', 'amz-sdk-request': b'attempt=1', 'Content-Length': '0'}>
2025-12-12 13:26:17,550 - DEBUG - botocore.parsers - parse: Response headers: {'Server': 'Werkzeug/2.2.3 Python/3.12.9', 'Date': 'Fri, 12 Dec 2025 13:26:17 GMT', 'x-amzn-requestid': 'lgbubrgpP6X03QfFekFDCNiB812y01p7J1cyQVnwJGuxElMwFnr1', 'Content-Type': 'text/html; charset=utf-8', 'Content-Length': '198', 'Access-Control-Allow-Origin': '*', 'Connection': 'close'}
2025-12-12 13:26:17,551 - DEBUG - botocore.parsers - parse: Response body:
b'<CreateBucketResponse xmlns="http://s3.amazonaws.com/doc/2006-03-01"><CreateBucketResponse><Bucket>test_projection_date_type_invalid_validation</Bucket></CreateBucketResponse></CreateBucketResponse>'
2025-12-12 13:26:17,552 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.CreateBucket: calling handler <botocore.retryhandler.RetryHandler object at 0x7f748c04deb0>
2025-12-12 13:26:17,552 - DEBUG - botocore.retryhandler - __call__: No retry needed.
2025-12-12 13:26:17,552 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.CreateBucket: calling handler <bound method S3RegionRedirectorv2.redirect_from_error of <botocore.utils.S3RegionRedirectorv2 object at 0x7f748c1dd4b0>>
2025-12-12 13:26:17,553 - DEBUG - boto3.resources.action - __call__: Response: {'ResponseMetadata': {'RequestId': 'lgbubrgpP6X03QfFekFDCNiB812y01p7J1cyQVnwJGuxElMwFnr1', 'HTTPStatusCode': 200, 'HTTPHeaders': {'server': 'Werkzeug/2.2.3 Python/3.12.9', 'date': 'Fri, 12 Dec 2025 13:26:17 GMT', 'x-amzn-requestid': 'lgbubrgpP6X03QfFekFDCNiB812y01p7J1cyQVnwJGuxElMwFnr1', 'content-type': 'text/html; charset=utf-8', 'content-length': '198', 'access-control-allow-origin': '*', 'connection': 'close'}, 'RetryAttempts': 0}}
2025-12-12 13:26:17,553 - DEBUG - botocore.hooks - _emit: Event choose-service-name: calling handler <function handle_service_name_alias at 0x7f74a8b34a10>
2025-12-12 13:26:17,556 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function add_generate_presigned_post at 0x7f74a8c3c710>
2025-12-12 13:26:17,556 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function lazy_call.<locals>._handler at 0x7f74915dc590>
2025-12-12 13:26:17,556 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function add_generate_presigned_url at 0x7f74a8c3c410>
2025-12-12 13:26:17,560 - DEBUG - botocore.endpoint - create_endpoint: Setting s3 timeout as (60, 60)
2025-12-12 13:26:17,564 - DEBUG - botocore.client - _register_legacy_retries: Registering retry handlers for service: s3
2025-12-12 13:26:17,565 - DEBUG - botocore.utils - register: Registering S3 region redirector handler
2025-12-12 13:26:17,567 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function validate_ascii_metadata at 0x7f74a8b37950>
2025-12-12 13:26:17,567 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function sse_md5 at 0x7f74a8b36990>
2025-12-12 13:26:17,567 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function convert_body_to_file_like_object at 0x7f74a8b58650>
2025-12-12 13:26:17,567 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function validate_bucket_name at 0x7f74a8b368d0>
2025-12-12 13:26:17,568 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function remove_bucket_from_url_paths_from_model at 0x7f74a8b59190>
2025-12-12 13:26:17,568 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <bound method S3RegionRedirectorv2.annotate_request_context of <botocore.utils.S3RegionRedirectorv2 object at 0x7f748c198380>>
2025-12-12 13:26:17,568 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function generate_idempotent_uuid at 0x7f74a8b36690>
2025-12-12 13:26:17,568 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <function customize_endpoint_resolver_builtins at 0x7f74a8b593d0>
2025-12-12 13:26:17,569 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <bound method S3RegionRedirectorv2.redirect_from_cache of <botocore.utils.S3RegionRedirectorv2 object at 0x7f748c198380>>
2025-12-12 13:26:17,569 - DEBUG - botocore.regions - construct_endpoint: Calling endpoint provider with parameters: {'Bucket': 'test_projection_date_type_invalid_validation', 'Region': 'yandex', 'UseFIPS': False, 'UseDualStack': False, 'Endpoint': 'http://localhost:29926', 'ForcePathStyle': True, 'Accelerate': False, 'UseGlobalEndpoint': False, 'DisableMultiRegionAccessPoints': False, 'UseArnRegion': True}
2025-12-12 13:26:17,570 - DEBUG - botocore.regions - construct_endpoint: Endpoint provider result: http://localhost:29926/test_projection_date_type_invalid_validation
2025-12-12 13:26:17,570 - 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-12-12 13:26:17,571 - 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-12-12 13:26:17,572 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function conditionally_calculate_md5 at 0x7f74a8d4f890>
2025-12-12 13:26:17,572 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function add_expect_header at 0x7f74a8b36d50>
2025-12-12 13:26:17,572 - DEBUG - botocore.handlers - add_expect_header: Adding expect 100 continue header to request.
2025-12-12 13:26:17,572 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function add_recursion_detection_header at 0x7f74a8b34c50>
2025-12-12 13:26:17,572 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function inject_api_version_header_if_needed at 0x7f74a8b587d0>
2025-12-12 13:26:17,573 - 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 0x7f748c20ea50>, 'auth_path': '/test_projection_date_type_invalid_validation/2022-03-05/fruits.csv', 'url': 'http://localhost:29926/test_projection_date_type_invalid_validation/2022-03-05/fruits.csv', 'context': {'client_region': 'yandex', 'client_config': <botocore.config.Config object at 0x7f748c198150>, 'has_streaming_input': True, 'auth_type': 'v4', 's3_redirect': {'redirected': False, 'bucket': 'test_projection_date_type_invalid_validation', 'params': {'Body': <_io.BytesIO object at 0x7f748c20ea50>, 'Bucket': 'test_projection_date_type_invalid_validation', 'Key': '2022-03-05/fruits.csv', 'ContentType': 'text/plain'}}, 'signing': {'region': 'yandex', 'signing_name': 's3', 'disableDoubleEncoding': True}}}
2025-12-12 13:26:17,574 - DEBUG - botocore.hooks - _emit: Event request-created.s3.PutObject: calling handler <bound method RequestSigner.handler of <botocore.signers.RequestSigner object at 0x7f748c19bfd0>>
2025-12-12 13:26:17,574 - 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 0x7f74947bc560>>
2025-12-12 13:26:17,574 - DEBUG - botocore.hooks - _emit: Event choose-signer.s3.PutObject: calling handler <function set_operation_specific_signer at 0x7f74a8b36510>
2025-12-12 13:26:17,575 - DEBUG - botocore.hooks - _emit: Event before-sign.s3.PutObject: calling handler <function remove_arn_from_signing_path at 0x7f74a8b59310>
2025-12-12 13:26:17,575 - DEBUG - botocore.auth - add_auth: Calculating signature using v4 auth.
2025-12-12 13:26:17,576 - DEBUG - botocore.auth - add_auth: CanonicalRequest:
PUT
/test_projection_date_type_invalid_validation/2022-03-05/fruits.csv

content-md5:N3CmbcSU7yYXwHhfTRLclg==
content-type:text/plain
host:localhost:29926
x-amz-content-sha256:d9ec952678723e7b44be7f7b160b98addbf1b6aa7e33a7bac583215ee511bbcb
x-amz-date:20251212T132617Z

content-md5;content-type;host;x-amz-content-sha256;x-amz-date
d9ec952678723e7b44be7f7b160b98addbf1b6aa7e33a7bac583215ee511bbcb
2025-12-12 13:26:17,576 - DEBUG - botocore.auth - add_auth: StringToSign:
AWS4-HMAC-SHA256
20251212T132617Z
20251212/yandex/s3/aws4_request
e59f69675ff8ef45a4c37aa9a62ed48574c478c2d072b3c52a7e5466d127318b
2025-12-12 13:26:17,576 - DEBUG - botocore.auth - add_auth: Signature:
3af9e476b26df8315e9531c3f1ee771398061c8de07a6d709cc31e4cd73959a5
2025-12-12 13:26:17,576 - DEBUG - botocore.hooks - _emit: Event request-created.s3.PutObject: calling handler <function add_retry_headers at 0x7f74a8b590d0>
2025-12-12 13:26:17,577 - DEBUG - botocore.endpoint - _do_get_response: Sending http request: <AWSPreparedRequest stream_output=False, method=PUT, url=http://localhost:29926/test_projection_date_type_invalid_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'20251212T132617Z', 'X-Amz-Content-SHA256': b'd9ec952678723e7b44be7f7b160b98addbf1b6aa7e33a7bac583215ee511bbcb', 'Authorization': b'AWS4-HMAC-SHA256 Credential=key/20251212/yandex/s3/aws4_request, SignedHeaders=content-md5;content-type;host;x-amz-content-sha256;x-amz-date, Signature=3af9e476b26df8315e9531c3f1ee771398061c8de07a6d709cc31e4cd73959a5', 'amz-sdk-invocation-id': b'0d748fec-fd5f-43ab-a287-89b02ccc7af7', 'amz-sdk-request': b'attempt=1', 'Content-Length': '33'}>
2025-12-12 13:26:17,579 - DEBUG - botocore.awsrequest - _send_output: Waiting for 100 Continue response.
2025-12-12 13:26:17,581 - DEBUG - botocore.awsrequest - _handle_expect_response: 100 Continue response seen, now sending request body.
2025-12-12 13:26:17,585 - DEBUG - botocore.parsers - parse: Response headers: {'Server': 'Werkzeug/2.2.3 Python/3.12.9', 'Date': 'Fri, 12 Dec 2025 13:26:17 GMT', 'ETag': '"3770a66dc494ef2617c0785f4d12dc96"', 'last-modified': 'Fri, 12 Dec 2025 13:26:17 GMT', 'Content-Length': '0', 'x-amzn-requestid': 'xnj3cSnPy8GFyvoRRk8EATaPaGZa3w7q1L0bxir8Li71T8cDX2Gw', 'Content-Type': 'text/html; charset=utf-8', 'Access-Control-Allow-Origin': '*', 'Connection': 'close'}
2025-12-12 13:26:17,585 - DEBUG - botocore.parsers - parse: Response body:
b''
2025-12-12 13:26:17,586 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.PutObject: calling handler <botocore.retryhandler.RetryHandler object at 0x7f7494707b20>
2025-12-12 13:26:17,587 - DEBUG - botocore.retryhandler - __call__: No retry needed.
2025-12-12 13:26:17,587 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.PutObject: calling handler <bound method S3RegionRedirectorv2.redirect_from_error of <botocore.utils.S3RegionRedirectorv2 object at 0x7f748c198380>>
2025-12-12 13:26:17,587 - DEBUG - root - wait_bootstrap: Wait for node 1 to bootstrap
2025-12-12 13:26:17,614 - DEBUG - root - wait_bootstrap: Node 1 has been bootstrapped
2025-12-12 13:26:17,664 - 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\" : \"date\",\n                \"projection.year.min\" : \"2022-01-01\",\n                \"projection.year.max\" : \"2022-01-01\",\n                \"projection.year.format\" : \"%Y\",\n                \"projection.year.interval\" : \"1\",\n                \"projection.year.unit\" : \"DAYS\",\n\n                \"storage.location.template\" : \"${year}-03-05\"\n            }\n            @@;\n            \n            SELECT *\n            FROM `h2419604815326425151_test_projection_date_type_validationfruitbucket`.`/` WITH\n            (\n                format=csv_with_names,\n                schema=\n                (\n                    Fruit String NOT NULL,\n                    year Utf8\n                ),\n                partitioned_by=(year),\n                projection=$projection\n            )\n            "
  syntax: YQL_V1
}
execute_mode: RUN
idempotency_key: "8096fb82-8920-44ea-8490-9d9b701b81c7"

2025-12-12 13:26:17,684 - DEBUG - root - create_query_impl: Result: query_id: "ptqudq7r5il6ao5njbrb"

2025-12-12 13:26:17,695 - DEBUG - root - describe_query: Result: query {
  meta {
    common {
      id: "ptqudq7r5il6ao5njbrb"
      created_by: "root@builtin"
      modified_by: "root@builtin"
      created_at {
        seconds: 1765545977
        nanos: 669277000
      }
      modified_at {
        seconds: 1765545977
        nanos: 669277000
      }
      revision: 1
    }
    execute_mode: RUN
    status: STARTING
    last_job_query_revision: 1
    last_job_id: "ptjudq7r5il68dsgq7tk-ptqudq7r5il6ao5njbrb"
    started_by: "root@builtin"
    submitted_at {
      seconds: 1765545977
      nanos: 669277000
    }
  }
  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\" : \"date\",\n                \"projection.year.min\" : \"2022-01-01\",\n                \"projection.year.max\" : \"2022-01-01\",\n                \"projection.year.format\" : \"%Y\",\n                \"projection.year.interval\" : \"1\",\n                \"projection.year.unit\" : \"DAYS\",\n\n                \"storage.location.template\" : \"${year}-03-05\"\n            }\n            @@;\n            \n            SELECT *\n            FROM `h2419604815326425151_test_projection_date_type_validationfruitbucket`.`/` WITH\n            (\n                format=csv_with_names,\n                schema=\n                (\n                    Fruit String NOT NULL,\n                    year Utf8\n                ),\n                partitioned_by=(year),\n                projection=$projection\n            )\n            "
    syntax: YQL_V1
  }
}

2025-12-12 13:26:18,208 - DEBUG - root - describe_query: Result: query {
  meta {
    common {
      id: "ptqudq7r5il6ao5njbrb"
      created_by: "root@builtin"
      modified_by: "root@builtin"
      created_at {
        seconds: 1765545977
        nanos: 669277000
      }
      modified_at {
        seconds: 1765545977
        nanos: 669277000
      }
      revision: 1
    }
    started_at {
      seconds: 1765545978
      nanos: 78000000
    }
    execute_mode: RUN
    status: RUNNING
    last_job_query_revision: 1
    last_job_id: "ptjudq7r5il68dsgq7tk-ptqudq7r5il6ao5njbrb"
    started_by: "root@builtin"
    submitted_at {
      seconds: 1765545977
      nanos: 669277000
    }
  }
  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\" : \"date\",\n                \"projection.year.min\" : \"2022-01-01\",\n                \"projection.year.max\" : \"2022-01-01\",\n                \"projection.year.format\" : \"%Y\",\n                \"projection.year.interval\" : \"1\",\n                \"projection.year.unit\" : \"DAYS\",\n\n                \"storage.location.template\" : \"${year}-03-05\"\n            }\n            @@;\n            \n            SELECT *\n            FROM `h2419604815326425151_test_projection_date_type_validationfruitbucket`.`/` WITH\n            (\n                format=csv_with_names,\n                schema=\n                (\n                    Fruit String NOT NULL,\n                    year Utf8\n                ),\n                partitioned_by=(year),\n                projection=$projection\n            )\n            "
    syntax: YQL_V1
  }
  plan {
    json: "{}"
  }
  issue {
    message: "Type annotation"
    issue_code: 1030
    severity: 1
    issues {
      position {
        row: 21
        column: 18
      }
      message: "At function: S3ReadObject!"
      end_position {
        row: 21
        column: 18
      }
      severity: 1
      issues {
        position {
          row: 24
          column: 17
        }
        message: "Projection column \"year\" has invalid type Optional<Utf8>"
        end_position {
          row: 24
          column: 17
        }
        severity: 1
      }
    }
  }
  statistics {
    json: "{}"
  }
  ast {
    data: "(\n(let $1 (Configure! world (DataSource \'\"s3\" \'\"$all\") \'\"Attr\" \'\"useruntimelisting\" \'\"false\"))\n(let $2 \'\"/local/h2419604815326425151_test_projection_date_type_validationfruitbucket\")\n(let $3 (OptionalType (DataType \'Utf8)))\n(let $4 \'(\'\"partitionedby\" \'\"year\"))\n(let $5 \'\"\\n            {\\n                \\\"projection.enabled\\\" : true,\\n\\n                \\\"projection.year.type\\\" : \\\"date\\\",\\n                \\\"projection.year.min\\\" : \\\"2022-01-01\\\",\\n                \\\"projection.year.max\\\" : \\\"2022-01-01\\\",\\n                \\\"projection.year.format\\\" : \\\"%Y\\\",\\n                \\\"projection.year.interval\\\" : \\\"1\\\",\\n                \\\"projection.year.unit\\\" : \\\"DAYS\\\",\\n\\n                \\\"storage.location.template\\\" : \\\"${year}-03-05\\\"\\n            }\\n            \")\n(let $6 \'(\'\"projection\" $5))\n(let $7 \'($4 $6 \'(\'directories) \'(\'\"pathpattern\" \'\"*\") \'(\'\"pathpatternvariant\" \'\"FilePattern\")))\n(let $8 (S3Object \'(\'((String \'\"Paths {\\n  Name: \\\"2022-03-05\\\"\\n  Read: true\\n  IsDirectory: true\\n}\\n\") (Bool \'\"true\") (AsStruct \'(\'\"year\" (StrictCast (Date \'\"2022-01-01\") $3))))) \'\"csv_with_names\" $7))\n(let $9 (StructType \'(\'\"Fruit\" (DataType \'String)) \'(\'\"year\" (OptionalType (DataType \'Utf8)))))\n(let $10 \'(\'\"Fruit\" \'\"year\"))\n(let $11 (DataSink \'result))\n(let $12 \'($4 $6 \'(\'directories) \'(\'\"pathpattern\" \'\"*\") \'(\'\"pathpatternvariant\" \'\"FilePattern\")))\n(let $13 (S3Object \'(\'((String \'\"Paths {\\n  Name: \\\"2022-03-05\\\"\\n  Read: true\\n  IsDirectory: true\\n}\\n\") (Bool \'\"true\") (AsStruct \'(\'\"year\" (StrictCast (Date \'\"2022-01-01\") $3))))) \'\"csv_with_names\" $12))\n(let $14 (Right! (S3ReadObject! $1 (DataSource \'\"s3\" $2) $13 $9 \'\"/ \" (lambda \'($17) (Bool \'\"true\")) $10)))\n(let $15 (ResWrite! (Left! (S3ReadObject! $1 (DataSource \'\"s3\" $2) $8 $9 \'\"/ \" (lambda \'($16) (Bool \'\"true\")) $10)) $11 (Key) (RemovePrefixMembers (RemoveSystemMembers (PersistableRepr (SqlProject $14 \'((SqlProjectStarItem (TypeOf $14) \'\"\" (lambda \'($18) $18) \'()))))) \'(\'_yql_sys_)) \'(\'(\'type) \'(\'autoref))))\n(return (Commit! (Commit! $15 $11) (DataSink \'\"kikimr\" \'\"db\") \'(\'(\'\"mode\" \'\"flush\"))))\n)\n"
  }
  timeline {
    svg: "<svg width=\'1280\' height=\'0\' xmlns=\'http://www.w3.org/2000/svg\'>\n<clipPath id=\'clipTextPath\'><rect x=\'0\' y=\'0\' width=\'298\' height=\'0\'/></clipPath>\n\n<defs>\n\n<g id=\'icon_memory\'>\n  <path fill-rule=\'evenodd\' clip-rule=\'evenodd\' d=\'M5 3C3.89543 3 3 3.89543 3 5H1V7H3V9H1V11H3V13H1V15H3V17H1V19H3C3 20.1046 3.89543 21 5 21H9C10.1046 21 11 20.1046 11 19H13C13 20.1046 13.8954 21 15 21H19C20.1046 21 21 20.1046 21 19H23V17H21V15H23V13H21V11H23V9H21V7H23V5H21C21 3.89543 20.1046 3 19 3H15C13.8954 3 13 3.89543 13 5H11C11 3.89543 10.1046 3 9 3H5ZM11 7V9H13V7H11ZM11 11V13H13V11H11ZM11 15V17H13V15H11ZM5 5H9V19H5V5ZM15 5H19V19H15V5Z\' />\n</g>\n\n<g id=\'icon_cpu\'>\n  <path d=\'M13.9802 7.75H10.0102C8.76023 7.75 7.74023 8.76 7.74023 10.02V13.99C7.74023 15.24 8.75023 16.26 10.0102 16.26H13.9802C15.2302 16.26 16.2502 15.25 16.2502 13.99V10.02C16.2502 8.76 15.2402 7.75 13.9802 7.75ZM13.5002 12.98L12.6102 14.53C12.4802 14.76 12.2402 14.88 12.0002 14.88C11.8802 14.88 11.7502 14.85 11.6502 14.79C11.3102 14.6 11.1902 14.17 11.3902 13.83L12.0302 12.72H11.4702C11.0202 12.72 10.6502 12.52 10.4502 12.18C10.2502 11.84 10.2702 11.42 10.5002 11.03L11.3902 9.48C11.5902 9.14 12.0202 9.03 12.3502 9.22C12.6902 9.41 12.8102 9.84 12.6102 10.18L11.9702 11.29H12.5302C12.9802 11.29 13.3502 11.49 13.5502 11.83C13.7502 12.17 13.7302 12.59 13.5002 12.98Z\' />\n  <path d=\'M21.25 12.75C21.67 12.75 22 12.41 22 12C22 11.58 21.67 11.25 21.25 11.25H20V9.05H21.25C21.67 9.05 22 8.72 22 8.3C22 7.89 21.67 7.55 21.25 7.55H19.77C19.29 5.96 18.04 4.71 16.45 4.23V2.75C16.45 2.34 16.11 2 15.7 2C15.29 2 14.95 2.34 14.95 2.75V4H12.75V2.75C12.75 2.34 12.41 2 12 2C11.59 2 11.25 2.34 11.25 2.75V4H9.06V2.75C9.06 2.34 8.72 2 8.31 2C7.89 2 7.56 2.34 7.56 2.75V4.23C5.96 4.71 4.71 5.96 4.23 7.55H2.75C2.34 7.55 2 7.89 2 8.3C2 8.72 2.34 9.05 2.75 9.05H4V11.25H2.75C2.34 11.25 2 11.58 2 12C2 12.41 2.34 12.75 2.75 12.75H4V14.95H2.75C2.34 14.95 2 15.28 2 15.7C2 16.11 2.34 16.45 2.75 16.45H4.23C4.7 18.04 5.96 19.29 7.56 19.77V21.25C7.56 21.66 7.89 22 8.31 22C8.72 22 9.06 21.66 9.06 21.25V20H11.26V21.25C11.26 21.66 11.59 22 12.01 22C12.42 22 12.76 21.66 12.76 21.25V20H14.95V21.25C14.95 21.66 15.29 22 15.7 22C16.11 22 16.45 21.66 16.45 21.25V19.77C18.04 19.29 19.29 18.04 19.77 16.45H21.25C21.67 16.45 22 16.11 22 15.7C22 15.28 21.67 14.95 21.25 14.95H20V12.75H21.25ZM17.26 14.26C17.26 15.91 15.91 17.26 14.26 17.26H9.74C8.09 17.26 6.74 15.91 6.74 14.26V9.74C6.74 8.09 8.09 6.74 9.74 6.74H14.26C15.91 6.74 17.26 8.09 17.26 9.74V14.26Z\' />\n</g>\n\n<g id=\'icon_input\'>\n  <path d=\'M3 6L6 6L6 12L10 12L10 6L13 6V5L8 0L3 5L3 6Z\' />\n  <path d=\'M2 16L14 16V14L2 14V16Z\' />\n</g>\n\n<g id=\'icon_output\'>\n  <path d=\'M13 9H10V16H6V9L3 9V8L8 3L13 8V9Z\' />\n  <path d=\'M14 2H2V0H14V2Z\' />\n</g>\n\n</defs>\n\n<line x1=\'600\' y1=\'0\' x2=\'600\' y2=\'0\' stroke-width=\'1\' stroke=\'var(--stage-grid, #B2B2B2)\' stroke-dasharray=\'1,2\'/>\n\n</svg>\n"
  }
}

2025-12-12 13:26:18,721 - DEBUG - root - describe_query: Result: query {
  meta {
    common {
      id: "ptqudq7r5il6ao5njbrb"
      created_by: "root@builtin"
      modified_by: "root@builtin"
      created_at {
        seconds: 1765545977
        nanos: 669277000
      }
      modified_at {
        seconds: 1765545977
        nanos: 669277000
      }
      revision: 1
    }
    started_at {
      seconds: 1765545978
      nanos: 78000000
    }
    execute_mode: RUN
    status: FAILING
    last_job_query_revision: 1
    last_job_id: "ptjudq7r5il68dsgq7tk-ptqudq7r5il6ao5njbrb"
    started_by: "root@builtin"
    submitted_at {
      seconds: 1765545977
      nanos: 669277000
    }
  }
  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\" : \"date\",\n                \"projection.year.min\" : \"2022-01-01\",\n                \"projection.year.max\" : \"2022-01-01\",\n                \"projection.year.format\" : \"%Y\",\n                \"projection.year.interval\" : \"1\",\n                \"projection.year.unit\" : \"DAYS\",\n\n                \"storage.location.template\" : \"${year}-03-05\"\n            }\n            @@;\n            \n            SELECT *\n            FROM `h2419604815326425151_test_projection_date_type_validationfruitbucket`.`/` WITH\n            (\n                format=csv_with_names,\n                schema=\n                (\n                    Fruit String NOT NULL,\n                    year Utf8\n                ),\n                partitioned_by=(year),\n                projection=$projection\n            )\n            "
    syntax: YQL_V1
  }
  plan {
    json: "{}"
  }
  issue {
    message: "Query failed with code GENERIC_ERROR at 2025-12-12T13:26:18.202926Z"
    severity: 1
    issues {
      message: "Type annotation"
      issue_code: 1030
      severity: 1
      issues {
        position {
          row: 21
          column: 18
        }
        message: "At function: S3ReadObject!"
        end_position {
          row: 21
          column: 18
        }
        severity: 1
        issues {
          position {
            row: 24
            column: 17
          }
          message: "Projection column \"year\" has invalid type Optional<Utf8>"
          end_position {
            row: 24
            column: 17
          }
          severity: 1
        }
      }
    }
  }
  statistics {
    json: "{}"
  }
  ast {
    data: "(\n(let $1 (Configure! world (DataSource \'\"s3\" \'\"$all\") \'\"Attr\" \'\"useruntimelisting\" \'\"false\"))\n(let $2 \'\"/local/h2419604815326425151_test_projection_date_type_validationfruitbucket\")\n(let $3 (OptionalType (DataType \'Utf8)))\n(let $4 \'(\'\"partitionedby\" \'\"year\"))\n(let $5 \'\"\\n            {\\n                \\\"projection.enabled\\\" : true,\\n\\n                \\\"projection.year.type\\\" : \\\"date\\\",\\n                \\\"projection.year.min\\\" : \\\"2022-01-01\\\",\\n                \\\"projection.year.max\\\" : \\\"2022-01-01\\\",\\n                \\\"projection.year.format\\\" : \\\"%Y\\\",\\n                \\\"projection.year.interval\\\" : \\\"1\\\",\\n                \\\"projection.year.unit\\\" : \\\"DAYS\\\",\\n\\n                \\\"storage.location.template\\\" : \\\"${year}-03-05\\\"\\n            }\\n            \")\n(let $6 \'(\'\"projection\" $5))\n(let $7 \'($4 $6 \'(\'directories) \'(\'\"pathpattern\" \'\"*\") \'(\'\"pathpatternvariant\" \'\"FilePattern\")))\n(let $8 (S3Object \'(\'((String \'\"Paths {\\n  Name: \\\"2022-03-05\\\"\\n  Read: true\\n  IsDirectory: true\\n}\\n\") (Bool \'\"true\") (AsStruct \'(\'\"year\" (StrictCast (Date \'\"2022-01-01\") $3))))) \'\"csv_with_names\" $7))\n(let $9 (StructType \'(\'\"Fruit\" (DataType \'String)) \'(\'\"year\" (OptionalType (DataType \'Utf8)))))\n(let $10 \'(\'\"Fruit\" \'\"year\"))\n(let $11 (DataSink \'result))\n(let $12 \'($4 $6 \'(\'directories) \'(\'\"pathpattern\" \'\"*\") \'(\'\"pathpatternvariant\" \'\"FilePattern\")))\n(let $13 (S3Object \'(\'((String \'\"Paths {\\n  Name: \\\"2022-03-05\\\"\\n  Read: true\\n  IsDirectory: true\\n}\\n\") (Bool \'\"true\") (AsStruct \'(\'\"year\" (StrictCast (Date \'\"2022-01-01\") $3))))) \'\"csv_with_names\" $12))\n(let $14 (Right! (S3ReadObject! $1 (DataSource \'\"s3\" $2) $13 $9 \'\"/ \" (lambda \'($17) (Bool \'\"true\")) $10)))\n(let $15 (ResWrite! (Left! (S3ReadObject! $1 (DataSource \'\"s3\" $2) $8 $9 \'\"/ \" (lambda \'($16) (Bool \'\"true\")) $10)) $11 (Key) (RemovePrefixMembers (RemoveSystemMembers (PersistableRepr (SqlProject $14 \'((SqlProjectStarItem (TypeOf $14) \'\"\" (lambda \'($18) $18) \'()))))) \'(\'_yql_sys_)) \'(\'(\'type) \'(\'autoref))))\n(return (Commit! (Commit! $15 $11) (DataSink \'\"kikimr\" \'\"db\") \'(\'(\'\"mode\" \'\"flush\"))))\n)\n"
  }
  timeline {
    svg: "<svg width=\'1280\' height=\'0\' xmlns=\'http://www.w3.org/2000/svg\'>\n<clipPath id=\'clipTextPath\'><rect x=\'0\' y=\'0\' width=\'298\' height=\'0\'/></clipPath>\n\n<defs>\n\n<g id=\'icon_memory\'>\n  <path fill-rule=\'evenodd\' clip-rule=\'evenodd\' d=\'M5 3C3.89543 3 3 3.89543 3 5H1V7H3V9H1V11H3V13H1V15H3V17H1V19H3C3 20.1046 3.89543 21 5 21H9C10.1046 21 11 20.1046 11 19H13C13 20.1046 13.8954 21 15 21H19C20.1046 21 21 20.1046 21 19H23V17H21V15H23V13H21V11H23V9H21V7H23V5H21C21 3.89543 20.1046 3 19 3H15C13.8954 3 13 3.89543 13 5H11C11 3.89543 10.1046 3 9 3H5ZM11 7V9H13V7H11ZM11 11V13H13V11H11ZM11 15V17H13V15H11ZM5 5H9V19H5V5ZM15 5H19V19H15V5Z\' />\n</g>\n\n<g id=\'icon_cpu\'>\n  <path d=\'M13.9802 7.75H10.0102C8.76023 7.75 7.74023 8.76 7.74023 10.02V13.99C7.74023 15.24 8.75023 16.26 10.0102 16.26H13.9802C15.2302 16.26 16.2502 15.25 16.2502 13.99V10.02C16.2502 8.76 15.2402 7.75 13.9802 7.75ZM13.5002 12.98L12.6102 14.53C12.4802 14.76 12.2402 14.88 12.0002 14.88C11.8802 14.88 11.7502 14.85 11.6502 14.79C11.3102 14.6 11.1902 14.17 11.3902 13.83L12.0302 12.72H11.4702C11.0202 12.72 10.6502 12.52 10.4502 12.18C10.2502 11.84 10.2702 11.42 10.5002 11.03L11.3902 9.48C11.5902 9.14 12.0202 9.03 12.3502 9.22C12.6902 9.41 12.8102 9.84 12.6102 10.18L11.9702 11.29H12.5302C12.9802 11.29 13.3502 11.49 13.5502 11.83C13.7502 12.17 13.7302 12.59 13.5002 12.98Z\' />\n  <path d=\'M21.25 12.75C21.67 12.75 22 12.41 22 12C22 11.58 21.67 11.25 21.25 11.25H20V9.05H21.25C21.67 9.05 22 8.72 22 8.3C22 7.89 21.67 7.55 21.25 7.55H19.77C19.29 5.96 18.04 4.71 16.45 4.23V2.75C16.45 2.34 16.11 2 15.7 2C15.29 2 14.95 2.34 14.95 2.75V4H12.75V2.75C12.75 2.34 12.41 2 12 2C11.59 2 11.25 2.34 11.25 2.75V4H9.06V2.75C9.06 2.34 8.72 2 8.31 2C7.89 2 7.56 2.34 7.56 2.75V4.23C5.96 4.71 4.71 5.96 4.23 7.55H2.75C2.34 7.55 2 7.89 2 8.3C2 8.72 2.34 9.05 2.75 9.05H4V11.25H2.75C2.34 11.25 2 11.58 2 12C2 12.41 2.34 12.75 2.75 12.75H4V14.95H2.75C2.34 14.95 2 15.28 2 15.7C2 16.11 2.34 16.45 2.75 16.45H4.23C4.7 18.04 5.96 19.29 7.56 19.77V21.25C7.56 21.66 7.89 22 8.31 22C8.72 22 9.06 21.66 9.06 21.25V20H11.26V21.25C11.26 21.66 11.59 22 12.01 22C12.42 22 12.76 21.66 12.76 21.25V20H14.95V21.25C14.95 21.66 15.29 22 15.7 22C16.11 22 16.45 21.66 16.45 21.25V19.77C18.04 19.29 19.29 18.04 19.77 16.45H21.25C21.67 16.45 22 16.11 22 15.7C22 15.28 21.67 14.95 21.25 14.95H20V12.75H21.25ZM17.26 14.26C17.26 15.91 15.91 17.26 14.26 17.26H9.74C8.09 17.26 6.74 15.91 6.74 14.26V9.74C6.74 8.09 8.09 6.74 9.74 6.74H14.26C15.91 6.74 17.26 8.09 17.26 9.74V14.26Z\' />\n</g>\n\n<g id=\'icon_input\'>\n  <path d=\'M3 6L6 6L6 12L10 12L10 6L13 6V5L8 0L3 5L3 6Z\' />\n  <path d=\'M2 16L14 16V14L2 14V16Z\' />\n</g>\n\n<g id=\'icon_output\'>\n  <path d=\'M13 9H10V16H6V9L3 9V8L8 3L13 8V9Z\' />\n  <path d=\'M14 2H2V0H14V2Z\' />\n</g>\n\n</defs>\n\n<line x1=\'600\' y1=\'0\' x2=\'600\' y2=\'0\' stroke-width=\'1\' stroke=\'var(--stage-grid, #B2B2B2)\' stroke-dasharray=\'1,2\'/>\n\n</svg>\n"
  }
}

2025-12-12 13:26:19,231 - DEBUG - root - describe_query: Result: query {
  meta {
    common {
      id: "ptqudq7r5il6ao5njbrb"
      created_by: "root@builtin"
      modified_by: "root@builtin"
      created_at {
        seconds: 1765545977
        nanos: 669277000
      }
      modified_at {
        seconds: 1765545977
        nanos: 669277000
      }
      revision: 1
    }
    started_at {
      seconds: 1765545978
      nanos: 78000000
    }
    finished_at {
      seconds: 1765545979
      nanos: 86000000
    }
    execute_mode: RUN
    status: FAILED
    last_job_query_revision: 1
    last_job_id: "ptjudq7r5il68dsgq7tk-ptqudq7r5il6ao5njbrb"
    started_by: "root@builtin"
    submitted_at {
      seconds: 1765545977
      nanos: 669277000
    }
  }
  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\" : \"date\",\n                \"projection.year.min\" : \"2022-01-01\",\n                \"projection.year.max\" : \"2022-01-01\",\n                \"projection.year.format\" : \"%Y\",\n                \"projection.year.interval\" : \"1\",\n                \"projection.year.unit\" : \"DAYS\",\n\n                \"storage.location.template\" : \"${year}-03-05\"\n            }\n            @@;\n            \n            SELECT *\n            FROM `h2419604815326425151_test_projection_date_type_validationfruitbucket`.`/` WITH\n            (\n                format=csv_with_names,\n                schema=\n                (\n                    Fruit String NOT NULL,\n                    year Utf8\n                ),\n                partitioned_by=(year),\n                projection=$projection\n            )\n            "
    syntax: YQL_V1
  }
  plan {
    json: "{}"
  }
  issue {
    message: "Query failed with code GENERIC_ERROR at 2025-12-12T13:26:18.202926Z"
    severity: 1
    issues {
      message: "Type annotation"
      issue_code: 1030
      severity: 1
      issues {
        position {
          row: 21
          column: 18
        }
        message: "At function: S3ReadObject!"
        end_position {
          row: 21
          column: 18
        }
        severity: 1
        issues {
          position {
            row: 24
            column: 17
          }
          message: "Projection column \"year\" has invalid type Optional<Utf8>"
          end_position {
            row: 24
            column: 17
          }
          severity: 1
        }
      }
    }
  }
  statistics {
    json: "{}"
  }
  ast {
    data: "(\n(let $1 (Configure! world (DataSource \'\"s3\" \'\"$all\") \'\"Attr\" \'\"useruntimelisting\" \'\"false\"))\n(let $2 \'\"/local/h2419604815326425151_test_projection_date_type_validationfruitbucket\")\n(let $3 (OptionalType (DataType \'Utf8)))\n(let $4 \'(\'\"partitionedby\" \'\"year\"))\n(let $5 \'\"\\n            {\\n                \\\"projection.enabled\\\" : true,\\n\\n                \\\"projection.year.type\\\" : \\\"date\\\",\\n                \\\"projection.year.min\\\" : \\\"2022-01-01\\\",\\n                \\\"projection.year.max\\\" : \\\"2022-01-01\\\",\\n                \\\"projection.year.format\\\" : \\\"%Y\\\",\\n                \\\"projection.year.interval\\\" : \\\"1\\\",\\n                \\\"projection.year.unit\\\" : \\\"DAYS\\\",\\n\\n                \\\"storage.location.template\\\" : \\\"${year}-03-05\\\"\\n            }\\n            \")\n(let $6 \'(\'\"projection\" $5))\n(let $7 \'($4 $6 \'(\'directories) \'(\'\"pathpattern\" \'\"*\") \'(\'\"pathpatternvariant\" \'\"FilePattern\")))\n(let $8 (S3Object \'(\'((String \'\"Paths {\\n  Name: \\\"2022-03-05\\\"\\n  Read: true\\n  IsDirectory: true\\n}\\n\") (Bool \'\"true\") (AsStruct \'(\'\"year\" (StrictCast (Date \'\"2022-01-01\") $3))))) \'\"csv_with_names\" $7))\n(let $9 (StructType \'(\'\"Fruit\" (DataType \'String)) \'(\'\"year\" (OptionalType (DataType \'Utf8)))))\n(let $10 \'(\'\"Fruit\" \'\"year\"))\n(let $11 (DataSink \'result))\n(let $12 \'($4 $6 \'(\'directories) \'(\'\"pathpattern\" \'\"*\") \'(\'\"pathpatternvariant\" \'\"FilePattern\")))\n(let $13 (S3Object \'(\'((String \'\"Paths {\\n  Name: \\\"2022-03-05\\\"\\n  Read: true\\n  IsDirectory: true\\n}\\n\") (Bool \'\"true\") (AsStruct \'(\'\"year\" (StrictCast (Date \'\"2022-01-01\") $3))))) \'\"csv_with_names\" $12))\n(let $14 (Right! (S3ReadObject! $1 (DataSource \'\"s3\" $2) $13 $9 \'\"/ \" (lambda \'($17) (Bool \'\"true\")) $10)))\n(let $15 (ResWrite! (Left! (S3ReadObject! $1 (DataSource \'\"s3\" $2) $8 $9 \'\"/ \" (lambda \'($16) (Bool \'\"true\")) $10)) $11 (Key) (RemovePrefixMembers (RemoveSystemMembers (PersistableRepr (SqlProject $14 \'((SqlProjectStarItem (TypeOf $14) \'\"\" (lambda \'($18) $18) \'()))))) \'(\'_yql_sys_)) \'(\'(\'type) \'(\'autoref))))\n(return (Commit! (Commit! $15 $11) (DataSink \'\"kikimr\" \'\"db\") \'(\'(\'\"mode\" \'\"flush\"))))\n)\n"
  }
  timeline {
    svg: "<svg width=\'1280\' height=\'0\' xmlns=\'http://www.w3.org/2000/svg\'>\n<clipPath id=\'clipTextPath\'><rect x=\'0\' y=\'0\' width=\'298\' height=\'0\'/></clipPath>\n\n<defs>\n\n<g id=\'icon_memory\'>\n  <path fill-rule=\'evenodd\' clip-rule=\'evenodd\' d=\'M5 3C3.89543 3 3 3.89543 3 5H1V7H3V9H1V11H3V13H1V15H3V17H1V19H3C3 20.1046 3.89543 21 5 21H9C10.1046 21 11 20.1046 11 19H13C13 20.1046 13.8954 21 15 21H19C20.1046 21 21 20.1046 21 19H23V17H21V15H23V13H21V11H23V9H21V7H23V5H21C21 3.89543 20.1046 3 19 3H15C13.8954 3 13 3.89543 13 5H11C11 3.89543 10.1046 3 9 3H5ZM11 7V9H13V7H11ZM11 11V13H13V11H11ZM11 15V17H13V15H11ZM5 5H9V19H5V5ZM15 5H19V19H15V5Z\' />\n</g>\n\n<g id=\'icon_cpu\'>\n  <path d=\'M13.9802 7.75H10.0102C8.76023 7.75 7.74023 8.76 7.74023 10.02V13.99C7.74023 15.24 8.75023 16.26 10.0102 16.26H13.9802C15.2302 16.26 16.2502 15.25 16.2502 13.99V10.02C16.2502 8.76 15.2402 7.75 13.9802 7.75ZM13.5002 12.98L12.6102 14.53C12.4802 14.76 12.2402 14.88 12.0002 14.88C11.8802 14.88 11.7502 14.85 11.6502 14.79C11.3102 14.6 11.1902 14.17 11.3902 13.83L12.0302 12.72H11.4702C11.0202 12.72 10.6502 12.52 10.4502 12.18C10.2502 11.84 10.2702 11.42 10.5002 11.03L11.3902 9.48C11.5902 9.14 12.0202 9.03 12.3502 9.22C12.6902 9.41 12.8102 9.84 12.6102 10.18L11.9702 11.29H12.5302C12.9802 11.29 13.3502 11.49 13.5502 11.83C13.7502 12.17 13.7302 12.59 13.5002 12.98Z\' />\n  <path d=\'M21.25 12.75C21.67 12.75 22 12.41 22 12C22 11.58 21.67 11.25 21.25 11.25H20V9.05H21.25C21.67 9.05 22 8.72 22 8.3C22 7.89 21.67 7.55 21.25 7.55H19.77C19.29 5.96 18.04 4.71 16.45 4.23V2.75C16.45 2.34 16.11 2 15.7 2C15.29 2 14.95 2.34 14.95 2.75V4H12.75V2.75C12.75 2.34 12.41 2 12 2C11.59 2 11.25 2.34 11.25 2.75V4H9.06V2.75C9.06 2.34 8.72 2 8.31 2C7.89 2 7.56 2.34 7.56 2.75V4.23C5.96 4.71 4.71 5.96 4.23 7.55H2.75C2.34 7.55 2 7.89 2 8.3C2 8.72 2.34 9.05 2.75 9.05H4V11.25H2.75C2.34 11.25 2 11.58 2 12C2 12.41 2.34 12.75 2.75 12.75H4V14.95H2.75C2.34 14.95 2 15.28 2 15.7C2 16.11 2.34 16.45 2.75 16.45H4.23C4.7 18.04 5.96 19.29 7.56 19.77V21.25C7.56 21.66 7.89 22 8.31 22C8.72 22 9.06 21.66 9.06 21.25V20H11.26V21.25C11.26 21.66 11.59 22 12.01 22C12.42 22 12.76 21.66 12.76 21.25V20H14.95V21.25C14.95 21.66 15.29 22 15.7 22C16.11 22 16.45 21.66 16.45 21.25V19.77C18.04 19.29 19.29 18.04 19.77 16.45H21.25C21.67 16.45 22 16.11 22 15.7C22 15.28 21.67 14.95 21.25 14.95H20V12.75H21.25ZM17.26 14.26C17.26 15.91 15.91 17.26 14.26 17.26H9.74C8.09 17.26 6.74 15.91 6.74 14.26V9.74C6.74 8.09 8.09 6.74 9.74 6.74H14.26C15.91 6.74 17.26 8.09 17.26 9.74V14.26Z\' />\n</g>\n\n<g id=\'icon_input\'>\n  <path d=\'M3 6L6 6L6 12L10 12L10 6L13 6V5L8 0L3 5L3 6Z\' />\n  <path d=\'M2 16L14 16V14L2 14V16Z\' />\n</g>\n\n<g id=\'icon_output\'>\n  <path d=\'M13 9H10V16H6V9L3 9V8L8 3L13 8V9Z\' />\n  <path d=\'M14 2H2V0H14V2Z\' />\n</g>\n\n</defs>\n\n<line x1=\'600\' y1=\'0\' x2=\'600\' y2=\'0\' stroke-width=\'1\' stroke=\'var(--stage-grid, #B2B2B2)\' stroke-dasharray=\'1,2\'/>\n\n</svg>\n"
  }
}

2025-12-12 13:26:19,242 - DEBUG - root - describe_query: Result: ... (repeated, see above) ...
2025-12-12 13:26:19,242 - INFO - root - test_projection_date_type_validation: AST: (
(let $1 (Configure! world (DataSource '"s3" '"$all") '"Attr" '"useruntimelisting" '"false"))
(let $2 '"/local/h2419604815326425151_test_projection_date_type_validationfruitbucket")
(let $3 (OptionalType (DataType 'Utf8)))
(let $4 '('"partitionedby" '"year"))
(let $5 '"\n            {\n                \"projection.enabled\" : true,\n\n                \"projection.year.type\" : \"date\",\n                \"projection.year.min\" : \"2022-01-01\",\n                \"projection.year.max\" : \"2022-01-01\",\n                \"projection.year.format\" : \"%Y\",\n                \"projection.year.interval\" : \"1\",\n                \"projection.year.unit\" : \"DAYS\",\n\n                \"storage.location.template\" : \"${year}-03-05\"\n            }\n            ")
(let $6 '('"projection" $5))
(let $7 '($4 $6 '('directories) '('"pathpattern" '"*") '('"pathpatternvariant" '"FilePattern")))
(let $8 (S3Object '('((String '"Paths {\n  Name: \"2022-03-05\"\n  Read: true\n  IsDirectory: true\n}\n") (Bool '"true") (AsStruct '('"year" (StrictCast (Date '"2022-01-01") $3))))) '"csv_with_names" $7))
(let $9 (StructType '('"Fruit" (DataType 'String)) '('"year" (OptionalType (DataType 'Utf8)))))
(let $10 '('"Fruit" '"year"))
(let $11 (DataSink 'result))
(let $12 '($4 $6 '('directories) '('"pathpattern" '"*") '('"pathpatternvariant" '"FilePattern")))
(let $13 (S3Object '('((String '"Paths {\n  Name: \"2022-03-05\"\n  Read: true\n  IsDirectory: true\n}\n") (Bool '"true") (AsStruct '('"year" (StrictCast (Date '"2022-01-01") $3))))) '"csv_with_names" $12))
(let $14 (Right! (S3ReadObject! $1 (DataSource '"s3" $2) $13 $9 '"/ " (lambda '($17) (Bool '"true")) $10)))
(let $15 (ResWrite! (Left! (S3ReadObject! $1 (DataSource '"s3" $2) $8 $9 '"/ " (lambda '($16) (Bool '"true")) $10)) $11 (Key) (RemovePrefixMembers (RemoveSystemMembers (PersistableRepr (SqlProject $14 '((SqlProjectStarItem (TypeOf $14) '"" (lambda '($18) $18) '()))))) '('_yql_sys_)) '('('type) '('autoref))))
(return (Commit! (Commit! $15 $11) (DataSink '"kikimr" '"db") '('('"mode" '"flush"))))
)

2025-12-12 13:26:19,244 - INFO - ya.test - pytest_runtest_teardown: Test teardown
