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

问题描述

在这里输入图像说明我试图在12 GB csv上运行查询文件加载谷歌大查询，我不能运行任何查询数据集。我不确定数据集是否正确加载。它在窗格中显示为表格，但它不存在于作业历史记录中。任何人都可以提供相同的帮助。

enter image description hereI 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

工作编号：pg-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错误：CSV表遇到太多错误，放弃。行：1错误：1的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！