search

google / patents-public-data

Patent analysis using the Google Patents Public Datasets on BigQuery
https://bigquery.cloud.google.com/dataset/patents-public-data:patents
Apache License 2.0
554 stars 163 forks source link

API limit exceeded: Unable to return a row that exceeds the API limits. To retrieve the row, export the table. #18

Open Syuan-Yi opened 5 years ago

Syuan-Yi commented 5 years ago

Hello,

First of all, it is really an exciting project and paper. Thank you!!

I tried to adapt the landscaping method on my project. But when I was in the "Load Inference Data" step, it showed the "API limit exceeded: Unable to return a row that exceeds the API limits. To retrieve the row, export the table" error. It seems there is only a way to workaround, that is: "export table" (please see: https://stackoverflow.com/questions/37547711/bigquery-api-limit-exceeded-error). What does it mean? which table should be exported? In addition, I tried to split L1 expansion patents to several small numbers, which could be dumped into the model for prediction. But it seems to go beyond my ability...Would you please give me some hints or tell me how to put all L1 expansion patents into the model? Thank you very much.

All the best, Syuan-Yi

sfd9898 commented 5 years ago

For larger downloads, I have downloaded a table from BigQuery separately and pointed scripts to that. Or, you can take a subset of the table/field you're downloading to fit within the API constraints.