当我尝试将数据文件加载到 BigQuery 时,它给我一个错误,MySQL 的默认时间戳值(至少来自 mysqldump(为 0000-00-00 00:00:00
.有没有办法更改我的 json 文件以允许datetime
字段中的这些值(见下文(?
错误:
gs://pfam31/pfamseq_part_04:CSV 表遇到太多错误,放弃。行: 11664;错误: 1. (错误代码:无效(
gs://pfam31/pfamseq_part_04:无法将"0000-00-00 00:00:00"解析为从位置 8743229 开始创建的字段(位置 13(的日期时间(错误代码:无效(
[
{
"mode": "REQUIRED",
"name": "pfamseq_acc",
"type": "STRING"
},
{
"mode": "REQUIRED",
"name": "pfamseq_id",
"type": "STRING"
},
{
"mode": "REQUIRED",
"name": "seq_version",
"type": "INTEGER"
},
{
"mode": "REQUIRED",
"name": "crc64",
"type": "STRING"
},
{
"mode": "REQUIRED",
"name": "md5",
"type": "STRING"
},
{
"mode": "REQUIRED",
"name": "description",
"type": "STRING"
},
{
"mode": "REQUIRED",
"name": "evidence",
"type": "INTEGER"
},
{
"mode": "REQUIRED",
"name": "length",
"type": "INTEGER"
},
{
"mode": "REQUIRED",
"name": "species",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "taxonomy",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "is_fragment",
"type": "INTEGER"
},
{
"mode": "REQUIRED",
"name": "sequence",
"type": "STRING"
},
{
"mode": "REQUIRED",
"name": "updated",
"type": "TIMESTAMP"
},
{
"mode": "NULLABLE",
"name": "created",
"type": "DATETIME"
},
{
"mode": "REQUIRED",
"name": "ncbi_taxid",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "auto_architecture",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "treefam_acc",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "swissprot",
"type": "INTEGER"
}
]
您不能将年/月/日设置为零。时间戳的范围是 '1970-01-01 00:00:01' UTC 到 '2038-01-19 03:14:07' UTC。欲了解更多信息,请点击此处
00:00 到 9999-12-31 23:59:59.999999 UTC(来自 Google 的文档(