select-object-content ¥ --bucket=example-s3-select ¥ --key=sample.csv ¥ --input-serialization '{"CSV":{"FileHeaderInfo": "USE", "QuoteEscapeCharacter":"¥¥"}}' ¥ --output-serialization '{"CSV":{"QuoteFields":"ALWAYS","QuoteEscapeCharacter":"¥¥"}}' ¥ --expression "SELECT * FROM s3object s WHERE s.name LIKE '%佐々木%' AND s.gender = '男性 ' AND s.age < '19'" ¥ --expression-type SQ output.txt $ cat output.txt "177","佐々木 裕太","男性","16","kumiko27@ishida.biz “515”,“佐々木 拓真","男性","18","ttanaka@mail.goo.ne.jp "1133","佐々木 浩","男性","16","uno.miki@mail.goo.ne.jp "1869","佐々木 京助","男性","12","murayama.tomoya@gmail.com "2235","佐々木 裕美子","男性","17","tsubasa90@yahoo.co.jp "2572","佐々木 洋介","男性","10","mikako00@mail.goo.ne.jp "2854","佐々木 美加子","男性","10","kazuya52@murayama.jp "3176","佐々木 真綾","男性","12","satomi.ito@saito.com "3447","佐々木 裕美子","男性","15","ryosuke.yamagishi@mail.goo.ne.jp "3567","佐々木 太郎","男性","15","hkijima@mail.goo.ne.jp "4098","佐々木 花子","男性","16","suzuki.tomoya@hotmail.co.jp "4377","佐々木 真綾","男性","11","jun.suzuki@hirokawa.jp "4458","佐々木 裕美子","男性","13","ryosuke85@aoyama.jp … ファイル取得後にアプリ側で選別するのではなく 取得時に必要なデータのみを取得できる機能