René's URL Explorer Experiment


Title: feat: Push column projection and time-range filters down to Iceberg scans in the DuckDB and Spark offline stores · Issue #7019 · feast-dev/feast · GitHub

Open Graph Title: feat: Push column projection and time-range filters down to Iceberg scans in the DuckDB and Spark offline stores · Issue #7019 · feast-dev/feast

X Title: feat: Push column projection and time-range filters down to Iceberg scans in the DuckDB and Spark offline stores · Issue #7019 · feast-dev/feast

Description: Is your feature request related to a problem? Please describe. Follow-up to #6499 / #7005 (Polaris support, merged in #7006). Reads from an IcebergSource are always a full-table scan: DuckDB offline store: _read_iceberg_catalog_source do...

Open Graph Description: Is your feature request related to a problem? Please describe. Follow-up to #6499 / #7005 (Polaris support, merged in #7006). Reads from an IcebergSource are always a full-table scan: DuckDB offlin...

X Description: Is your feature request related to a problem? Please describe. Follow-up to #6499 / #7005 (Polaris support, merged in #7006). Reads from an IcebergSource are always a full-table scan: DuckDB offlin...

Opengraph URL: https://github.com/feast-dev/feast/issues/7019

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"feat: Push column projection and time-range filters down to Iceberg scans in the DuckDB and Spark offline stores","articleBody":"**Is your feature request related to a problem? Please describe.**\n\nFollow-up to #6499 / #7005 (Polaris support, merged in #7006). Reads from an `IcebergSource` are always a full-table scan:\n\n- DuckDB offline store: `_read_iceberg_catalog_source` does `table.scan().to_arrow()` and wraps the result in `ibis.memtable(...)`. The column selection and time-range filters that `pull_latest_from_table_or_query_ibis`, `pull_all_from_table_or_query_ibis` and `get_historical_features_ibis` apply afterwards are evaluated by DuckDB on the already-materialized table, so they never reach the Iceberg scan.\n- Spark offline store: `_register_iceberg_source_as_temp_view` does `scan().to_arrow()` and `createDataFrame(...)`, so every column of the table is loaded into the driver regardless of what the feature view uses.\n\nFor wide or large tables this means reading all columns and all partitions/files just to use a few columns in a bounded time window, which also defeats Iceberg's column projection and partition/file pruning.\n\nThe data needed to avoid this is already known where the read happens, but the reader contract is `data_source_reader(data_source, repo_path) -> Table`, which has no way to carry it:\n\n- `pull_latest_*` / `pull_all_*`: the exact columns (`join_keys + features + timestamp fields`) and `start_date` / `end_date`.\n- `get_historical_features_ibis.read_fv`: the join keys, requested feature columns and timestamp columns of each feature view, and the entity dataframe's event-timestamp range (a feature row can only matter if `timestamp \u003c= max(entity ts)`, and, with a TTL, `timestamp >= min(entity ts) - ttl`).\n\n**Describe the solution you'd like**\n\n- Add a small `DataSourceReadHints` dataclass (`columns`, `timestamp_field`, `start`, `end`) and an optional hints-aware reader alongside the existing `data_source_reader` in the ibis helpers. Existing readers (MSSQL, Oracle, file-based) keep working unchanged; offline stores that supply the hints-aware reader get pushdown.\n- DuckDB: pass the hints to `_read_iceberg_catalog_source`, which calls PyIceberg `scan(selected_fields=..., row_filter=...)`.\n  - Translate Feast-side column names back to source names through `field_mapping`, and only select columns that exist in the table schema.\n  - Only build a time filter when the timestamp column is an Iceberg `timestamp` / `timestamptz` (using the matching tz-aware / naive UTC literal). Otherwise skip it.\n  - The filter is a pure optimization: the existing ibis filters are still applied afterwards, so results must be identical with and without pushdown.\n- Spark: prune the registered temp view to the columns the feature view needs (and apply the time bounds where the entity range is available).\n- Unit tests against a real PyIceberg `SqlCatalog` (not only mocks) that assert both the scan arguments and that results match the unpruned read; docs note.\n\n**Describe alternatives you've considered**\n\n- Predicate pushdown on entity keys (`join_key IN (...)`): potentially large win for small entity dataframes, but riskier (large IN lists, composite keys, type coercion). Left out of the first iteration.\n- Lazy scans via DuckDB's Iceberg extension instead of Arrow materialization: bigger change to how the offline store reads, and would not cover Spark.\n- Changing the `data_source_reader` signature for all readers: breaking for the MSSQL/Oracle stores that share these helpers.\n\n**Additional context**\n\nRelated: #6499, #7005, #7006. I plan to open a PR for this.\n","author":{"url":"https://github.com/haoxu0","@type":"Person","name":"haoxu0"},"datePublished":"2026-10-15T08:11:06Z","url":"https://github.com/feast-dev/feast/issues/7019"}

