Title: feat: Utilize date partition column in BigQuery by Anarion-zuo · Pull Request #6076 · feast-dev/feast · GitHub
Open Graph Title: feat: Utilize date partition column in BigQuery by Anarion-zuo · Pull Request #6076 · feast-dev/feast
X Title: feat: Utilize date partition column in BigQuery by Anarion-zuo · Pull Request #6076 · feast-dev/feast
Description: What this PR does / why we need it: Some BigQuery util does not use the date_partition_column as filtering condition, disabling partioning by those columns. Adjusted the function calls to make use of date_partition_column. Added related unit tests and benchmark cases. Which issue(s) this PR fixes: #2530 Misc To run the newly added unit test: python -m pytest sdk/python/tests/unit/infra/offline_stores/test_bigquery.py To run the newly added benchmark case, first you must be able to access your BigQuery. export FEAST_BQ_BENCH_PROJECT="my-gcp-project" export FEAST_BQ_BENCH_TABLE="my-gcp-project:my_dataset.my_table" export FEAST_BQ_BENCH_TIMESTAMP_FIELD="event_timestamp" export FEAST_BQ_BENCH_PARTITION_COLUMN="_PARTITIONDATE" export FEAST_BQ_BENCH_LOCATION="US" export FEAST_BQ_BENCH_REQUIRE_REDUCTION=true Then run python -m pytest sdk/python/tests/benchmarks/test_bigquery_partition_pruning_benchmark.py --benchmark
Open Graph Description: What this PR does / why we need it: Some BigQuery util does not use the date_partition_column as filtering condition, disabling partioning by those columns. Adjusted the function calls to make us...
X Description: What this PR does / why we need it: Some BigQuery util does not use the date_partition_column as filtering condition, disabling partioning by those columns. Adjusted the function calls to make us...
Opengraph URL: https://github.com/feast-dev/feast/pull/6076
X: @github
Domain: github.com
| route-pattern | /:user_id/:repository/pull/:id/files(.:format) |
| route-controller | pull_requests |
| route-action | files |
| fetch-nonce | v2:5315022c-b868-5628-5d3c-22b1ad993fc8 |
| current-catalog-service-hash | ae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b |
| request-id | EABA:100AB9:8020E2:AEC7C7:6A4DB50A |
| html-safe-nonce | 9afe62865ab2910ac629de4cb717cfb0b344130ac2d025aeda7d7dfb02857642 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJFQUJBOjEwMEFCOTo4MDIwRTI6QUVDN0M3OjZBNERCNTBBIiwidmlzaXRvcl9pZCI6IjUxODEwNjA3NTkzNzU2ODg5NzAiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ== |
| visitor-hmac | 96794f4be861a6b86451e6bf139b5733ea275b33d33fec179be6aebcb5f43e71 |
| hovercard-subject-tag | pull_request:3367451851 |
| github-keyboard-shortcuts | repository,pull-request-list,pull-request-conversation,pull-request-files-changed,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/feast-dev/feast/pull/6076/files |
| twitter:image | https://avatars.githubusercontent.com/u/46053503?s=400&v=4 |
| twitter:card | summary_large_image |
| og:image | https://avatars.githubusercontent.com/u/46053503?s=400&v=4 |
| og:image:alt | What this PR does / why we need it: Some BigQuery util does not use the date_partition_column as filtering condition, disabling partioning by those columns. Adjusted the function calls to make us... |
| og:site_name | GitHub |
| og:type | object |
| hostname | github.com |
| expected-hostname | github.com |
| None | 06b8a6144231bf3a234f1c2e9993861e07ce98a905912b114aa386c2d7e84b33 |
| turbo-cache-control | no-preview |
| diff-view | unified |
| go-import | github.com/feast-dev/feast git https://github.com/feast-dev/feast.git |
| octolytics-dimension-user_id | 57027613 |
| octolytics-dimension-user_login | feast-dev |
| octolytics-dimension-repository_id | 161133770 |
| octolytics-dimension-repository_nwo | feast-dev/feast |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 161133770 |
| octolytics-dimension-repository_network_root_nwo | feast-dev/feast |
| turbo-body-classes | logged-out env-production page-responsive full-width |
| disable-turbo | true |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 32f7b614aca06e6bbd89842b1370df1328264f68 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
Links:
Viewport: width=device-width