search

LordThread / starschema-bigquery-jdbc

Automatically exported from code.google.com/p/starschema-bigquery-jdbc
0 stars 0 forks source link

Unable to retrieve more than 100,000 rows #4

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
1. Execute query using starschema jdbc driver.

What is the expected output? What do you see instead?
When executing the exact query in BigQuery Web Tool, we get 129,993 records.  
However, using the starschema jdbc driver in both SquirrelSQL and Pentaho, we 
only get 100,000 rows exactly every single time.

What version of the product are you using? On what operating system?
1.3

Please provide any additional information below.
Posted the question on stack overflow and someone mentioned a potential code 
fix:

http://stackoverflow.com/questions/14570761/bigquery-jdbc-driver-wont-return-mor
e-than-100-000-rows

Original issue reported on code.google.com by rob.emen...@gmail.com on 29 Jan 2013 at 4:28

GoogleCodeExporter commented 8 years ago 
Modified the code, tested with SquirrelSQL using the following queries:
"SELECT weight_pounds FROM publicdata:samples.natality LIMIT 400000" -> getting 
back 400.000 rows
"SELECT weight_pounds FROM publicdata:samples.natality LIMIT 500000" -> running 
out of the Squirrels 256Mb memory
"SELECT weight_pounds FROM publicdata:samples.natality" -> Response too large 
to return error from BigQuery

Original comment by guni...@starschema.net on 30 Jan 2013 at 9:21

GoogleCodeExporter commented 8 years ago 
You can obtain the new version from the Downloads list:
http://code.google.com/p/starschema-bigquery-jdbc/downloads/list

Original comment by guni...@starschema.net on 30 Jan 2013 at 9:21

GoogleCodeExporter commented 8 years ago 
This issue was closed by revision 4e1630147a78.

Original comment by bor...@starschema.net on 30 Jan 2013 at 9:23