More than 5 years have passed since last update.

Athena の Query で正規表現とかサブクエリとかやる方法

Presto
regex
Athena

Posted at 2018-03-14

SELECT count(*)
FROM 
    (SELECT regexp_extract_all(request_uri, '(.*hoge_id=.*?)(.*?)&', 2)
        FROM "DATABASE_NAME"."TABLE_NAME"
        WHERE year=2018
            AND month=3
            AND day=13
        GROUP BY  regexp_extract_all(request_uri, '(.*hoge_id=.*?)(.*?)&', 2)
    )

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up