How can a bq query get 10,000 rows?

Question

How can we get 10,000 rows or more using the bq command line ?

Here is our code:

 bq --format=csv query "SELECT * FROM  [test.t1] limit 10000 "  > rs.txt

But returned the data about 100 rows, we tried with "max_rows_per_request", but we can not.

Answer 1

We will find a way to fix our code here: (add - max_rows )

bq --format=csv query --max_rows=100000  "SELECT * FROM  [test.t1] limit 10000  "  > a.txt