BigQuery-在哪里可以找到错误流? [英] BigQuery - Where can I find the error stream?

问题描述

我已将具有30万行的CSV文件从GCS上传到BigQuery，并收到以下错误消息:

I have uploaded a CSV file with 300K rows from GCS to BigQuery, and received the following error:

我在哪里可以找到错误流?

我已经更改了创建表配置以允许4000个错误，并且该配置可以正常工作，因此消息中的3894行一定是有问题的，但是此错误消息并不能告诉我有关哪些行或原因的太多信息.

I've changed the create table configuration to allow 4000 errors and it worked, so it must be a problem with the 3894 rows in the message, but this error message does not tell me much about which rows or why.

谢谢

推荐答案

我终于可以通过在终端中运行以下命令来设法查看错误流:

I'm finally managed to see the error stream by running the following command in the terminal:

bq --format=prettyjson show -j <JobID>

它返回带有更多详细信息的JSON. 在我的情况下是:

It returns a JSON with more details. In my case it was:

"message": "Error while reading data, error message: Could not parse '16.66666666666667' as int for field Course_Percentage (position 46) starting at location 1717164"

这篇关于BigQuery-在哪里可以找到错误流?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！