Google Big Query Error: CSV table 遇到太多错误，放弃.行:1 错误:1 [英] Google Big Query Error: CSV table encountered too many errors, giving up. Row: 1 errors: 1

问题描述

我正在尝试对 Google 大查询中加载的 12 GB csv 文件运行查询，但无法对数据集运行任何查询.我不确定数据集是否正确加载.它在窗格中显示为表格，但它不存在于作业历史记录中.任何人都可以提供帮助.

I am trying to run a query on a 12 GB csv file loaded in Google big query, I cant run any query on the dataset. I am not sure if the dataset is loaded correctly. It shows as a table in the pane, but it is not present in the job history. Can anyone help on the same.

数据集是从一个谷歌存储桶加载的，它有大约 1.2MM 的记录和 3728 个变量

The dataset was loaded from a google storage bucket which has around 1.2MM records and 3728 variables

作业 ID:p-g-us-adv-x-dat-aia-proto-1:bquijob_b951879_1540d02c1a4

Job ID: p-g-us-adv-x-dat-aia-proto-1:bquijob_b951879_1540d02c1a4

推荐答案

检查您的架构 - 您可能忘记包含其中一列的架构 - 这就是我遇到的情况！

Check your schema - it's possible that you forgot to include the schema for one of the columns - that's what happened to me!

这篇关于Google Big Query Error: CSV table 遇到太多错误，放弃.行:1 错误:1的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！