在Golang中阅读BigQuery。并不是所有预期的结果都会给出。该怎么办呢？

query := `
SELECT column1, column2
FROM `your_dataset.your_table`
WHERE condition = 'value'
`
fmt.Println(query) // 打印查询语句进行检查

query := `
SELECT CAST(column1 AS STRING) AS column1_str, column2
FROM `your_dataset.your_table`
WHERE condition = 'value'
`

query := `
SELECT column1, column2
FROM `your_dataset.your_partitioned_table`
WHERE partition_date = '2023-04-01'
AND condition = 'value'
`

it, err := client.Read(ctx, bigquery.QueryRequest{
    Query: query,
    MaxResults: 1000, // 设置最大返回结果数
})
if err != nil {
    log.Fatal(err)
}
defer it.Stop()

for {
    var row yourRowType
    err := it.Next(&row)
    if err == iterator.Done {
        break
    }
    if err != nil {
        log.Fatal(err)
    }
    // 处理每一行数据
}

package main

import (
    "context"
    "fmt"
    "log"

    "cloud.google.com/go/bigquery"
)

type YourRowType struct {
    Column1 string `bigquery:"column1"`
    Column2 int    `bigquery:"column2"`
}

func main() {
    ctx := context.Background()
    client, err := bigquery.NewClient(ctx, "your-project-id")
    if err != nil {
        log.Fatal(err)
    }
    defer client.Close()

    query := `
    SELECT column1, column2
    FROM `your_dataset.your_table`
    WHERE condition = 'value'
    `

    it, err := client.Read(ctx, bigquery.QueryRequest{
        Query: query,
    })
    if err != nil {
        log.Fatal(err)
    }
    defer it.Stop()

    for {
        var row YourRowType
        err := it.Next(&row)
        if err == iterator.Done {
            break
        }
        if err != nil {
            log.Fatal(err)
        }
        fmt.Printf("Column1: %s, Column2: %d\n", row.Column1, row.Column2)
    }
}