René's URL Explorer Experiment


Title: feat: Add deduplicate pushdown to clickhouse - improve materialize performance by astronautas · Pull Request #5709 · feast-dev/feast · GitHub

Open Graph Title: feat: Add deduplicate pushdown to clickhouse - improve materialize performance by astronautas · Pull Request #5709 · feast-dev/feast

X Title: feat: Add deduplicate pushdown to clickhouse - improve materialize performance by astronautas · Pull Request #5709 · feast-dev/feast

Description: What this PR does / why we need it: #5707. We have observed significant slowdown in heavy materialization jobs. Heavy = pulling in significant period of {start_ts, end_ts}, when essentially you en...

Open Graph Description: What this PR does / why we need it: #5707. We have observed significant slowdown in heavy materialization jobs. Heavy = pulling in significant period of {start_ts, end_ts}, when essentially you en...

X Description: What this PR does / why we need it: #5707. We have observed significant slowdown in heavy materialization jobs. Heavy = pulling in significant period of {start_ts, end_ts}, when essentially you en...

Opengraph URL: https://github.com/feast-dev/feast/pull/5709

X: @github

direct link

Domain: github.com

route-pattern/_view_fragments/voltron/pull_requests/show/:user_id/:repository/:id/pull_request_layout(.:format)
route-controllervoltron_pull_requests_fragments
route-actionpull_request_layout
fetch-noncev2:b3cdbece-dee1-c805-33aa-6939051175c6
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idB100:215E8B:5F9C080:81A792D:696E34D5
html-safe-nonce2df618945d608181070bc1872dfcccc55295f7d3078b3b374adcb009423245c7
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCMTAwOjIxNUU4Qjo1RjlDMDgwOjgxQTc5MkQ6Njk2RTM0RDUiLCJ2aXNpdG9yX2lkIjoiODg5NDg3MzIwNzQ4NTM3MDQ1IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmacf27c612e2ca066f00d25dea1d5bc6e606c3b0a227b2537e97e5a78b636da631a
hovercard-subject-tagpull_request:2972633736
github-keyboard-shortcutsrepository,pull-request-list,pull-request-conversation,pull-request-files-changed,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///voltron/pull_requests_fragments/pull_request_layout
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/_view_fragments/voltron/pull_requests/show/feast-dev/feast/5709/pull_request_layout
twitter:imagehttps://opengraph.githubassets.com/2d0b6c6cc06038423360432090a65b45e0525e5e58225c5d9d930bbd53138caa/feast-dev/feast/pull/5709
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/2d0b6c6cc06038423360432090a65b45e0525e5e58225c5d9d930bbd53138caa/feast-dev/feast/pull/5709
og:image:altWhat this PR does / why we need it: #5707. We have observed significant slowdown in heavy materialization jobs. Heavy = pulling in significant period of {start_ts, end_ts}, when essentially you en...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernameastronautas
hostnamegithub.com
expected-hostnamegithub.com
Noneb39958d54b39d52b9fc890ff25687d2383a83e003512d4480499b2dbd046839f
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
releasefba10be4ea34590240b2f4a625fc807362c2d5b8
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/feast-dev/feast/pull/5709#start-of-content
https://github.com/
Sign in https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Ffeast-dev%2Ffeast%2Fpull%2F5709
GitHub CopilotWrite better code with AIhttps://github.com/features/copilot
GitHub SparkBuild and deploy intelligent appshttps://github.com/features/spark
GitHub ModelsManage and compare promptshttps://github.com/features/models
MCP RegistryNewIntegrate external toolshttps://github.com/mcp
ActionsAutomate any workflowhttps://github.com/features/actions
CodespacesInstant dev environmentshttps://github.com/features/codespaces
IssuesPlan and track workhttps://github.com/features/issues
Code ReviewManage code changeshttps://github.com/features/code-review
GitHub Advanced SecurityFind and fix vulnerabilitieshttps://github.com/security/advanced-security
Code securitySecure your code as you buildhttps://github.com/security/advanced-security/code-security
Secret protectionStop leaks before they starthttps://github.com/security/advanced-security/secret-protection
Why GitHubhttps://github.com/why-github
Documentationhttps://docs.github.com
Bloghttps://github.blog
Changeloghttps://github.blog/changelog
Marketplacehttps://github.com/marketplace
View all featureshttps://github.com/features
Enterpriseshttps://github.com/enterprise
Small and medium teamshttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
App Modernizationhttps://github.com/solutions/use-case/app-modernization
DevSecOpshttps://github.com/solutions/use-case/devsecops
DevOpshttps://github.com/solutions/use-case/devops
CI/CDhttps://github.com/solutions/use-case/ci-cd
View all use caseshttps://github.com/solutions/use-case
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
View all industrieshttps://github.com/solutions/industry
View all solutionshttps://github.com/solutions
AIhttps://github.com/resources/articles?topic=ai
Software Developmenthttps://github.com/resources/articles?topic=software-development
DevOpshttps://github.com/resources/articles?topic=devops
Securityhttps://github.com/resources/articles?topic=security
View all topicshttps://github.com/resources/articles
Customer storieshttps://github.com/customer-stories
Events & webinarshttps://github.com/resources/events
Ebooks & reportshttps://github.com/resources/whitepapers
Business insightshttps://github.com/solutions/executive-insights
GitHub Skillshttps://skills.github.com
Documentationhttps://docs.github.com
Customer supporthttps://support.github.com
Community forumhttps://github.com/orgs/community/discussions
Trust centerhttps://github.com/trust-center
Partnershttps://github.com/partners
GitHub SponsorsFund open source developershttps://github.com/sponsors
Security Labhttps://securitylab.github.com
Maintainer Communityhttps://maintainers.github.com
Acceleratorhttps://github.com/accelerator
Archive Programhttps://archiveprogram.github.com
Topicshttps://github.com/topics
Trendinghttps://github.com/trending
Collectionshttps://github.com/collections
Enterprise platformAI-powered developer platformhttps://github.com/enterprise
GitHub Advanced SecurityEnterprise-grade security featureshttps://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/premium-support
Pricinghttps://github.com/pricing
Search syntax tipshttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
documentationhttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
Sign in https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Ffeast-dev%2Ffeast%2Fpull%2F5709
Sign up https://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fvoltron%2Fpull_requests_fragments%2Fpull_request_layout&source=header-repo&source_repo=feast-dev%2Ffeast
Reloadhttps://github.com/feast-dev/feast/pull/5709
Reloadhttps://github.com/feast-dev/feast/pull/5709
Reloadhttps://github.com/feast-dev/feast/pull/5709
feast-dev https://github.com/feast-dev
feasthttps://github.com/feast-dev/feast
Notifications https://github.com/login?return_to=%2Ffeast-dev%2Ffeast
Fork 1.2k https://github.com/login?return_to=%2Ffeast-dev%2Ffeast
Star 6.6k https://github.com/login?return_to=%2Ffeast-dev%2Ffeast
Code https://github.com/feast-dev/feast
Issues 176 https://github.com/feast-dev/feast/issues
Pull requests 58 https://github.com/feast-dev/feast/pulls
Discussions https://github.com/feast-dev/feast/discussions
Actions https://github.com/feast-dev/feast/actions
Security Uh oh! There was an error while loading. Please reload this page. https://github.com/feast-dev/feast/security
Please reload this pagehttps://github.com/feast-dev/feast/pull/5709
Insights https://github.com/feast-dev/feast/pulse
Code https://github.com/feast-dev/feast
Issues https://github.com/feast-dev/feast/issues
Pull requests https://github.com/feast-dev/feast/pulls
Discussions https://github.com/feast-dev/feast/discussions
Actions https://github.com/feast-dev/feast/actions
Security https://github.com/feast-dev/feast/security
Insights https://github.com/feast-dev/feast/pulse
Sign up for GitHub https://github.com/signup?return_to=%2Ffeast-dev%2Ffeast%2Fissues%2Fnew%2Fchoose
terms of servicehttps://docs.github.com/terms
privacy statementhttps://docs.github.com/privacy
Sign inhttps://github.com/login?return_to=%2Ffeast-dev%2Ffeast%2Fissues%2Fnew%2Fchoose
Jump to bottomhttps://github.com/feast-dev/feast/pull/5709#issue-comment-box
astronautashttps://github.com/astronautas
feast-dev:masterhttps://github.com/feast-dev/feast/tree/master
astronautas:feat/add-deduplicate-pushdown-to-clickhousehttps://github.com/astronautas/feast/tree/feat/add-deduplicate-pushdown-to-clickhouse
feat: Add deduplicate pushdown to clickhouse - improve materialize performance https://github.com/feast-dev/feast/pull/5709#top
astronautashttps://github.com/astronautas
feast-dev:masterhttps://github.com/feast-dev/feast/tree/master
astronautas:feat/add-deduplicate-pushdown-to-clickhousehttps://github.com/astronautas/feast/tree/feat/add-deduplicate-pushdown-to-clickhouse
Conversation 6 https://github.com/feast-dev/feast/pull/5709
Commits 7 https://github.com/feast-dev/feast/pull/5709/commits
Checks 18 https://github.com/feast-dev/feast/pull/5709/checks
Files changed https://github.com/feast-dev/feast/pull/5709/files
Please reload this pagehttps://github.com/feast-dev/feast/pull/5709
https://github.co/hiddenchars
https://github.com/feast-dev/feast/pull/{{ revealButtonHref }}
https://github.com/astronautas
astronautashttps://github.com/astronautas
Nov 3, 2025https://github.com/feast-dev/feast/pull/5709#issue-3581954874
Please reload this pagehttps://github.com/feast-dev/feast/pull/5709
#5707https://github.com/feast-dev/feast/issues/5707
#5707https://github.com/feast-dev/feast/issues/5707
Please reload this pagehttps://github.com/feast-dev/feast/pull/5709
astronautashttps://github.com/astronautas
October 15, 2025 19:55https://github.com/feast-dev/feast/pull/5709#commits-pushed-1752a4f
https://github.com/astronautas
https://github.com/ntkathole
add pull_all_from_table_or_query for clickhouse, to align with new ma…https://github.com/feast-dev/feast/pull/5709/commits/1752a4fc72f72ac5e7c059f028940e656db5b50b
1752a4fhttps://github.com/feast-dev/feast/pull/5709/commits/1752a4fc72f72ac5e7c059f028940e656db5b50b
Merge branch 'feast-dev:master' into masterhttps://github.com/feast-dev/feast/pull/5709/commits/a6fcf5ed3b19a82515adeb9e5054e3ea673f7933
a6fcf5ehttps://github.com/feast-dev/feast/pull/5709/commits/a6fcf5ed3b19a82515adeb9e5054e3ea673f7933
https://github.com/astronautas
add possibility to pushdown clickhouse deduplication to offline storehttps://github.com/feast-dev/feast/pull/5709/commits/f7b7d3722cfbf1db20b01d748664e9ba69dacd31
f7b7d37https://github.com/feast-dev/feast/pull/5709/commits/f7b7d3722cfbf1db20b01d748664e9ba69dacd31
https://github.com/astronautas
astronautashttps://github.com/astronautas
code ownerhttps://github.com/feast-dev/feast/blob/ad3275654226f614fa4a40411440d16634f6971c/CODEOWNERS#L10
November 3, 2025 12:56https://github.com/feast-dev/feast/pull/5709#event-20674144084
https://github.com/astronautas
astronautashttps://github.com/astronautas
Nov 3, 2025https://github.com/feast-dev/feast/pull/5709#issuecomment-3480393234
Please reload this pagehttps://github.com/feast-dev/feast/pull/5709
@HaoXuAIhttps://github.com/HaoXuAI
Please reload this pagehttps://github.com/feast-dev/feast/pull/5709
https://github.com/astronautas
add possibility to pushdown clickhouse deduplication to offline storehttps://github.com/feast-dev/feast/pull/5709/commits/757996274c1bd96b83704caa2d23629245060f26
7579962https://github.com/feast-dev/feast/pull/5709/commits/757996274c1bd96b83704caa2d23629245060f26
https://github.com/astronautas
astronautashttps://github.com/astronautas
force-pushedhttps://github.com/feast-dev/feast/compare/cbcaab6bc3f73528874e56e81b006ef016d18ab8..757996274c1bd96b83704caa2d23629245060f26
cbcaab6https://github.com/feast-dev/feast/commit/cbcaab6bc3f73528874e56e81b006ef016d18ab8
7579962https://github.com/feast-dev/feast/commit/757996274c1bd96b83704caa2d23629245060f26
Compare https://github.com/feast-dev/feast/compare/cbcaab6bc3f73528874e56e81b006ef016d18ab8..757996274c1bd96b83704caa2d23629245060f26
November 3, 2025 13:02https://github.com/feast-dev/feast/pull/5709#event-20674272146
November 3, 2025 15:03https://github.com/feast-dev/feast/pull/5709#commits-pushed-762de72
Merge branch 'feast-dev:master' into feat/add-deduplicate-pushdown-to…https://github.com/feast-dev/feast/pull/5709/commits/762de722ec7c49f579717b0e36b484e1571230de
762de72https://github.com/feast-dev/feast/pull/5709/commits/762de722ec7c49f579717b0e36b484e1571230de
https://github.com/astronautas
use info, since it's an intended path toohttps://github.com/feast-dev/feast/pull/5709/commits/50d84d1f772a3df6471fb38ae95e5dbee9de57e3
50d84d1https://github.com/feast-dev/feast/pull/5709/commits/50d84d1f772a3df6471fb38ae95e5dbee9de57e3
https://github.com/astronautas
make timestamps mandatory, filtering won't work otherwisehttps://github.com/feast-dev/feast/pull/5709/commits/cfaf9a6d87f239f48e8ab7360d81c5fc2a0320d2
cfaf9a6https://github.com/feast-dev/feast/pull/5709/commits/cfaf9a6d87f239f48e8ab7360d81c5fc2a0320d2
https://github.com/astronautas
astronautashttps://github.com/astronautas
force-pushedhttps://github.com/feast-dev/feast/compare/1a442cd17d0982d34cc4b7139da98261b52a2c85..cfaf9a6d87f239f48e8ab7360d81c5fc2a0320d2
1a442cdhttps://github.com/feast-dev/feast/commit/1a442cd17d0982d34cc4b7139da98261b52a2c85
cfaf9a6https://github.com/feast-dev/feast/commit/cfaf9a6d87f239f48e8ab7360d81c5fc2a0320d2
Compare https://github.com/feast-dev/feast/compare/1a442cd17d0982d34cc4b7139da98261b52a2c85..cfaf9a6d87f239f48e8ab7360d81c5fc2a0320d2
November 3, 2025 13:15https://github.com/feast-dev/feast/pull/5709#event-20674529820
https://github.com/astronautas
astronautashttps://github.com/astronautas
Nov 3, 2025https://github.com/feast-dev/feast/pull/5709#event-20678528267
https://github.com/astronautas
astronautashttps://github.com/astronautas
Nov 3, 2025https://github.com/feast-dev/feast/pull/5709#issuecomment-3481280718
@franciscojavierarceohttps://github.com/franciscojavierarceo
Please reload this pagehttps://github.com/feast-dev/feast/pull/5709
https://github.com/franciscojavierarceo
franciscojavierarceohttps://github.com/franciscojavierarceo
Nov 3, 2025https://github.com/feast-dev/feast/pull/5709#issuecomment-3481447657
@HaoXuAIhttps://github.com/HaoXuAI
Please reload this pagehttps://github.com/feast-dev/feast/pull/5709
https://github.com/HaoXuAI
HaoXuAIhttps://github.com/HaoXuAI
Nov 3, 2025 https://github.com/feast-dev/feast/pull/5709#pullrequestreview-3412594218
View reviewed changes https://github.com/feast-dev/feast/pull/5709/files/cfaf9a6d87f239f48e8ab7360d81c5fc2a0320d2
HaoXuAIhttps://github.com/HaoXuAI
https://github.com/feast-dev/feast/pull/5709#pullrequestreview-3412594218
Learn morehttps://docs.github.com/articles/managing-disruptive-comments/#hiding-a-comment
@franciscojavierarceohttps://github.com/franciscojavierarceo
Please reload this pagehttps://github.com/feast-dev/feast/pull/5709
https://github.com/astronautas
astronautashttps://github.com/astronautas
Nov 3, 2025https://github.com/feast-dev/feast/pull/5709#issuecomment-3482268377
@franciscojavierarceohttps://github.com/franciscojavierarceo
Please reload this pagehttps://github.com/feast-dev/feast/pull/5709
https://github.com/astronautas
astronautashttps://github.com/astronautas
Nov 5, 2025https://github.com/feast-dev/feast/pull/5709#issuecomment-3490784479
#5713https://github.com/feast-dev/feast/pull/5713
Please reload this pagehttps://github.com/feast-dev/feast/pull/5709
https://github.com/astronautas
astronautashttps://github.com/astronautas
Nov 5, 2025https://github.com/feast-dev/feast/pull/5709#event-20727906603
Sign up for freehttps://github.com/join?source=comment-repo
Sign in to commenthttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Ffeast-dev%2Ffeast%2Fpull%2F5709
https://github.com/HaoXuAI
HaoXuAI https://github.com/HaoXuAI
https://github.com/feast-dev/feast/pull/5709/files/cfaf9a6d87f239f48e8ab7360d81c5fc2a0320d2
Please reload this pagehttps://github.com/feast-dev/feast/pull/5709
https://github.com/astronautas
https://github.com/franciscojavierarceo
https://github.com/HaoXuAI
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.