{"height":"190","title":"Amazon Athena\u30e1\u30e2","type":"rich","width":"100%","categories":["\u6280\u8853\u30e1\u30e2#AWS"],"published":"2020-11-28 12:45:01","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/d/dekuo-03/20201101/20201101224646.png","author_url":"https://blog.hatena.ne.jp/dekuo-03/","provider_url":"https://hatena.blog","provider_name":"Hatena Blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fdekuo-03.hatenablog.jp%2Fentry%2F2020%2F11%2F28%2F124501\" title=\"Amazon Athena\u30e1\u30e2 - \u5de5\u4f5c\u3068\u7af6\u99ac2\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","version":"1.0","blog_title":"\u5de5\u4f5c\u3068\u7af6\u99ac2","blog_url":"https://dekuo-03.hatenablog.jp/","author_name":"dekuo-03","url":"https://dekuo-03.hatenablog.jp/entry/2020/11/28/124501","description":"\u53c2\u8003\u8cc7\u6599 docs.aws.amazon.com \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210 CREATE DATABASE mydatabase \u30c6\u30fc\u30d6\u30eb\u4f5c\u6210 CREATE EXTERNAL TABLE test ( id STRING, name STRING, value INT ) LOCATION 's3://{bucket-name}/athenatest/'; \u30ec\u30b3\u30fc\u30c9\u633f\u5165 INSERT INTO test VALUES ('id0', 'Sato', 100); \u30bb\u30ec\u30af\u30c8 select * from test;"}