René's URL Explorer Experiment


Title: refactor: fix isin, explode and geo ops for sqlglot compiler by chelsea-lin · Pull Request #2366 · googleapis/python-bigquery-dataframes · GitHub

Open Graph Title: refactor: fix isin, explode and geo ops for sqlglot compiler by chelsea-lin · Pull Request #2366 · googleapis/python-bigquery-dataframes

X Title: refactor: fix isin, explode and geo ops for sqlglot compiler by chelsea-lin · Pull Request #2366 · googleapis/python-bigquery-dataframes

Description: This change can resolve the following bugs in #2248: fix test_isin_* tests failures. fix test_*explode* tests failures. fix test_geo_x_non_point tests failure. Fixes internal issue 417774347🦕

Open Graph Description: This change can resolve the following bugs in #2248: fix test_isin_* tests failures. fix test_*explode* tests failures. fix test_geo_x_non_point tests failure. Fixes internal issue 417774347🦕

X Description: This change can resolve the following bugs in #2248: fix test_isin_* tests failures. fix test_*explode* tests failures. fix test_geo_x_non_point tests failure. Fixes internal issue 417774347🦕

Opengraph URL: https://github.com/googleapis/python-bigquery-dataframes/pull/2366

X: @github

direct link

Domain: patch-diff.githubusercontent.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:d8c8548a-07f5-3cbc-a73b-ed2c7e0dccd9
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-id8512:178919:7EEA443:A6D5275:696DCD7C
html-safe-nonce77aaab6a71ef76fd29039cf9ddfcf5682e83b4bedbacc864d4d4248e0dc24563
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI4NTEyOjE3ODkxOTo3RUVBNDQzOkE2RDUyNzU6Njk2RENEN0MiLCJ2aXNpdG9yX2lkIjoiMzIyNzAxMzAwNjYyNDY3MzE0OCIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmac319d39807f96185e5ae87ba24ba0b35acf864cadc18dc5f5dceea8a473c904d7
hovercard-subject-tagpull_request:3148140019
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/googleapis/python-bigquery-dataframes/2366/pull_request_layout
twitter:imagehttps://opengraph.githubassets.com/7f5ff2ee8bb00466684234dbe0ad3bae014eceabb914ad3196260ef1aa4cdb7e/googleapis/python-bigquery-dataframes/pull/2366
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/7f5ff2ee8bb00466684234dbe0ad3bae014eceabb914ad3196260ef1aa4cdb7e/googleapis/python-bigquery-dataframes/pull/2366
og:image:altThis change can resolve the following bugs in #2248: fix test_isin_* tests failures. fix test_*explode* tests failures. fix test_geo_x_non_point tests failure. Fixes internal issue 417774347🦕
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernamechelsea-lin
hostnamegithub.com
expected-hostnamegithub.com
None4922b452d03cd8dbce479d866a11bc25b59ef6ee2da23aa9b0ddefa6bd4d0064
turbo-cache-controlno-preview
go-importgithub.com/googleapis/python-bigquery-dataframes git https://github.com/googleapis/python-bigquery-dataframes.git
octolytics-dimension-user_id16785467
octolytics-dimension-user_logingoogleapis
octolytics-dimension-repository_id667598363
octolytics-dimension-repository_nwogoogleapis/python-bigquery-dataframes
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id667598363
octolytics-dimension-repository_network_root_nwogoogleapis/python-bigquery-dataframes
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
release7e5ae23c70136152637ceee8d6faceb35596ec46
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366#start-of-content
https://patch-diff.githubusercontent.com/
Sign in https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2Fgoogleapis%2Fpython-bigquery-dataframes%2Fpull%2F2366
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://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2Fgoogleapis%2Fpython-bigquery-dataframes%2Fpull%2F2366
Sign up https://patch-diff.githubusercontent.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=googleapis%2Fpython-bigquery-dataframes
Reloadhttps://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366
Reloadhttps://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366
Reloadhttps://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366
googleapis https://patch-diff.githubusercontent.com/googleapis
python-bigquery-dataframeshttps://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes
Notifications https://patch-diff.githubusercontent.com/login?return_to=%2Fgoogleapis%2Fpython-bigquery-dataframes
Fork 63 https://patch-diff.githubusercontent.com/login?return_to=%2Fgoogleapis%2Fpython-bigquery-dataframes
Star 278 https://patch-diff.githubusercontent.com/login?return_to=%2Fgoogleapis%2Fpython-bigquery-dataframes
Code https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes
Issues 13 https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/issues
Pull requests 48 https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pulls
Actions https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/actions
Projects 0 https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/projects
Security Uh oh! There was an error while loading. Please reload this page. https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/security
Please reload this pagehttps://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366
Insights https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pulse
Code https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes
Issues https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/issues
Pull requests https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pulls
Actions https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/actions
Projects https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/projects
Security https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/security
Insights https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pulse
Sign up for GitHub https://patch-diff.githubusercontent.com/signup?return_to=%2Fgoogleapis%2Fpython-bigquery-dataframes%2Fissues%2Fnew%2Fchoose
terms of servicehttps://docs.github.com/terms
privacy statementhttps://docs.github.com/privacy
Sign inhttps://patch-diff.githubusercontent.com/login?return_to=%2Fgoogleapis%2Fpython-bigquery-dataframes%2Fissues%2Fnew%2Fchoose
Jump to bottomhttps://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366#issue-comment-box
chelsea-linhttps://patch-diff.githubusercontent.com/chelsea-lin
mainhttps://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/tree/main
main_chelsealin_sgtestshttps://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/tree/main_chelsealin_sgtests
refactor: fix isin, explode and geo ops for sqlglot compiler https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366#top
chelsea-linhttps://patch-diff.githubusercontent.com/chelsea-lin
mainhttps://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/tree/main
main_chelsealin_sgtestshttps://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/tree/main_chelsealin_sgtests
Conversation 0 https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366
Commits 3 https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366/commits
Checks 16 https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366/checks
Files changed https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366/files
Please reload this pagehttps://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366
https://github.co/hiddenchars
https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/{{ revealButtonHref }}
https://patch-diff.githubusercontent.com/chelsea-lin
chelsea-linhttps://patch-diff.githubusercontent.com/chelsea-lin
Jan 6, 2026https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366#issue-3783642326
Please reload this pagehttps://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366
#2248https://github.com/googleapis/python-bigquery-dataframes/pull/2248
Please reload this pagehttps://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366
chelsea-linhttps://patch-diff.githubusercontent.com/chelsea-lin
January 6, 2026 03:55https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366#commits-pushed-a4cf227
https://patch-diff.githubusercontent.com/chelsea-lin
refactor: fix test_isin testshttps://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366/commits/a4cf2271aa1b21434bfdccb8041df3a04490e91f
a4cf227https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366/commits/a4cf2271aa1b21434bfdccb8041df3a04490e91f
https://patch-diff.githubusercontent.com/chelsea-lin
refactor: left join with unnesthttps://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366/commits/5d6ec4f73beadd77ceae28f31b1d0e3c3f2ca805
5d6ec4fhttps://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366/commits/5d6ec4f73beadd77ceae28f31b1d0e3c3f2ca805
https://patch-diff.githubusercontent.com/apps/product-auto-label
product-auto-labelhttps://patch-diff.githubusercontent.com/apps/product-auto-label
size: m https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/issues?q=state%3Aopen%20label%3A%22size%3A%20m%22
api: bigquery https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/issues?q=state%3Aopen%20label%3A%22api%3A%20bigquery%22
Jan 6, 2026https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366#event-21867516978
https://patch-diff.githubusercontent.com/chelsea-lin
chelsea-linhttps://patch-diff.githubusercontent.com/chelsea-lin
January 6, 2026 06:34https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366#event-21869291675
https://patch-diff.githubusercontent.com/chelsea-lin
chelsea-linhttps://patch-diff.githubusercontent.com/chelsea-lin
code ownershttps://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/blob/b478b0c46e88283111a0e940106634a63788a692/.github/CODEOWNERS#L9
January 6, 2026 06:34https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366#event-21869291822
https://patch-diff.githubusercontent.com/chelsea-lin
chelsea-linhttps://patch-diff.githubusercontent.com/chelsea-lin
tswasthttps://patch-diff.githubusercontent.com/tswast
January 6, 2026 06:34https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366#event-21869291951
https://patch-diff.githubusercontent.com/apps/blunderbuss-gcf
blunderbuss-gcfhttps://patch-diff.githubusercontent.com/apps/blunderbuss-gcf
drylks-workhttps://patch-diff.githubusercontent.com/drylks-work
Jan 6, 2026https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366#event-21869292441
https://patch-diff.githubusercontent.com/chelsea-lin
refactor: fix geo_x and geo_y opshttps://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366/commits/7536c97f5c069a9e9fce40c23b8f36306d86cafa
7536c97https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366/commits/7536c97f5c069a9e9fce40c23b8f36306d86cafa
https://patch-diff.githubusercontent.com/chelsea-lin
chelsea-linhttps://patch-diff.githubusercontent.com/chelsea-lin
Jan 6, 2026https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366#event-21869456702
https://patch-diff.githubusercontent.com/chelsea-lin
chelsea-linhttps://patch-diff.githubusercontent.com/chelsea-lin
Jan 6, 2026https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366#event-21869561010
https://patch-diff.githubusercontent.com/chelsea-lin
chelsea-linhttps://patch-diff.githubusercontent.com/chelsea-lin
jialuoohttps://patch-diff.githubusercontent.com/jialuoo
January 7, 2026 00:56https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366#event-21887667270
https://patch-diff.githubusercontent.com/jialuoo
jialuoohttps://patch-diff.githubusercontent.com/jialuoo
Jan 7, 2026 https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366#pullrequestreview-3633037154
View reviewed changes https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366/files/7536c97f5c069a9e9fce40c23b8f36306d86cafa
https://patch-diff.githubusercontent.com/chelsea-lin
chelsea-linhttps://patch-diff.githubusercontent.com/chelsea-lin
e1e1141https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/commit/e1e1141733320ecdcc6cf9f1bb42e0a73b6e5751
Jan 7, 2026https://github.com/googleapis/python-bigquery-dataframes/pull/2366#event-21887916932
Please reload this pagehttps://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366
https://patch-diff.githubusercontent.com/chelsea-lin
chelsea-linhttps://patch-diff.githubusercontent.com/chelsea-lin
January 7, 2026 01:21https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366#event-21887917581
Sign up for freehttps://patch-diff.githubusercontent.com/join?source=comment-repo
Sign in to commenthttps://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2Fgoogleapis%2Fpython-bigquery-dataframes%2Fpull%2F2366
https://patch-diff.githubusercontent.com/jialuoo
jialuoo https://patch-diff.githubusercontent.com/jialuoo
https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366/files/7536c97f5c069a9e9fce40c23b8f36306d86cafa
https://patch-diff.githubusercontent.com/tswast
tswast https://patch-diff.githubusercontent.com/tswast
https://patch-diff.githubusercontent.com/drylks-work
drylks-work https://patch-diff.githubusercontent.com/drylks-work
api: bigquery https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/issues?q=state%3Aopen%20label%3A%22api%3A%20bigquery%22
size: m https://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/issues?q=state%3Aopen%20label%3A%22size%3A%20m%22
Please reload this pagehttps://patch-diff.githubusercontent.com/googleapis/python-bigquery-dataframes/pull/2366
https://patch-diff.githubusercontent.com/chelsea-lin
https://patch-diff.githubusercontent.com/jialuoo
https://patch-diff.githubusercontent.com/drylks-work
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.