{"id":607,"date":"2021-06-15T03:02:07","date_gmt":"2021-06-14T18:02:07","guid":{"rendered":"http:\/\/kei0310.info\/?p=607"},"modified":"2021-06-15T03:02:26","modified_gmt":"2021-06-14T18:02:26","slug":"post-607","status":"publish","type":"post","link":"http:\/\/kei0310.info\/?p=607","title":{"rendered":"AWS Redshift\u306e\u4f7f\u7528\u30b9\u30c8\u30ec\u30fc\u30b8\u5bb9\u91cf\u3092\u30af\u30a8\u30ea\u3067\u8abf\u3079\u308b\u65b9\u6cd5"},"content":{"rendered":"\n<h2>\u7528\u9014<\/h2>\n\n\n\n<p>AWS Redshfit\u306e\u30b3\u30f3\u30bd\u30fc\u30eb\u3092\u898b\u308c\u3070\u3001\u4f7f\u7528\u4e2d\u306e\u30b9\u30c8\u30ec\u30fc\u30b8\u5bb9\u91cf\u306f\u308f\u304b\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3057\u304b\u3057\u3001\u81ea\u52d5\u5316\u7b49\u3067CLI\u3084Bot\u7b49\u304b\u3089\u8abf\u3079\u305f\u304f\u306a\u308b\u3053\u3068\u3082\u3042\u308a\u307e\u3059\u3088\u306d\u3002<\/p>\n\n\n\n<p>\u3068\u3044\u3046\u3053\u3068\u3067\u3001Redshift\u306e\u30af\u30e9\u30b9\u30bf\u5168\u4f53\u306e\u30b9\u30c8\u30ec\u30fc\u30b8\u5bb9\u91cf\u3068\u30c6\u30fc\u30d6\u30eb\u3054\u3068\u306e\u30b9\u30c8\u30ec\u30fc\u30b8\u5bb9\u91cf\u3092\u8abf\u3079\u308b\u65b9\u6cd5\u3092\u66f8\u3044\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2>\u30af\u30e9\u30b9\u30bf\u5168\u4f53\u306e\u30b9\u30c8\u30ec\u30fc\u30b8\u5bb9\u91cf<\/h2>\n\n\n\n<p>Redshift\u306e\u7ba1\u7406\u30c6\u30fc\u30d6\u30eb\u3067\u3042\u308b\u3001stv_blocklist\u30c6\u30fc\u30d6\u30eb\u3092\u5229\u7528\u3057\u3066\u8abf\u3079\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>select\n    sum(block_list.cnt)\nfrom\n(\n    select\n        tbl, count(*) as cnt\n    from\n        stv_blocklist\n    where\n        tbl in (select id from stv_tbl_perm)\n    group by\n        tbl\n) block_list\ninner join\n    svv_table_info ifo\non\n    block_list.tbl = ifo.table_id<\/code><\/pre>\n\n\n\n<h2>\u30c6\u30fc\u30d6\u30eb\u3054\u3068\u306e\u30b9\u30c8\u30ec\u30fc\u30b8\u5bb9\u91cf<\/h2>\n\n\n\n<p>\u4e0a\u8a18\u306e\u30af\u30e9\u30b9\u30bf\u5168\u4f53\u306e\u30b9\u30c8\u30ec\u30fc\u30b8\u5bb9\u91cf\u306e\u30af\u30a8\u30ea\u306bwhere\u53e5\u3067\u30c6\u30fc\u30d6\u30eb\u3092\u7d5e\u308c\u3070\u3088\u3044\u3067\u3059\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>where\n    ifo.table = '\u30c6\u30fc\u30d6\u30eb\u540d'<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u7528\u9014 AWS Redshfit\u306e\u30b3\u30f3\u30bd\u30fc\u30eb\u3092\u898b\u308c\u3070\u3001\u4f7f\u7528\u4e2d\u306e\u30b9\u30c8\u30ec\u30fc\u30b8\u5bb9\u91cf\u306f\u308f\u304b\u308a\u307e\u3059\u3002 \u3057\u304b\u3057\u3001\u81ea\u52d5\u5316\u7b49\u3067CLI\u3084Bot\u7b49\u304b\u3089\u8abf\u3079\u305f\u304f\u306a\u308b\u3053\u3068\u3082\u3042\u308a\u307e\u3059\u3088\u306d\u3002 \u3068\u3044\u3046\u3053\u3068\u3067\u3001Redshift\u306e\u30af\u30e9\u30b9\u30bf\u5168\u4f53\u306e\u30b9\u30c8\u30ec\u30fc\u30b8\u5bb9 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[214,236],"tags":[215,237,239,240,238],"_links":{"self":[{"href":"http:\/\/kei0310.info\/index.php?rest_route=\/wp\/v2\/posts\/607"}],"collection":[{"href":"http:\/\/kei0310.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/kei0310.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/kei0310.info\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/kei0310.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=607"}],"version-history":[{"count":2,"href":"http:\/\/kei0310.info\/index.php?rest_route=\/wp\/v2\/posts\/607\/revisions"}],"predecessor-version":[{"id":609,"href":"http:\/\/kei0310.info\/index.php?rest_route=\/wp\/v2\/posts\/607\/revisions\/609"}],"wp:attachment":[{"href":"http:\/\/kei0310.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=607"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/kei0310.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=607"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/kei0310.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}