1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
1
I was able to get a crawler to crawl the data and write a quick query in Athena to be able to accomplish your use case effectively. Please take a look and try it out. If you have any questions, please let me know.
Step 1: I mocked up data for 10 different dates and moved the data in S3 Step 2: I created a crawler to crawl the S3 location and ran the crawler. It created a table with 2 columns referer and data. Step 3: I ran the athena query below to get the dates > 9/4/2022
SELECT referer, data.datum2, data.ts, data.datum1, date_format(from_unixtime(data.ts),'%Y-%m-%d') FROM "raw_db"."nested_json"
where date_format(from_unixtime(data.ts),'%Y-%m-%d') > '2022-09-04'
limit 10;
répondu il y a 2 ans
Contenus pertinents
- demandé il y a 6 mois
- demandé il y a 8 mois
- AWS OFFICIELA mis à jour il y a un an
- AWS OFFICIELA mis à jour il y a 3 ans