BigQuery JDBC does not do nested filtering correctly

[nodeworks]

Component

What is the current behaviour?

I have two datasets that I link by a string ID. They are both account tables, it is a one-to-one relationship (Object type).

They link correctly in that I can select nested fields and build a where query with nested field filtering. However, we run into a "row limit exceeded issue" even when I specify a limit of 10 or even a limit of 1. It seems as thought it's running the nested filter level query as a separate query, which if there resulting dataset is larger than 10,000 rows it will come back with an error.

What is the expected behaviour?

It should be creating a simple LEFT JOIN and do the proper filtering and limiting.

Screenshots or Screencast

It does this query it seems first which is the problem, there is no limit applied:

Keywords

bigquery, ndc-jdbc, nested filtering