3543

google big query limit clause returning too many rows

Question:

In big query I am running a query on exported tables from GA.

I can not seem to get big query to limit the results. Here is a sample query, quite basic.

SELECT * FROM [1111111.ga_sessions_20140318] LIMIT 20000

The result set returns but with 7 million+ rows! I have tried this several different ways, ie. out to a table, just return result set, use cache results, don't use cached results, etc. No matter which table I try to query it always returns the entire table.

This is basically the same as the sample query big query gives when clicking on the query table button except I changed the limit value from 1000 to 20000.

Anyone have any insight?

Answer1:

As noted by the comment on the original question:

<blockquote>

"Is it possible that the number of rows shown at the bottom of the result set returned in big query is my 20000 main object records plus all the nested records?"

</blockquote>

The answer is yes: BigQuery will apply the limit to the number of rows in the response, but if there are nested records involved, those will be flattened in the output.

Recommend

  • Numpy: 2D array access with 2D array of indices
  • How to find tail rows of a data frame that satisfy set criteria?
  • how to handle onLoad Event on img tag and others
  • Teradata Database 3130 Response limit exceeded?
  • Python: how to split and return a list from a function to avoid memory error
  • What distributed message queues support millions of queues?
  • Iterate twice through a DataReader
  • PWA with multiple pages
  • Java : How to tint this PNG programmatically?
  • HttpClient: disabling chunked encoding
  • HttpListener.IsSupported is false on XP SP3
  • Clear fused location provider's location for testing
  • android.support.v7.widget.Toolbar VectorDrawableCompat IllegalStateException when using support lib
  • Tamper-proof configuration files in .NET?
  • jQuery ready not fired after rails link_to is clicked
  • Using $this when not in object context
  • How would I use PHP exceptions to define a redirect?
  • Fill an image in a square container while keeping aspect ratio
  • vba code to select only visible cells in specific column except heading
  • Javascript + PHP Encryption with pidCrypt
  • How to limit post in wp_query
  • Do I've to free mysql result after storing it?
  • Delete MySQLi record without showing the id in the URL
  • Rearranging Cells in UITableView Bug & Saving Changes
  • WOWZA + RTMP + HTML5 Playback?
  • php design question - will a Helper help here?
  • Transpose CSV data with awk (pivot transformation)
  • Windows forms listbox.selecteditem displaying “System.Data.DataRowView” instead of actual value
  • AngularJs get employee from factory
  • How to set the response of a form post action to a iframe source?
  • Hits per day in Google Big Query
  • Change div Background jquery
  • How does Linux kernel interrupt the application?
  • Qt: Run a script BEFORE make
  • IndexOutOfRangeException on multidimensional array despite using GetLength check
  • Authorize attributes not working in MVC 4
  • Add sale price programmatically to product variations
  • Sorting a 2D array using the second column C++
  • reshape alternating columns in less time and using less memory
  • Reading document lines to the user (python)