{"blog_url":"https://www.shigemk2.com/","author_name":"shigemk2","url":"https://www.shigemk2.com/entry/2017/07/13/presto_query_tips","published":"2017-07-13 15:58:19","provider_url":"https://hatena.blog","description":"presto\u306e\u30af\u30a8\u30ea\u3092\u66f8\u304f\u3068\u304d\u306b\u5fc5\u8981\u306atips(\u306a\u3093\u304b\u524d\u3082\u7d39\u4ecb\u3057\u305f\u3088\u3046\u306a) \u7121\u90aa\u6c17\u306b\u30a2\u30b9\u30bf\u3092\u4f7f\u308f\u306a\u3044 select * from tbl1 \u4f7f\u3046\u306a\u3089\u30ab\u30e9\u30e0\u540d\u306f\u7d5e\u308b prototype\u3067\u306fvalue\u3092\u4f7f\u3046 \u53ef\u80fd\u3067\u3042\u308b\u306a\u3089with\u3092\u4f7f\u3046 time\u306e\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u3067\u5272\u308a\u7b97\u3068\u304bfloat\u3068\u304bbetween\u3068\u304b\u4f7f\u308f\u306a\u3044 \u30ab\u30fc\u30c7\u30a3\u30ca\u30ea\u30c6\u30a3\u306e\u9ad8\u3044\u3082\u306e\u304b\u3089\u5148\u306bgroup by\u3059\u308b limit\u3068order by\u3092\u7d44\u307f\u5408\u308f\u305b\u308b \u6982\u7b97\u304c\u77e5\u308a\u305f\u3044\u306a\u3089distinct\u3088\u308aapprox_distinct\u3092\u4f7f\u304a\u3046 \u8907\u6570like\u3088\u308aregexp_like\u3092\u4f7f\u3046 \u306a\u3069","title":"presto query tips","height":"190","provider_name":"Hatena Blog","type":"rich","version":"1.0","blog_title":"by shigemk2","width":"100%","image_url":null,"author_url":"https://blog.hatena.ne.jp/shigemk2/","categories":["Presto"],"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.shigemk2.com%2Fentry%2F2017%2F07%2F13%2Fpresto_query_tips\" title=\"presto query tips - by shigemk2\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>"}