{"title":"BigQuery\u306e\u300cBad int64 value\u300d\u306e\u30a8\u30e9\u30fc\u3092\u56de\u907f\u3059\u308b\u3010CAST\u3068SAFE_CAST\u306e\u9055\u3044\u3011","type":"rich","description":"\u76ee\u7684 BigQuery\u3067NULL\u3084\u7a7a\u767d\u304c\u3042\u308b\u30ab\u30e9\u30e0\u3092int\u306b\u5909\u63db\u3059\u308b\u65b9\u6cd5 \u80cc\u666f BigQuery\u3067\u3001\u5410\u304d\u51fa\u3057\u305f\u3044\u30ab\u30e9\u30e0\u304cInt\u304bNull\u306e\u3068\u304dCast\u3057\u3088\u3046\u3068\u3059\u308b\u3068Bad int64 value\u306e\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3059\u308b \u4f8b\u3048\u3070\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306aJSON\u3092RDB\u578b\u5f0f\u306b\u5410\u304d\u51fa\u3057\u305f\u3044\u3068\u3059\u308b\u3002 { { id: 1, name: \"\u30c8\u30de\u30c8\", price: 200 }, { id:2, name: \"\u30ad\u30e3\u30d9\u30c4\", price: null } } \u89e3\u6c7a\u65b9\u6cd5 \u672c\u6765\u3067\u3042\u308c\u3070price\u306bNULL\u306e\u3068\u304d\u306f0\u3092\u521d\u671f\u5024\u3067\u5165\u308c\u3066\u304a\u3053\u3046\u3088\u3068\u3044\u3046\u30b3\u30e1\u30f3\u30c8\u306f\u4e00\u56de\u7f6e\u3044\u3066\u304a\u3044\u3066\u3001JSON\u3092\u52a0\u5de5\u3057\u3066\u6574\u6570\u5024\u578b\u306b\u3059\u308b\u306b\u306f\u4ee5\u4e0b\u306b\u3059\u308c\u3070\u826f\u3044\u3002 CA\u2026","blog_url":"https://www.ikuo00uk.dev/","height":"190","width":"100%","provider_url":"https://hatena.blog","provider_name":"Hatena Blog","blog_title":"\u5143\u30a8\u30f3\u30b8\u30cb\u30a2PM\u306e\u30d7\u30ed\u30c0\u30af\u30c8\u30de\u30cd\u30fc\u30b8\u30e3\u30fc\u304a\u5f79\u7acb\u3061\u60c5\u5831","author_url":"https://blog.hatena.ne.jp/ikuo00uk/","published":"2021-04-02 15:04:15","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.ikuo00uk.dev%2Fentry%2F2021%2F04%2F02%2F150415\" title=\"BigQuery\u306e\u300cBad int64 value\u300d\u306e\u30a8\u30e9\u30fc\u3092\u56de\u907f\u3059\u308b\u3010CAST\u3068SAFE_CAST\u306e\u9055\u3044\u3011 - \u5143\u30a8\u30f3\u30b8\u30cb\u30a2PM\u306e\u30d7\u30ed\u30c0\u30af\u30c8\u30de\u30cd\u30fc\u30b8\u30e3\u30fc\u304a\u5f79\u7acb\u3061\u60c5\u5831\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","url":"https://www.ikuo00uk.dev/entry/2021/04/02/150415","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/i/ikuo00uk/20230325/20230325003115.png","author_name":"ikuo00uk","categories":["SQL"],"version":"1.0"}