{"url":"https://yohei-a.hatenablog.jp/entry/20180930/1538288097","blog_url":"https://yohei-a.hatenablog.jp/","height":"190","type":"rich","image_url":null,"version":"1.0","author_name":"yohei-a","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fyohei-a.hatenablog.jp%2Fentry%2F20180930%2F1538288097\" title=\"Presto\u3067\u7d50\u679c\u30bb\u30c3\u30c8\u3092\u30d5\u30a1\u30a4\u30eb\u306b\u51fa\u529b\u3059\u308b - ablog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","blog_title":"ablog","title":"Presto\u3067\u7d50\u679c\u30bb\u30c3\u30c8\u3092\u30d5\u30a1\u30a4\u30eb\u306b\u51fa\u529b\u3059\u308b","published":"2018-09-30 15:14:57","provider_url":"https://hatena.blog","description":"Simple answer : presto --execute \"select * from foo\" --output-format CSV > foo.csv You can use these formats : ALIGNED VERTICAL CSV TSV CSV_HEADER TSV_HEADER How to export result of select statement in prestodb.io - Stack Overflow \u3068\u3059\u308c\u3070\u3088\u3044\u3089\u3057\u3044\u3002 EMR \u3060\u3068\u3053\u3093\u306a\u611f\u3058\u3067\u3044\u3051\u305f\u3002 $ presto-cli --catalog hive --schema parq\u2026","author_url":"https://blog.hatena.ne.jp/yohei-a/","categories":["Hadoop"],"provider_name":"Hatena Blog","width":"100%"}