Title: Queries currently fail on large datasets · Issue #242 · googleapis/google-cloud-python · GitHub
Open Graph Title: Queries currently fail on large datasets · Issue #242 · googleapis/google-cloud-python
X Title: Queries currently fail on large datasets · Issue #242 · googleapis/google-cloud-python
Description: Queries currently fail on large datasets (>6000 entities). [1] We have many cases where we have well over 30K entities of a given Model that we'd like the ability to iterate over. [1] Code snippet & traceback: >>> query = dataset.query()...
Open Graph Description: Queries currently fail on large datasets (>6000 entities). [1] We have many cases where we have well over 30K entities of a given Model that we'd like the ability to iterate over. [1] Code snippet ...
X Description: Queries currently fail on large datasets (>6000 entities). [1] We have many cases where we have well over 30K entities of a given Model that we'd like the ability to iterate over. [1] Code s...
Opengraph URL: https://github.com/googleapis/google-cloud-python/issues/242
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Queries currently fail on large datasets","articleBody":"Queries currently fail on large datasets (\u003e6000 entities). [1] We\nhave many cases where we have well over 30K entities of a given Model that\nwe'd like the ability to iterate over.\n\n[1] Code snippet \u0026 traceback:\n\n``` python\n\u003e\u003e\u003e query = dataset.query().kind('Account')\n\u003e\u003e\u003e print datetime.datetime.utcnow(); all_accts = query.fetch(6000); print\ndatetime.datetime.utcnow()\n\n2014-10-02 09:27:55.235381\n2014-10-02 09:28:54.029017\n\n\u003e\u003e\u003e print datetime.datetime.utcnow(); all_accts = query.fetch(7000); print\ndatetime.datetime.utcnow()\n\n2014-10-02 09:29:01.298517\nTraceback (most recent call last):\nFile \"\u003cstdin\u003e\", line 1, in \u003cmodule\u003e\nFile\n\"/Users/ehiggins/src/datastore/.env/lib/python2.7/site-packages/gcloud-0.02.2-py2.7.egg/gcloud/datastore/query.py\",\nline 307, in fetch\nquery_pb=clone.to_protobuf(), dataset_id=self.dataset().id())\nFile\n\"/Users/ehiggins/src/datastore/.env/lib/python2.7/site-packages/gcloud-0.02.2-py2.7.egg/gcloud/datastore/connection.py\",\nline 207, in run_query\ndatastore_pb.RunQueryResponse)\nFile\n\"/Users/ehiggins/src/datastore/.env/lib/python2.7/site-packages/gcloud-0.02.2-py2.7.egg/gcloud/datastore/connection.py\",\nline 64, in _rpc\ndata=request_pb.SerializeToString())\nFile\n\"/Users/ehiggins/src/datastore/.env/lib/python2.7/site-packages/gcloud-0.02.2-py2.7.egg/gcloud/datastore/connection.py\",\nline 58, in _request\nraise Exception('Request failed. Error was: %s' % content)\nException: Request failed. Error was: Internal Error\n```\n","author":{"url":"https://github.com/feczo","@type":"Person","name":"feczo"},"datePublished":"2014-10-14T00:10:40.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":21},"url":"https://github.com/242/google-cloud-python/issues/242"}
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:093a044d-0a74-7247-8331-a1a9f4b200fd |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | ECEC:38F182:F4301F:14E2200:6A4DD268 |
| html-safe-nonce | 95e0b4d55199679bca27875b8f9dddbf35838c7a05dee660309c834ec1236f19 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJFQ0VDOjM4RjE4MjpGNDMwMUY6MTRFMjIwMDo2QTRERDI2OCIsInZpc2l0b3JfaWQiOiI4ODQwNzAxNjIzNzc0NTk3NzM3IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0= |
| visitor-hmac | d1cb178c410e77679810090f9e364ed4c4c8200acd88a724af3a7f669d6e026c |
| hovercard-subject-tag | issue:45699331 |
| github-keyboard-shortcuts | repository,issues,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/_view_fragments/issues/show/googleapis/google-cloud-python/242/issue_layout |
| twitter:image | https://opengraph.githubassets.com/67592d221c46e5470664b0e90dab8926be86c16924c175e22c5a509b15479f18/googleapis/google-cloud-python/issues/242 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/67592d221c46e5470664b0e90dab8926be86c16924c175e22c5a509b15479f18/googleapis/google-cloud-python/issues/242 |
| og:image:alt | Queries currently fail on large datasets (>6000 entities). [1] We have many cases where we have well over 30K entities of a given Model that we'd like the ability to iterate over. [1] Code snippet ... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | feczo |
| hostname | github.com |
| expected-hostname | github.com |
| None | 06b8a6144231bf3a234f1c2e9993861e07ce98a905912b114aa386c2d7e84b33 |
| turbo-cache-control | no-preview |
| go-import | github.com/googleapis/google-cloud-python git https://github.com/googleapis/google-cloud-python.git |
| octolytics-dimension-user_id | 16785467 |
| octolytics-dimension-user_login | googleapis |
| octolytics-dimension-repository_id | 16316451 |
| octolytics-dimension-repository_nwo | googleapis/google-cloud-python |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 16316451 |
| octolytics-dimension-repository_network_root_nwo | googleapis/google-cloud-python |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 1d344bdb7547fe6bca17a59bb2b8aac3dc9532a0 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
Links:
Viewport: width=device-width