{"author_name":"yohei-a","title":"Amazon Redshift \u3067\u53d6\u5f97\u3055\u308c\u305f\u7d50\u679c\u30bb\u30c3\u30c8\u306e\u884c\u6570\u3092\u8abf\u3079\u308b\u30af\u30a8\u30ea","width":"100%","blog_url":"https://yohei-a.hatenablog.jp/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fyohei-a.hatenablog.jp%2Fentry%2F20200307%2F1583567655\" title=\"Amazon Redshift \u3067\u53d6\u5f97\u3055\u308c\u305f\u7d50\u679c\u30bb\u30c3\u30c8\u306e\u884c\u6570\u3092\u8abf\u3079\u308b\u30af\u30a8\u30ea - ablog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","type":"rich","published":"2020-03-07 16:54:15","provider_name":"Hatena Blog","description":"\u76e3\u67fb\u30ed\u30b0\u53d6\u5f97\u76ee\u7684\u306a\u3069\u3067\u3001Amazon Redshift \u3067\u53d6\u5f97\u3055\u308c\u305f\u7d50\u679c\u30bb\u30c3\u30c8\u306e\u884c\u6570\u3092\u8abf\u3079\u308b\u30af\u30a8\u30ea\u3002 /* returned_rows */ select a.userid ,a.query ,a.substring sql ,b.rows from svl_qlog a join stl_return b on a.query=b.query where b.slice >= 6411 and a.userid != 1 and sql not like '/* returned_rows */%' union all select a.userid ,a.query ,a.substrin\u2026","url":"https://yohei-a.hatenablog.jp/entry/20200307/1583567655","author_url":"https://blog.hatena.ne.jp/yohei-a/","height":"190","version":"1.0","blog_title":"ablog","provider_url":"https://hatena.blog","categories":["AWS"],"image_url":null}