René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Athena V3 compatibility issue with condition on the timestamp field","articleBody":"## Expected Behavior \nI can run materialization of feature views with Athena V3 as offline store.\n\n## Current Behavior\n\nGetting an error like this\n`feast.infra.utils.aws_utils.AthenaQueryError: Athena SQL Query failed to finish. Details: {'QueryExecution': {'QueryExecutionId': 'b5444c28-41d0-4992-81cc-6d524750161a', 'Query': 'CREATE TABLE _a8a21947682843c598b8340d0ac02738\\n                                    WITH (\\n                                    external_location = \\'s3://re-ds-feature-store-test-bkt/reco/athena_staging/unload/50b466e7-6cfe-40f7-8f21-a615ca3e0243\\',\\n                                    format = \\'parquet\\',\\n                                    write_compression = \\'snappy\\'\\n                                    )\\n                                    as\\n                                \\n            SELECT property_reference_id, listing_id, is_active, offer_type, country, canton, postalcode, locality, street, geo_latitude, geo_longitude, platforms, subcategory_main_code_hgrets, category_idx, price_gross_normalized, size_sqm_normalized_cleaned, number_of_rooms_cleaned, floor, year_built, year_lastrenovated, are_pets_allowed, has_elevator, has_parking, has_garage, has_niceview, has_steamer, has_washingmachine, has_tumbledryer, has_cabletv, has_flatsharingcommunity, has_attic, has_balcony, has_gardenshed, has_swimmingpool, has_fireplace, is_childfriendly, is_wheelchairaccessible, is_minergiegeneral, is_minergiecertified, is_newbuilding, is_groundfloor, is_oldbuilding, timestamp\\n            FROM \"AwsDataCatalog\".\"feature_store_reco\".\"listings\"\\n            WHERE timestamp BETWEEN \\'2026-02-01 01:00:00.000\\' AND \\'2026-02-01 02:00:00.000\\'', 'StatementType': 'DDL', 'ResultReuseConfiguration': {'ResultReuseByAgeConfiguration': {'Enabled': False}}, 'QueryExecutionContext': {'Database': 'feature_store_reco', 'Catalog': 'awsdatacatalog'}, 'Status': {'State': 'FAILED', 'StateChangeReason': 'TYPE_MISMATCH: line 52:18: Cannot check if timestamp(3) is BETWEEN varchar(23) and varchar(23). You may need to manually clean the data before retrying. Athena will not delete data in your account.', 'SubmissionDateTime': datetime.datetime(2026, 2, 2, 16, 2, 54, 362000, tzinfo=tzlocal()), 'CompletionDateTime': datetime.datetime(2026, 2, 2, 16, 2, 55, 164000, tzinfo=tzlocal()), 'AthenaError': {'ErrorCategory': 2, 'ErrorType': 1002, 'Retryable': False, 'ErrorMessage': 'TYPE_MISMATCH: line 52:18: Cannot check if timestamp(3) is BETWEEN varchar(23) and varchar(23). You may need to manually clean the data before retrying. Athena will not delete data in your account.'}}, 'Statistics': {'EngineExecutionTimeInMillis': 395, 'DataScannedInBytes': 0, 'TotalExecutionTimeInMillis': 802, 'QueryQueueTimeInMillis': 55, 'ServicePreProcessingTimeInMillis': 172, 'ServiceProcessingTimeInMillis': 180, 'ResultReuseInformation': {'ReusedPreviousResult': False}}, 'WorkGroup': 'wg_re-data-services-feature-store-stk-test', 'EngineVersion': {'SelectedEngineVersion': 'AUTO', 'EffectiveEngineVersion': 'Athena engine version 3'}, 'SubstatementType': 'CREATE_TABLE_AS_SELECT'}, 'ResponseMetadata': {'RequestId': 'd3f31624-2219-44a0-8eb7-47a4223eac49', 'HTTPStatusCode': 200, 'HTTPHeaders': {'date': 'Mon, 02 Feb 2026 15:02:55 GMT', 'content-type': 'application/x-amz-json-1.1', 'content-length': '4887', 'connection': 'keep-alive', 'x-amzn-requestid': 'd3f31624-2219-44a0-8eb7-47a4223eac49'}, 'RetryAttempts': 0}}`\n\n## Steps to reproduce\n\n### Specifications\n\n- Version: \u003e=v0.55.0\n- Platform: macOS/Linux\n- Subsystem:\n\n## Possible Solution\nChange cast_style=\"raw\" to cast_style=\"timestamp\" in feast/infra/offline_stores/contrib/athena_offline_store/athena.py line 112:\n```python\ntimestamp_filter = get_timestamp_filter_sql(\n    start_date_str,\n    end_date_str,\n    timestamp_field,\n    date_partition_column,\n    cast_style=\"timestamp\",  # \u003c-- Fix: use \"timestamp\" instead of \"raw\"\n    quote_fields=False,\n)\n```","author":{"url":"https://github.com/dym-ok","@type":"Person","name":"dym-ok"},"datePublished":"2026-02-02T15:52:17.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/5935/feast/issues/5935"}