{"id":539,"date":"2023-11-18T22:25:43","date_gmt":"2023-11-18T13:25:43","guid":{"rendered":"https:\/\/tako.nakano.net\/blog\/?p=539"},"modified":"2023-11-18T22:25:43","modified_gmt":"2023-11-18T13:25:43","slug":"bigquery-maniac","status":"publish","type":"post","link":"https:\/\/tako.nakano.net\/blog\/2023\/11\/bigquery-maniac\/","title":{"rendered":"\u3061\u3087\u3063\u3068\u30de\u30cb\u30a2\u30c3\u30af\u306a BigQuery \u306e\u8a71"},"content":{"rendered":"

\u306f\u3058\u3081\u306b<\/h2>\n

Google Cloud \u306e\u6709\u529b\u30b5\u30fc\u30d3\u30b9\u306e\u3072\u3068\u3064\u3067\u3042\u308b BigQuery \u306f\u3001\u30b5\u30fc\u30d0\u30ec\u30b9\u304b\u3064\u5206\u6563\u51e6\u7406\u3092\u884c\u3063\u3066\u304f\u308c\u308b\u306e\u3067\u3001\u30c6\u30e9\u30d0\u30a4\u30c8\u7d1a\u306e\u30c7\u30fc\u30bf\u3092\u51e6\u7406\u3059\u308b\u30af\u30a8\u30ea\u3067\u3082\u79d2\u5358\u4f4d\u3067\u7d50\u679c\u304c\u8fd4\u3063\u3066\u304d\u307e\u3059\u3002\u512a\u308c\u305f\u5206\u6563\u51e6\u7406\u306e\u305f\u3081\u3001\u4f7f\u3044\u65b9\u306b\u3088\u3063\u3066\u306f\u30af\u30a8\u30ea\u306e\u51e6\u7406\u52b9\u7387\u3092\u7279\u306b\u610f\u8b58\u3057\u306a\u304f\u3066\u3082\u5229\u7528\u3067\u304d\u307e\u3059\u3002\u4e00\u65b9\u3067\u3001\u540c\u3058\u7d50\u679c\u304c\u5f97\u3089\u308c\u308b\u30af\u30a8\u30ea\u3067\u3082\u3001\u3069\u306e\u3088\u3046\u306b\u66f8\u304f\u304b\u306b\u3088\u3063\u3066\u3001\u51e6\u7406\u6642\u9593\u304c\u5927\u304d\u304f\u5909\u308f\u3063\u3066\u304d\u307e\u3059\u3002\u4eca\u56de\u306f\u3001BigQuery \u306e\u30af\u30a8\u30ea\u3092\u66f8\u304f\u3068\u304d\u306b\u6c17\u3092\u3064\u3051\u308b\u3068\u826f\u3044\u30dd\u30a4\u30f3\u30c8\u306e\u3046\u3061\u3001\u3042\u307e\u308a\u77e5\u3089\u308c\u3066\u3044\u306a\u3044\u300cWHERE \u53e5\u306e\u6761\u4ef6\u306e\u9806\u756a\u300d\u306b\u3064\u3044\u3066\u3001\u5b9f\u4f8b\u30fb\u6570\u5024\u3068\u3068\u3082\u306b\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n

WHERE \u53e5\u306e\u6761\u4ef6\u306e\u9806\u756a<\/h2>\n

BigQuery \u7ba1\u7406\u8005\u30ea\u30d5\u30a1\u30ec\u30f3\u30b9 \u30ac\u30a4\u30c9: \u30af\u30a8\u30ea\u306e\u6700\u9069\u5316<\/a> \uff08\u82f1\u8a9e\u7248\u306fBigQuery Admin reference guide: Query optimization<\/a>\uff09\u3067\u89e6\u308c\u3089\u308c\u3066\u3044\u308b\u3082\u306e\u3067\u3059\u304c\u3001\u753b\u50cf\u304c\u8352\u304f\u3001\u52d5\u753b\u5185\u306b\u3057\u304b\u5b9f\u969b\u306e\u30af\u30a8\u30ea\u304c\u306a\u3044\uff08\u52d5\u753b\u306f\u304d\u308c\u3044\u3067\u3059\uff09\u305f\u3081\u3001\u30b3\u30d4\u30fc\u53ef\u80fd\u306a\u30b3\u30fc\u30c9\u3068\u5171\u306b\u304a\u898b\u305b\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n

\u5f53\u8a72\u8a18\u4e8b\u306b\u306f:<\/p>\n

\n

\u5f0f\u306e\u9806\u756a\u304c\u91cd\u8981: BigQuery \u306f WHERE \u53e5\u3067\u6307\u5b9a\u3055\u308c\u3066\u3044\u308b\u5f0f\u306e\u9806\u5e8f\u304c\u6700\u9069\u3060\u3068\u60f3\u5b9a\u3057\u3001\u5f0f\u306e\u9806\u5e8f\u3092\u5909\u66f4\u3059\u308b\u3053\u3068\u306f\u3042\u308a\u307e\u305b\u3093\u3002WHERE \u53e5\u306b\u306f\u3001\u6700\u3082\u30c7\u30fc\u30bf\u3092\u7d5e\u308a\u8fbc\u3080\u3053\u3068\u306e\u3067\u304d\u308b\u5f0f\u3092\u6700\u521d\u306b\u4e26\u3079\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<\/blockquote>\n

\u3068\u66f8\u304b\u308c\u3066\u3044\u307e\u3059\u3002
\n\u52d5\u753bStrategies for optimizing your BigQuery queries 5:48<\/a> \u304c\u3001\u8a72\u5f53\u7b87\u6240\u3067\u3059\u3002\u4f8b\u3067\u306f\u3001bigquery-public-data<\/code> \u3068\u3044\u3046\u3001\uff08\u30af\u30a8\u30ea\u6599\u91d1\u3060\u3051\u3067\uff09\u7121\u6599\u3067\u5229\u7528\u3067\u304d\u308b\u4e00\u822c\u516c\u958b\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u306b\u30af\u30a8\u30ea\u3092\u884c\u3063\u3066\u3044\u307e\u3059\u3002bigquery-public-data.stackoverflow.comments<\/code> \u30c6\u30fc\u30d6\u30eb\u304b\u3089\u3001user_display_name<\/code> \u304c anon<\/code> \u3067\u3001\u304b\u3064 text<\/code> \u306b java<\/code> \u304c\u542b\u307e\u308c\u308b\u30b3\u30e1\u30f3\u30c8\u3092\u62bd\u51fa\u3059\u308b\u30af\u30a8\u30ea\u3092\u3001\u4ee5\u4e0b\u306e\u30af\u30a8\u30ea1\u306e\u3088\u3046\u306b\u66f8\u304f\u3053\u3068\u3092\u63a8\u5968\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n

\u30af\u30a8\u30ea1:<\/p>\n

SELECT text\nFROM `bigquery-public-data.stackoverflow.comments`\nWHERE\n  user_display_name = 'anon'\n  AND text LIKE '%java%';<\/code><\/pre>\n
\u3053\u308c\u306f\u3001\u6b21\u306e\u30af\u30a8\u30ea2\u3088\u308a\u9ad8\u901f\u306b\u51e6\u7406\u3055\u308c\u307e\u3059\u3002<\/p>\n
\u30af\u30a8\u30ea2:<\/p>\n
SELECT text\nFROM `bigquery-public-data.stackoverflow.comments`\nWHERE\n  text LIKE '%java%'\n  AND user_display_name = 'anon';<\/code><\/pre>\n
\u7406\u7531\u3092\u7c21\u5358\u306b\u8ff0\u3079\u308b\u3068\u3059\u308b\u306a\u3089\u3070<\/p>\n
    \n
  1. \u4e00\u81f4\u3067\u5224\u5b9a\u3059\u308b\u65b9\u304c\u3001\u90e8\u5206\u4e00\u81f4\u3067\u5224\u5b9a\u3059\u308b\u3088\u308a\u3082\u9ad8\u901f<\/li>\n
  2. \u6050\u3089\u304f\u3001user_display_name<\/code> \u304c anon<\/code> \u3067\u3042\u308b\u30ec\u30b3\u30fc\u30c9\u306f\u3001text<\/code> \u306b java<\/code> \u304c\u542b\u307e\u308c\u308b\u30ec\u30b3\u30fc\u30c9\u3088\u308a\u3082\u5c11\u306a\u3044<\/li>\n
  3. user_display_name<\/code> \u304c anon<\/code> \u3067\u3042\u308b\u30ec\u30b3\u30fc\u30c9\u3092\u5148\u306b\u7d5e\u308a\u8fbc\u3080\u3068\u3001text<\/code> \u306b java<\/code> \u304c\u542b\u307e\u308c\u308b\u304b\u3069\u3046\u304b\u3092\u5224\u5b9a\u3059\u308b\u30ec\u30b3\u30fc\u30c9\u6570\u304c\u5c11\u306a\u304f\u306a\u308b<\/li>\n<\/ol>\n
    \u3068\u8003\u3048\u3089\u308c\u308b\u3067\u3057\u3087\u3046\u3002<\/p>\n
    \u30af\u30a8\u30ea1\u306e\u7d50\u679c\u306f\u6b21\u3067\u3059\u3002
    \n\u51e6\u7406\u3055\u308c\u305f\u30d0\u30a4\u30c8\u6570\u3001\u8ab2\u91d1\u3055\u308c\u308b\u30d0\u30a4\u30c8\u6570 \u306f\u3068\u3082\u306b 12.81 GB \u3067\u3042\u308a\u3001\u30b9\u30ed\u30c3\u30c8\uff08\u30df\u30ea\u79d2\uff09 \u306f 10951 \u3067\u3057\u305f\u3002\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u300c\u5b9f\u884c\u306e\u8a73\u7d30\u300d\u3068\u300c\u5b9f\u884c\u30b0\u30e9\u30d5\u300d\u304c\u5f97\u3089\u308c\u307e\u3057\u305f\u3002\u300c\u5b9f\u884c\u306e\u8a73\u7d30\u300d\u3088\u308a\u7d4c\u904e\u6642\u9593\u304c 814 \u30df\u30ea\u79d2\u3067\u3001\u4e0b\u306e\u30b9\u30c6\u30fc\u30b8 S00 \u306e\u30b3\u30f3\u30d4\u30e5\u30fc\u30c6\u30a3\u30f3\u30b0\u304c 35 \u30df\u30ea\u79d2\u3067\u3042\u308b\u3053\u3068\u306b\u6ce8\u76ee\u3057\u3066\u304a\u3044\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
    \u8a73\u7d30:
    \n    \"\u30af\u30a8\u30ea1\u306e\u5b9f\u884c\u306e\u8a73\u7d30\"<\/a>
    \n\u30b0\u30e9\u30d5:
    \n    \"\u30af\u30a8\u30ea1\u306e\u5b9f\u884c\u30b0\u30e9\u30d5\"<\/a><\/p>\n
    \u30af\u30a8\u30ea2\u306e\u7d50\u679c\u306f\u6b21\u3067\u3059\u3002
    \n\u51e6\u7406\u3055\u308c\u305f\u30d0\u30a4\u30c8\u6570\u3001\u8ab2\u91d1\u3055\u308c\u308b\u30d0\u30a4\u30c8\u6570 \u306f\u3068\u3082\u306b 12.81 GB \u3067\u3042\u308a\u3001\u30af\u30a8\u30ea1\u3068\u540c\u3058\u3067\u3057\u305f\u3002\u3064\u307e\u308a\u3001\u30aa\u30f3\u30c7\u30de\u30f3\u30c9\u6599\u91d1\u306e\u5834\u5408\u3067\u306f\u767a\u751f\u3059\u308b\u6599\u91d1\u306f\u540c\u3058\u3067\u3059\u3002\u4e00\u65b9\u3067\u3001\u30b9\u30ed\u30c3\u30c8\uff08\u30df\u30ea\u79d2\uff09 \u306f 128471 \u3068\u306a\u308a\u3001\u7d0412\u500d\u3067\u3057\u305f\u3002\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u300c\u5b9f\u884c\u306e\u8a73\u7d30\u300d\u3068\u300c\u5b9f\u884c\u30b0\u30e9\u30d5\u300d\u304c\u5f97\u3089\u308c\u307e\u3057\u305f\u3002\u300c\u5b9f\u884c\u306e\u8a73\u7d30\u300d\u306b\u3088\u308b\u3068\u3001\u7d4c\u904e\u6642\u9593\u304c 2 \u79d2\u3067\u3001\u4e0b\u306e\u30b9\u30c6\u30fc\u30b8 S00 \u306e\u30b3\u30f3\u30d4\u30e5\u30fc\u30c6\u30a3\u30f3\u30b0\u304c 1 \u79d2\u3067\u3059\u3002<\/p>\n
    \u8a73\u7d30:
    \n    \"\u30af\u30a8\u30ea2\u306e\u5b9f\u884c\u306e\u8a73\u7d30\"<\/a>
    \n\u30b0\u30e9\u30d5:
    \n    \"\u30af\u30a8\u30ea2\u306e\u5b9f\u884c\u30b0\u30e9\u30d5\"<\/a><\/p>\n
    \u4e21\u65b9\u3068\u3082\u7d50\u679c\u304c27\u884c\u3067\u3042\u308b\u3053\u3068\u306f\u5909\u308f\u308a\u307e\u305b\u3093\u304c\u3001\u30af\u30a8\u30ea1\u306e\u65b9\u304c\u51e6\u7406\u6642\u9593\u304c\u77ed\u304f\u3001\u30b9\u30ed\u30c3\u30c8\u6570\u3082\u5c11\u306a\u3044\u3053\u3068\u304c\u308f\u304b\u308a\u307e\u3059\u3002<\/p>\n
    \u8ffd\u52a0\u5b9f\u9a13<\/h2>\n
    user_display_name = 'anon'<\/code> \u306e\u90e8\u5206\u3092 user_display_name LIKE '%anon%'<\/code> \u306b\u5909\u66f4\u3057\u3001\u7d50\u679c\u304c\u3069\u3046\u5909\u5316\u3059\u308b\u306e\u304b\u898b\u3066\u307f\u307e\u3057\u3087\u3046\u3002\u3069\u3061\u3089\u304c\u5148\u306b\u3042\u308b\u65b9\u304c\u9ad8\u901f\u306b\u51e6\u7406\u3067\u304d\u308b\u306e\u304b\u3001\u4e88\u60f3\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
    \u540c\u3058\u3088\u3046\u306b\u3001\u30af\u30a8\u30ea3\u3068\u30af\u30a8\u30ea4\u3092\u7528\u610f\u3057\u3066\u3001\u5b9f\u884c\u3057\u307e\u3057\u305f\u3002<\/p>\n
    \u30af\u30a8\u30ea3:<\/p>\n
    SELECT text\nFROM `bigquery-public-data.stackoverflow.comments`\nWHERE\n  user_display_name LIKE '%anon%'\n  AND text LIKE '%java%';<\/code><\/pre>\n
    \u30af\u30a8\u30ea4:<\/p>\n
    SELECT text\nFROM `bigquery-public-data.stackoverflow.comments`\nWHERE\n  text LIKE '%java%'\n  AND user_display_name LIKE '%anon%';<\/code><\/pre>\n
    \u30af\u30a8\u30ea3\u306f\u3001\u30b9\u30ed\u30c3\u30c8\uff08\u30df\u30ea\u79d2\uff09\u304c 5908 \u3067\u3057\u305f\u3002\u300c\u5b9f\u884c\u306e\u8a73\u7d30\u300d\u306b\u3088\u308b\u3068\u3001\u5168\u4f53\u3067 903 \u30df\u30ea\u79d2\u3067\u3057\u305f\u3002\u7d50\u679c\u30bb\u30c3\u30c8\u306f 39 \u884c\u3067\u3001\u5c11\u3057\u5897\u3048\u3066\u3044\u307e\u3059\u3002
    \n    \"\u30af\u30a8\u30ea3\u306e\u5b9f\u884c\u306e\u8a73\u7d30\"<\/a><\/p>\n
    \u30af\u30a8\u30ea4\u306f\u3001\u30b9\u30ed\u30c3\u30c8\uff08\u30df\u30ea\u79d2\uff09\u304c 135165 \u3067\u3057\u305f\u3002\u300c\u5b9f\u884c\u306e\u8a73\u7d30\u300d\u306b\u3088\u308b\u3068\u3001\u5168\u4f53\u3067 2 \u79d2\u3067\u3057\u305f\u3002\u7d50\u679c\u30bb\u30c3\u30c8\u306f 39 \u884c\u3067\u3001\u30af\u30a8\u30ea3\u3068\u540c\u3058\u3067\u3059\u3002
    \n    \"\u30af\u30a8\u30ea4\u306e\u5b9f\u884c\u306e\u8a73\u7d30\"<\/a><\/p>\n
    \u30af\u30a8\u30ea3\u3068\u30af\u30a8\u30ea4\u306e\u7d50\u679c\u306e\u9806\u306f\u4e88\u60f3\u901a\u308a\u3067\u3057\u305f\u304b\uff1f\u30af\u30a8\u30ea1\u30682\u306e\u95a2\u4fc2\u3068\u5927\u4f53\u540c\u3058\u3060\u3068\u8a00\u3063\u3066\u826f\u3044\u3067\u3057\u3087\u3046\u3002<\/p>\n
    \u300c\u3088\u308a\u8907\u96d1\u300d\u306a\u30af\u30a8\u30ea3\u306e\u65b9\u304c\u3001\u30af\u30a8\u30ea2\u3088\u308a\u3082\u9ad8\u901f\u3067\u3042\u3063\u305f\u3053\u3068\u306b\u3082\u6ce8\u76ee\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u300cWHERE \u53e5\u306e\u6761\u4ef6\u306e\u9806\u5e8f\u300d\u3060\u3051\u3067\u3082\u901f\u5ea6\u30fb\u52b9\u7387\u304c\u5909\u308f\u308b\u306e\u3067\u3001\u610f\u8b58\u3059\u308b\u3068\u65e9\u304f\u306a\u308b\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n
    \u88dc\u8db3<\/h3>\n
    BigQuery \u306b\u306f\u300c\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30cb\u30f3\u30b0\u300d\u3084\u300c\u30af\u30e9\u30b9\u30bf\u30ea\u30f3\u30b0\u300d\u3068\u3044\u3046\u6a5f\u80fd\u304c\u3042\u308a\u307e\u3059\u306e\u3067\u3001\u305d\u3061\u3089\u304c\u5229\u7528\u3067\u304d\u308b\u3068\u304d\u306f\u5229\u7528\u3059\u308b\u3068\u3001\u3055\u3089\u306b\u52b9\u7387\u826f\u304f\u7d50\u679c\u3092\u5f97\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n
    \u53c2\u8003<\/h2>\n
    bigquery-public-data.stackoverflow.comments<\/code> \u30c6\u30fc\u30d6\u30eb\u306e\u30b9\u30ad\u30fc\u30de\u3068\u3001SELECT id FROM ...<\/code> \u3068\u3057\u305f\u3068\u304d\u306b\u300c\u3053\u306e\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3059\u308b\u3068\u300112.8 GB \u304c\u51e6\u7406\u3055\u308c\u307e\u3059\u3002\u300d\u306e\u3088\u3046\u306b\u8868\u793a\u3055\u308c\u308b\u90e8\u5206\u306e\u30c7\u30fc\u30bf\u30b5\u30a4\u30ba\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n\n\n\n\n\n\n\n\n
    \u30d5\u30a3\u30fc\u30eb\u30c9\u540d<\/th>\n\u7a2e\u985e<\/th>\n\u30e2\u30fc\u30c9<\/th>\n\u30b5\u30a4\u30ba<\/th>\n<\/tr>\n<\/thead>\n
    id<\/td>\nINTEGER<\/td>\nNULLABLE<\/td>\n661.88 MB<\/td>\n<\/tr>\n
    text<\/td>\nSTRING<\/td>\nNULLABLE<\/td>\n12.8 GB<\/td>\n<\/tr>\n
    creation_date<\/td>\nTIMESTAMP<\/td>\nNULLABLE<\/td>\n661.88 MB<\/td>\n<\/tr>\n
    post_id<\/td>\nINTEGER<\/td>\nNULLABLE<\/td>\n661.88 MB<\/td>\n<\/tr>\n
    user_id<\/td>\nINTEGER<\/td>\nNULLABLE<\/td>\n661.88 MB<\/td>\n<\/tr>\n
    user_display_name<\/td>\nSTRING<\/td>\nNULLABLE<\/td>\n17 MB<\/td>\n<\/tr>\n
    score<\/td>\nINTEGER<\/td>\nNULLABLE<\/td>\n661.88 MB<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
    \u884c\u6570 86,754,111\u3001\u5408\u8a08\u8ad6\u7406\u30d0\u30a4\u30c8\u6570 16.03 GB\u3001\u5408\u8a08\u7269\u7406\u30d0\u30a4\u30c8\u6570 6.63 GB \u3067\u3057\u305f\u3002<\/p>\n
    \u5927\u4f53\u306e\u9577\u3055\u306e\u5206\u5e03\u3092\u898b\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n
    SELECT\n  APPROX_QUANTILES(LENGTH(user_display_name), 10),\n  APPROX_QUANTILES(LENGTH(COALESCE(user_display_name, '')), 10),\n  APPROX_QUANTILES(LENGTH(text), 10),\n  APPROX_QUANTILES(LENGTH(COALESCE(text, '')), 10)\nFROM `bigquery-public-data.stackoverflow.comments`;<\/code><\/pre>\n
    \u306e\u7d50\u679c\u3092\u6a2a\u306b\u4e26\u3079\u308b\u3068\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u307e\u3057\u305f\u3002<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
    quantile<\/th>\nname<\/th>\nname_with_null<\/th>\ntext<\/th>\ntext_with_null<\/th>\n<\/tr>\n<\/thead>\n
    0<\/td>\n2<\/td>\n0<\/td>\n1<\/td>\n0<\/td>\n<\/tr>\n
    1<\/td>\n10<\/td>\n0<\/td>\n43<\/td>\n43<\/td>\n<\/tr>\n
    2<\/td>\n10<\/td>\n0<\/td>\n63<\/td>\n63<\/td>\n<\/tr>\n
    3<\/td>\n11<\/td>\n0<\/td>\n82<\/td>\n82<\/td>\n<\/tr>\n
    4<\/td>\n11<\/td>\n0<\/td>\n101<\/td>\n101<\/td>\n<\/tr>\n
    5<\/td>\n11<\/td>\n0<\/td>\n124<\/td>\n124<\/td>\n<\/tr>\n
    6<\/td>\n11<\/td>\n0<\/td>\n150<\/td>\n150<\/td>\n<\/tr>\n
    7<\/td>\n11<\/td>\n0<\/td>\n184<\/td>\n183<\/td>\n<\/tr>\n
    8<\/td>\n11<\/td>\n0<\/td>\n231<\/td>\n231<\/td>\n<\/tr>\n
    9<\/td>\n12<\/td>\n0<\/td>\n315<\/td>\n316<\/td>\n<\/tr>\n
    10<\/td>\n30<\/td>\n30<\/td>\n600<\/td>\n600<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
    user_display_name \u306f\u305d\u3082\u305d\u3082\u5024\u304c\u5165\u3063\u3066\u3044\u306a\u3044\u3053\u3068\u3082\u591a\u304f\u3001\u305d\u308c\u3082\u542b\u3081\u3066\u30c7\u30fc\u30bf\u91cf\u304c\u5c11\u306a\u3044\u72b6\u614b\u3067\u3057\u305f\u3002\u3053\u3061\u3089\u3092\u5148\u306b\u8003\u616e\u3057\u305f\u65b9\u304c\u65ad\u7136\u65e9\u304b\u3063\u305f\u3068\u3044\u3046\u8a33\u3067\u3059\u306d\u3002<\/p>\n
    References<\/h2>\n