react-profiling0
react-import-mapreact,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322
route-pattern/_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format)
route-controllervoltron_issues_fragments
route-actionissue_layout
fetch-noncev2:e942e061-c4d0-4dae-63e5-86393782f3de
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idAFB2:2A4404:DC1874:1220199:6AFE9223
html-safe-nonce61e5b9ffa8a986d9108de3eed35532cf14ee915b2c8b03d89ce7474826e9bd1a
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJBRkIyOjJBNDQwNDpEQzE4NzQ6MTIyMDE5OTo2QUZFOTIyMyIsInZpc2l0b3JfaWQiOiI1NDYxNDg5NzE4Mjg3ODMxNTg3IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmac8950eeff8b0da3dfa0dd8f02d2de0e264821dacc86d382568cfcfb150c6cebad
hovercard-subject-tagissue:5862541745
github-keyboard-shortcutsrepository,issues,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///voltron/issues_fragments/issue_layout
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/feast-dev/feast/7019/issue_layout
twitter:imagehttps://opengraph.githubassets.com/5e8d13dc76a1303f7f129ddfd208666a8c99da52959b77ac788b2daf1cf7c5a2/feast-dev/feast/issues/7019
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/5e8d13dc76a1303f7f129ddfd208666a8c99da52959b77ac788b2daf1cf7c5a2/feast-dev/feast/issues/7019
og:image:altIs your feature request related to a problem? Please describe. Follow-up to #6499 / #7005 (Polaris support, merged in #7006). Reads from an IcebergSource are always a full-table scan: DuckDB offlin...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernamehaoxu0
hostnamegithub.com
expected-hostnamegithub.com
Noneb3c0f155eafc27e60db6e254d1ffff0e072e9ab3b4018a5ee518797c19d89f86
turbo-cache-controlno-preview
go-importgithub.com/feast-dev/feast git https://github.com/feast-dev/feast.git
octolytics-dimension-user_id57027613
octolytics-dimension-user_loginfeast-dev
octolytics-dimension-repository_id161133770
octolytics-dimension-repository_nwofeast-dev/feast
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id161133770
octolytics-dimension-repository_network_root_nwofeast-dev/feast
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release4a10310af51a1bfffbedc4fd81cb582acf0cb0ff
ui-targetcanary-2
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/feast-dev/feast/issues/7019#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Ffeast-dev%2Ffeast%2Fissues%2F7019
GitHubRepository hosting, code review, and collaborationhttps://github.com/platform
CopilotAI coding agent for tasks, projects, and automated workhttps://github.com/features/copilot
ActionsCI/CD and automationhttps://github.com/features/actions
Code QualityQuality analysis, fixes, and enforcementhttps://github.com/features/code-quality
CodespacesCloud development environmentshttps://github.com/features/codespaces
Code SecurityVulnerability detection and remediationhttps://github.com/security/advanced-security/code-security
Secret ProtectionSecret scanning and leak preventionhttps://github.com/security/advanced-security/secret-protection
All Featureshttps://github.com/features
Documentationhttps://docs.github.com/en
Traininghttps://learn.github.com/skills
Certificationshttps://learn.github.com/credentials
Build with Copilothttps://github.com/features/ai
Customize Copilothttps://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview
Integrationshttps://github.com/marketplace
Trending reposhttps://github.com/trending
GitHub Sponsorshttps://github.com/open-source/sponsors
Developer articleshttps://github.com/resources/articles
ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place.https://github.blog/changelog/
Enterpriseshttps://github.com/enterprise
Teamhttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
See all industrieshttps://github.com/solutions/industry
Why GitHubhttps://github.com/why-github
Customer Storieshttps://github.com/customer-stories
Business insightshttps://github.com/solutions/executive-insights
Trust Centerhttps://github.com/trust-center
GitHub Advanced SecurityEnterprise-grade code securityhttps://github.com/security/advanced-security
Copilot for businessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/enterprise/premium-support
Documentationhttps://docs.github.com/en
Resource centerhttps://github.com/resources
Bloghttps://github.blog/
Events & webinarshttps://github.com/resources/events
Community Forumhttps://github.com/orgs/community/discussions
Customer Storieshttps://github.com/customer-stories
Integrationshttps://github.com/marketplace
Customer supporthttps://help.github.com/
Traininghttps://learn.github.com/skills
GitHub Statushttps://www.githubstatus.com/
Abouthttps://github.com/about
Partnershttps://github.com/partners
Changeloghttps://github.blog/changelog/
GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub.https://githubuniverse.com/
Pricinghttps://github.com/pricing
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Ffeast-dev%2Ffeast%2Fissues%2F7019
Sign uphttps://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fvoltron%2Fissues_fragments%2Fissue_layout&source=header-repo&source_repo=feast-dev%2Ffeast
Reloadhttps://github.com/feast-dev/feast/issues/7019
Reloadhttps://github.com/feast-dev/feast/issues/7019
Reloadhttps://github.com/feast-dev/feast/issues/7019
feast-devhttps://github.com/feast-dev
feasthttps://github.com/feast-dev/feast
Codehttps://github.com/feast-dev/feast
Issues223 (223)https://github.com/feast-dev/feast/issues
Pull requests143 (143)https://github.com/feast-dev/feast/pulls
Discussionshttps://github.com/feast-dev/feast/discussions
Actionshttps://github.com/feast-dev/feast/actions
Security and quality1 (1)https://github.com/feast-dev/feast/security
Insightshttps://github.com/feast-dev/feast/insights
https://github.com/feast-dev/feast
New issuehttps://github.com/login?return_to=https://github.com/feast-dev/feast/issues/7019
New issuehttps://github.com/login?return_to=https://github.com/feast-dev/feast/issues/7019
feat: Push column projection and time-range filters down to Iceberg scans in the DuckDB and Spark offline storeshttps://github.com/feast-dev/feast/issues/7019#top
kind/featureNew feature or requesthttps://github.com/feast-dev/feast/issues?q=state%3Aopen%20label%3A%22kind%2Ffeature%22
https://github.com/haoxu0
haoxu0https://github.com/haoxu0
on Oct 15, 2026https://github.com/feast-dev/feast/issues/7019#issue-5862541745
#6499https://github.com/feast-dev/feast/issues/6499
#7005https://github.com/feast-dev/feast/issues/7005
#7006https://github.com/feast-dev/feast/pull/7006
#6499https://github.com/feast-dev/feast/issues/6499
#7005https://github.com/feast-dev/feast/issues/7005
#7006https://github.com/feast-dev/feast/pull/7006
haoxu0https://github.com/haoxu0
kind/featureNew feature or requesthttps://github.com/feast-dev/feast/issues?q=state%3Aopen%20label%3A%22kind%2Ffeature%22
on Oct 15, 2026https://github.com/feast-dev/feast/issues/7019#event-33311636706
Sign up for freehttps://github.com/signup?return_to=https://github.com/feast-dev/feast/issues/7019
Sign in to commenthttps://github.com/login?return_to=https://github.com/feast-dev/feast/issues/7019
kind/featureNew feature or requesthttps://github.com/feast-dev/feast/issues?q=state%3Aopen%20label%3A%22kind%2Ffeature%22
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.