{"id":5374,"date":"2023-02-12T06:16:37","date_gmt":"2023-02-12T02:46:37","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/how-to-query-csv-file-stored-in-aws-s3-using-athena-17p9\/"},"modified":"2023-02-12T06:16:37","modified_gmt":"2023-02-12T02:46:37","slug":"how-to-query-csv-file-stored-in-aws-s3-using-athena-17p9","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/how-to-query-csv-file-stored-in-aws-s3-using-athena-17p9\/","title":{"rendered":"\u0686\u06af\u0648\u0646\u0647 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 Athena \u0641\u0627\u06cc\u0644 CSV \u0630\u062e\u06cc\u0631\u0647 \u0634\u062f\u0647 \u062f\u0631 AWS S3 \u0631\u0627 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u06a9\u0646\u06cc\u0645\u061f"},"content":{"rendered":"<div data-article-id=\"1362111\" id=\"article-body\">\n<p><strong>CSV (\u0645\u0642\u0627\u062f\u06cc\u0631 \u062c\u062f\u0627 \u0634\u062f\u0647 \u0628\u0627 \u06a9\u0627\u0645\u0627)<\/strong> \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062f\u0631 \u0646\u0638\u0631 \u06af\u0631\u0641\u062a\u0647 \u0634\u0648\u062f \u0648 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u062f\u0631 \u0642\u0627\u0644\u0628 \u062c\u062f\u0648\u0644 \u0630\u062e\u06cc\u0631\u0647 \u0645\u06cc \u06a9\u0646\u062f.  \u062a\u0627 \u0622\u0646\u062c\u0627 \u06a9\u0647 \u0645\u0646 \u0645\u06cc \u062f\u0627\u0646\u0645\u060c CSV \u062f\u0631 \u0647\u0645\u0647 \u062c\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a.  \u0627\u0632 \u06af\u0632\u0627\u0631\u0634\u200c\u0647\u0627 \u06af\u0631\u0641\u062a\u0647 \u062a\u0627 \u06cc\u0627\u062f\u06af\u06cc\u0631\u06cc \u0645\u0627\u0634\u06cc\u0646 \u0628\u0631\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 \u0645\u062c\u0645\u0648\u0639\u0647 \u062f\u0627\u062f\u0647 \u0648 \u0645\u0648\u0627\u0631\u062f \u062f\u06cc\u06af\u0631.<\/p>\n<p>\u0628\u0627\u0648\u0631 \u06a9\u0646\u06cc\u062f \u06cc\u0627 \u0646\u0647\u060c \u0627\u06a9\u062b\u0631 \u0634\u0631\u06a9\u062a \u0647\u0627 \u0647\u0646\u0648\u0632 \u0627\u0632 CSV \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 &#8220;db&#8221; \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u0646\u062f.  \u0633\u067e\u0633\u060c \u0648\u0642\u062a\u06cc \u062f\u0631 \u0645\u0648\u0631\u062f \u062f\u0627\u062f\u0647 \u0635\u062d\u0628\u062a \u0645\u06cc \u06a9\u0646\u06cc\u0645 \u0648 \u0634\u0645\u0627 \u06cc\u06a9 \u062a\u062d\u0644\u06cc\u0644\u06af\u0631 \u062f\u0627\u062f\u0647 \u067e\u0631\u0634\u0648\u0631 \u0647\u0633\u062a\u06cc\u062f\u060c \u0628\u0627\u06cc\u062f \u0622\u0646 \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 SQL (\u062f\u0631 \u0627\u0628\u0632\u0627\u0631\u0647\u0627\u06cc BI) \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u06a9\u0646\u06cc\u0645\u060c \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646\u060c \u0627\u06af\u0631 \u062f\u0631 \u0645\u062d\u06cc\u0637 AWS \u06a9\u0627\u0631 \u0645\u06cc \u06a9\u0646\u06cc\u062f\u060c \u0627\u06cc\u0646 \u0645\u0631\u0627\u062d\u0644 \u0631\u0627 \u062f\u0646\u0628\u0627\u0644 \u06a9\u0646\u06cc\u062f.<\/p>\n<hr\/>\n<p><img decoding=\"async\" src=\"https:\/\/nabfollower.com\/blog\/wp-content\/uploads\/2023\/02\/\u0686\u06af\u0648\u0646\u0647-\u0628\u0627-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0627\u0632-Athena-\u0641\u0627\u06cc\u0644-CSV-\u0630\u062e\u06cc\u0631\u0647-\u0634\u062f\u0647-\u062f\u0631.png\" alt=\"\u0644\u0648\u06af\u0648\u06cc AWS\" loading=\"lazy\" width=\"880\" height=\"527\" title=\"\"><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter-rtl ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u0641\u0647\u0631\u0633\u062a \u0645\u0637\u0627\u0644\u0628<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/nabfollower.com\/blog\/how-to-query-csv-file-stored-in-aws-s3-using-athena-17p9\/#1-_%DB%8C%DA%A9_%D9%81%D8%A7%DB%8C%D9%84_CSV_%D8%A2%D9%85%D8%A7%D8%AF%D9%87_%DA%A9%D9%86%DB%8C%D8%AF\" >1- \u06cc\u06a9 \u0641\u0627\u06cc\u0644 CSV \u0622\u0645\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/nabfollower.com\/blog\/how-to-query-csv-file-stored-in-aws-s3-using-athena-17p9\/#2-_%DB%8C%DA%A9_%D8%B3%D8%B7%D9%84_%D8%AF%D8%B1_%D8%A2%D9%85%D8%A7%D8%B2%D9%88%D9%86_S3_%D8%A7%DB%8C%D8%AC%D8%A7%D8%AF_%DA%A9%D9%86%DB%8C%D8%AF\" >2- \u06cc\u06a9 \u0633\u0637\u0644 \u062f\u0631 \u0622\u0645\u0627\u0632\u0648\u0646 S3 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/nabfollower.com\/blog\/how-to-query-csv-file-stored-in-aws-s3-using-athena-17p9\/#3-_%DB%8C%DA%A9_%D8%AC%D8%AF%D9%88%D9%84_%D8%AF%D8%B1_AWS_Athena_%D8%A7%DB%8C%D8%AC%D8%A7%D8%AF_%DA%A9%D9%86%DB%8C%D8%AF\" >3- \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u062f\u0631 AWS Athena \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"1-_%DB%8C%DA%A9_%D9%81%D8%A7%DB%8C%D9%84_CSV_%D8%A2%D9%85%D8%A7%D8%AF%D9%87_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  1- \u06cc\u06a9 \u0641\u0627\u06cc\u0644 CSV \u0622\u0645\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0627\u06af\u0631 \u0642\u0628\u0644\u0627\u064b \u0641\u0627\u06cc\u0644 CSV \u0631\u0627 \u062f\u0631 \u0645\u062d\u0644\u06cc \u062e\u0648\u062f \u062f\u0627\u0631\u06cc\u062f\u060c \u0627\u0632 \u0622\u0646 \u0631\u062f \u0634\u0648\u06cc\u062f.<\/p>\n<ol>\n<li>\u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u0645\u0627 \u0627\u0632 Python \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f\u060c \u067e\u0627\u06cc\u062a\u0648\u0646 \u0631\u0627 \u062f\u0631 \u0645\u062d\u0644\u06cc \u062e\u0648\u062f \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f<\/li>\n<li>\u0646\u0635\u0628 <strong>\u062c\u0639\u0644\u06cc<\/strong> \u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647 \u0628\u0631\u0627\u06cc \u062f\u0631\u06cc\u0627\u0641\u062a \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0633\u0627\u062e\u062a\u06af\u06cc<\/li>\n<li>CSV \u0631\u0627 \u0628\u0627 <code>'first_name', 'last_name', 'age'<\/code> \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0633\u0631\u0628\u0631\u06af<\/li>\n<li>\u062d\u0627\u0644\u0627 \u067e\u0648\u0634\u0647 \u0631\u0627 \u0628\u0627\u0632 \u06a9\u0646\u06cc\u062f \u0648 <code>dummy-data.csv<\/code> \u0628\u0627\u06cc\u062f \u062f\u0631 \u062f\u0627\u062e\u0644 \u0622\u0646 \u0627\u06cc\u062c\u0627\u062f \u0634\u0648\u062f\n<\/li>\n<\/ol>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight python\"><code><span class=\"kn\">import<\/span> <span class=\"nn\">csv<\/span>\n<span class=\"kn\">from<\/span> <span class=\"nn\">faker<\/span> <span class=\"kn\">import<\/span> <span class=\"n\">Faker<\/span>\n\n<span class=\"n\">fake<\/span> <span class=\"o\">=<\/span> <span class=\"n\">Faker<\/span><span class=\"p\">()<\/span>\n<span class=\"n\">number_of_records<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">8000<\/span>\n\n<span class=\"k\">with<\/span> <span class=\"nb\">open<\/span><span class=\"p\">(<\/span><span class=\"s\">'dummy-data.csv'<\/span><span class=\"p\">,<\/span> <span class=\"n\">mode<\/span><span class=\"o\">=<\/span><span class=\"s\">'w+'<\/span><span class=\"p\">)<\/span> <span class=\"k\">as<\/span> <span class=\"nb\">file<\/span><span class=\"p\">:<\/span>\n    <span class=\"n\">file_writer<\/span> <span class=\"o\">=<\/span> <span class=\"n\">csv<\/span><span class=\"p\">.<\/span><span class=\"n\">writer<\/span><span class=\"p\">(<\/span><span class=\"nb\">file<\/span><span class=\"p\">,<\/span> <span class=\"n\">delimiter<\/span><span class=\"o\">=<\/span><span class=\"s\">','<\/span><span class=\"p\">,<\/span> <span class=\"n\">quotechar<\/span><span class=\"o\">=<\/span><span class=\"s\">'\"'<\/span><span class=\"p\">,<\/span> <span class=\"n\">quoting<\/span><span class=\"o\">=<\/span><span class=\"n\">csv<\/span><span class=\"p\">.<\/span><span class=\"n\">QUOTE_MINIMAL<\/span><span class=\"p\">)<\/span>\n    <span class=\"n\">file_writer<\/span><span class=\"p\">.<\/span><span class=\"n\">writerow<\/span><span class=\"p\">([<\/span><span class=\"s\">'first_name'<\/span><span class=\"p\">,<\/span> <span class=\"s\">'last_name'<\/span><span class=\"p\">,<\/span> <span class=\"s\">'age'<\/span><span class=\"p\">])<\/span>\n\n    <span class=\"k\">for<\/span> <span class=\"n\">_<\/span> <span class=\"ow\">in<\/span> <span class=\"nb\">range<\/span><span class=\"p\">(<\/span><span class=\"n\">number_of_records<\/span><span class=\"p\">):<\/span>\n        <span class=\"n\">file_writer<\/span><span class=\"p\">.<\/span><span class=\"n\">writerow<\/span><span class=\"p\">([<\/span><span class=\"n\">fake<\/span><span class=\"p\">.<\/span><span class=\"n\">first_name<\/span><span class=\"p\">(),<\/span> <span class=\"n\">fake<\/span><span class=\"p\">.<\/span><span class=\"n\">last_name<\/span><span class=\"p\">(),<\/span> <span class=\"n\">fake<\/span><span class=\"p\">.<\/span><span class=\"n\">numerify<\/span><span class=\"p\">(<\/span><span class=\"s\">\"@#\"<\/span><span class=\"p\">)])<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"2-_%DB%8C%DA%A9_%D8%B3%D8%B7%D9%84_%D8%AF%D8%B1_%D8%A2%D9%85%D8%A7%D8%B2%D9%88%D9%86_S3_%D8%A7%DB%8C%D8%AC%D8%A7%D8%AF_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  2- \u06cc\u06a9 \u0633\u0637\u0644 \u062f\u0631 \u0622\u0645\u0627\u0632\u0648\u0646 S3 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0627\u06af\u0631 \u0642\u0628\u0644\u0627\u064b \u06cc\u06a9 \u0633\u0637\u0644 \u062f\u0627\u0631\u06cc\u062f \u0627\u0632 \u0622\u0646 \u0635\u0631\u0641\u0646\u0638\u0631 \u06a9\u0646\u06cc\u062f \u0648 \u0627\u0632 \u0633\u0637\u0644 \u0645\u0648\u062c\u0648\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f<\/p>\n<ol>\n<li>\u0628\u0647 AWS Console -> Search \u0628\u0631\u0648\u06cc\u062f <code>S3<\/code> -> \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f <code>Create Bucket<\/code> <img decoding=\"async\" src=\"https:\/\/nabfollower.com\/blog\/wp-content\/uploads\/2023\/02\/1676169994_335_\u0686\u06af\u0648\u0646\u0647-\u0628\u0627-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0627\u0632-Athena-\u0641\u0627\u06cc\u0644-CSV-\u0630\u062e\u06cc\u0631\u0647-\u0634\u062f\u0647-\u062f\u0631.png\" alt=\"\u0627\u06cc\u062c\u0627\u062f \u0633\u0637\u0644\" loading=\"lazy\" width=\"880\" height=\"245\" title=\"\">\n<\/li>\n<li>\u0641\u06cc\u0644\u062f\u0647\u0627\u06cc \u0644\u0627\u0632\u0645 \u0631\u0627 \u067e\u0631 \u06a9\u0646\u06cc\u062f -> \u0627\u06cc\u062c\u0627\u062f \u0633\u0637\u0644<br \/>\n<img decoding=\"async\" src=\"https:\/\/nabfollower.com\/blog\/wp-content\/uploads\/2023\/02\/1676169994_434_\u0686\u06af\u0648\u0646\u0647-\u0628\u0627-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0627\u0632-Athena-\u0641\u0627\u06cc\u0644-CSV-\u0630\u062e\u06cc\u0631\u0647-\u0634\u062f\u0647-\u062f\u0631.png\" alt=\"\u0641\u06cc\u0644\u062f\u0647\u0627 \u0631\u0627 \u067e\u0631 \u06a9\u0646\u06cc\u062f\" loading=\"lazy\" width=\"880\" height=\"509\" title=\"\">\n<\/li>\n<li>\u0633\u0637\u0644 \u062c\u062f\u06cc\u062f \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u0634\u0648\u062f.  \u0627\u06a9\u0646\u0648\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u062a\u0635\u0645\u06cc\u0645 \u0628\u06af\u06cc\u0631\u06cc\u062f \u06a9\u0647 \u0622\u06cc\u0627 \u06cc\u06a9 \u067e\u0648\u0634\u0647 \u062c\u062f\u06cc\u062f \u062f\u0631 \u062f\u0627\u062e\u0644 \u0633\u0637\u0644 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f \u06cc\u0627 \u062e\u06cc\u0631.  \u0628\u0631\u0627\u06cc \u0645\u0646\u060c \u0645\u0646 \u0645\u06cc \u062e\u0648\u0627\u0647\u0645 \u06cc\u06a9 \u067e\u0648\u0634\u0647 \u062c\u062f\u0627\u06af\u0627\u0646\u0647 \u0628\u0631\u0627\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0633\u0627\u062e\u062a\u06af\u06cc \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u0645.  \u0627\u0632 \u0627\u06cc\u0646 \u0631\u0648 \u0645\u0646 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0631\u062f\u0645 <code>dummy_data<\/code> \u067e\u0648\u0634\u0647<\/li>\n<li>\u06a9\u0644\u06cc\u06a9 <code>Create folder<\/code><br \/>\n<img decoding=\"async\" src=\"https:\/\/nabfollower.com\/blog\/wp-content\/uploads\/2023\/02\/1676169994_591_\u0686\u06af\u0648\u0646\u0647-\u0628\u0627-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0627\u0632-Athena-\u0641\u0627\u06cc\u0644-CSV-\u0630\u062e\u06cc\u0631\u0647-\u0634\u062f\u0647-\u062f\u0631.png\" alt=\"\u067e\u0631\u0648\u0646\u062f\u0647 \u0628\u0633\u0627\u0632\" loading=\"lazy\" width=\"880\" height=\"205\" title=\"\">\n<\/li>\n<li>\u0641\u06cc\u0644\u062f\u0647\u0627\u06cc \u0644\u0627\u0632\u0645 \u0631\u0627 \u067e\u0631 \u06a9\u0646\u06cc\u062f -> \u0627\u06cc\u062c\u0627\u062f \u067e\u0648\u0634\u0647<\/li>\n<li>\u067e\u0648\u0634\u0647 \u062c\u062f\u06cc\u062f \u062f\u0631 \u0633\u0637\u0644 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u0634\u0648\u062f<\/li>\n<li>\u0627\u06a9\u0646\u0648\u0646\u060c \u0641\u0627\u06cc\u0644 csv. \u0631\u0627 \u0628\u0627 \u06a9\u0634\u06cc\u062f\u0646 \u0628\u0647 \u0635\u0641\u062d\u0647 \u0622\u067e\u0644\u0648\u062f \u06a9\u0646\u06cc\u062f<br \/>\n<img decoding=\"async\" src=\"https:\/\/nabfollower.com\/blog\/wp-content\/uploads\/2023\/02\/1676169995_307_\u0686\u06af\u0648\u0646\u0647-\u0628\u0627-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0627\u0632-Athena-\u0641\u0627\u06cc\u0644-CSV-\u0630\u062e\u06cc\u0631\u0647-\u0634\u062f\u0647-\u062f\u0631.png\" alt=\"\u0622\u067e\u0644\u0648\u062f \u0641\u0627\u06cc\u0644\" loading=\"lazy\" width=\"880\" height=\"528\" title=\"\">\n<\/li>\n<li>\u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0631\u0627\u06cc \u0645\u0634\u0627\u0647\u062f\u0647 \u0641\u0627\u06cc\u0644 CSV \u0648\u0627\u0631\u062f \u0634\u062f\u0647\u060c \u0628\u0627\u0632\u062e\u0648\u0627\u0646\u06cc \u06a9\u0646\u06cc\u062f \u06cc\u0627 \u0628\u0647 \u067e\u0648\u0634\u0647 \u0633\u0637\u0644 \u0628\u0631\u06af\u0631\u062f\u06cc\u062f<br \/>\n<img decoding=\"async\" src=\"https:\/\/nabfollower.com\/blog\/wp-content\/uploads\/2023\/02\/1676169996_42_\u0686\u06af\u0648\u0646\u0647-\u0628\u0627-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0627\u0632-Athena-\u0641\u0627\u06cc\u0644-CSV-\u0630\u062e\u06cc\u0631\u0647-\u0634\u062f\u0647-\u062f\u0631.png\" alt=\"\u062a\u0648\u0636\u06cc\u062d\u0627\u062a \u062a\u0635\u0648\u06cc\u0631\" loading=\"lazy\" width=\"880\" height=\"638\" title=\"\">\n<\/li>\n<li>\u0644\u0637\u0641\u0627\u064b \u0641\u0631\u0627\u0645\u0648\u0634 \u0646\u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u062c\u062f\u0648\u0644 \u0622\u062a\u0646\u0627\u060c URI S3 \u067e\u0648\u0634\u0647 \u0631\u0627 \u06a9\u067e\u06cc \u06a9\u0646\u06cc\u062f<\/li>\n<\/ol>\n<h3><span class=\"ez-toc-section\" id=\"3-_%DB%8C%DA%A9_%D8%AC%D8%AF%D9%88%D9%84_%D8%AF%D8%B1_AWS_Athena_%D8%A7%DB%8C%D8%AC%D8%A7%D8%AF_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  3- \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u062f\u0631 AWS Athena \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol>\n<li>\u0627\u06cc\u062c\u0627\u062f \u062c\u062f\u0648\u0644 \u062f\u0631 \u0622\u062a\u0646\u0627.  \u0628\u0627\u06cc\u062f \u0633\u0627\u062e\u062a\u0627\u0631 \u062c\u062f\u0648\u0644 \u0631\u0627 \u062a\u0639\u0631\u06cc\u0641 \u06a9\u0646\u06cc\u062f \u062a\u0627 \u062c\u062f\u0648\u0644 \u0622\u062a\u0646\u0627 \u0628\u062a\u0648\u0627\u0646\u062f \u0633\u0627\u062e\u062a\u0627\u0631 \u062f\u0627\u062f\u0647 \u062f\u0631 \u0641\u0627\u06cc\u0644 CSV \u0631\u0627 \u0628\u0634\u0646\u0627\u0633\u062f.\n<ol>\n<li>\u06a9\u0646\u0633\u0648\u0644 \u0645\u062f\u06cc\u0631\u06cc\u062a AWS<\/li>\n<li>AWS CLI<\/li>\n<\/ol>\n<\/li>\n<li>\u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u067e\u0633\u062a\u060c \u0645\u0646 \u0627\u0632 \u06a9\u0646\u0633\u0648\u0644 \u0645\u062f\u06cc\u0631\u06cc\u062a AWS \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u0645.  \u0645\u0627\u0646\u0646\u062f \u0633\u0631\u0648\u06cc\u0633 S3\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u06a9\u0646\u0633\u0648\u0644 AWS \u062e\u0648\u062f \u0631\u0627 \u0628\u0627\u0632 \u06a9\u0631\u062f\u0647 \u0648 Athena \u0631\u0627 \u062c\u0633\u062a\u062c\u0648 \u06a9\u0646\u06cc\u062f.<\/li>\n<li>\u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0632\u06cc\u0631 \u062c\u062f\u0648\u0644 \u0631\u0627 \u067e\u0631 \u06a9\u0646\u06cc\u062f\n<\/li>\n<\/ol>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">CREATE<\/span> <span class=\"k\">EXTERNAL<\/span> <span class=\"k\">TABLE<\/span> <span class=\"n\">dummy_person<\/span> <span class=\"p\">(<\/span>\n  <span class=\"n\">first_name<\/span> <span class=\"n\">string<\/span><span class=\"p\">,<\/span>\n  <span class=\"n\">last_name<\/span> <span class=\"n\">string<\/span><span class=\"p\">,<\/span>\n  <span class=\"n\">age<\/span> <span class=\"n\">string<\/span>\n<span class=\"p\">)<\/span>\n<span class=\"k\">ROW<\/span> <span class=\"n\">FORMAT<\/span> <span class=\"n\">SERDE<\/span> <span class=\"s1\">'org.apache.hadoop.hive.serde2.OpenCSVSerde'<\/span>\n<span class=\"k\">WITH<\/span> <span class=\"n\">SERDEPROPERTIES<\/span> <span class=\"p\">(<\/span>\n  <span class=\"s1\">'separatorChar'<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">','<\/span><span class=\"p\">,<\/span>\n  <span class=\"s1\">'quoteChar'<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'\"'<\/span><span class=\"p\">,<\/span>\n  <span class=\"s1\">'escapeChar'<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'<\/span><span class=\"se\">\\\\<\/span><span class=\"s1\">'<\/span>\n<span class=\"p\">)<\/span>\n<span class=\"k\">LOCATION<\/span> <span class=\"s1\">'[S3 URI]'<\/span>\n<span class=\"n\">TBLPROPERTIES<\/span> <span class=\"p\">(<\/span><span class=\"nv\">\"skip.header.line.count\"<\/span><span class=\"o\">=<\/span><span class=\"nv\">\"1\"<\/span><span class=\"p\">);<\/span>\n\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u062c\u062f\u0648\u0644 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u0634\u0648\u062f.<br \/><img decoding=\"async\" src=\"https:\/\/nabfollower.com\/blog\/wp-content\/uploads\/2023\/02\/1676169996_461_\u0686\u06af\u0648\u0646\u0647-\u0628\u0627-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0627\u0632-Athena-\u0641\u0627\u06cc\u0644-CSV-\u0630\u062e\u06cc\u0631\u0647-\u0634\u062f\u0647-\u062f\u0631.png\" alt=\"\u062c\u062f\u0648\u0644\" loading=\"lazy\" width=\"712\" height=\"590\" title=\"\"><\/p>\n<p>\u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc SQL \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f \u062a\u0627 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627 \u067e\u0631 \u0634\u062f\u0647 \u0627\u0633\u062a<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">select<\/span> <span class=\"o\">*<\/span> <span class=\"k\">from<\/span> <span class=\"n\">dummy_person<\/span> \n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0644\u062d\u0638\u0647\u060c \u0634\u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0645\u0634\u0627\u0647\u062f\u0647 \u06a9\u0646\u06cc\u062f<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/nabfollower.com\/blog\/wp-content\/uploads\/2023\/02\/1676169997_100_\u0686\u06af\u0648\u0646\u0647-\u0628\u0627-\u0627\u0633\u062a\u0641\u0627\u062f\u0647-\u0627\u0632-Athena-\u0641\u0627\u06cc\u0644-CSV-\u0630\u062e\u06cc\u0631\u0647-\u0634\u062f\u0647-\u062f\u0631.png\" alt=\"\u062f\u0627\u062f\u0647 \u0647\u0627\" loading=\"lazy\" width=\"880\" height=\"514\" title=\"\"><\/p>\n<hr\/>\n<p>\u062f\u0631 \u0645\u0631\u062d\u0644\u0647 \u0628\u0639\u062f\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0622\u062a\u0646\u0627 \u0631\u0627 \u0628\u0647 \u0627\u0628\u0632\u0627\u0631\u0647\u0627\u06cc BI \u062e\u0648\u062f \u0645\u062a\u0635\u0644 \u06a9\u0646\u06cc\u062f \u0648 \u0634\u0631\u0648\u0639 \u0628\u0647 \u062a\u0648\u0633\u0639\u0647 \u062f\u0627\u0634\u0628\u0648\u0631\u062f \u06a9\u0646\u06cc\u062f<\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>CSV (\u0645\u0642\u0627\u062f\u06cc\u0631 \u062c\u062f\u0627 \u0634\u062f\u0647 \u0628\u0627 \u06a9\u0627\u0645\u0627) \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062f\u0631 \u0646\u0638\u0631 \u06af\u0631\u0641\u062a\u0647 \u0634\u0648\u062f \u0648 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u062f\u0631 \u0642\u0627\u0644\u0628 \u062c\u062f\u0648\u0644 \u0630\u062e\u06cc\u0631\u0647 \u0645\u06cc \u06a9\u0646\u062f. \u062a\u0627 \u0622\u0646\u062c\u0627 \u06a9\u0647 \u0645\u0646 \u0645\u06cc \u062f\u0627\u0646\u0645\u060c CSV \u062f\u0631 \u0647\u0645\u0647 \u062c\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a. \u0627\u0632 \u06af\u0632\u0627\u0631\u0634\u200c\u0647\u0627 \u06af\u0631\u0641\u062a\u0647 \u062a\u0627 \u06cc\u0627\u062f\u06af\u06cc\u0631\u06cc \u0645\u0627\u0634\u06cc\u0646 \u0628\u0631\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 \u0645\u062c\u0645\u0648\u0639\u0647 \u062f\u0627\u062f\u0647 \u0648 \u0645\u0648\u0627\u0631\u062f \u062f\u06cc\u06af\u0631. \u0628\u0627\u0648\u0631 \u06a9\u0646\u06cc\u062f &hellip;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-5374","post","type-post","status-publish","format-standard","hentry","category-dev"],"_links":{"self":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/5374","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/comments?post=5374"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/5374\/revisions"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=5374"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=5374"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=5374"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}