By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Use of S3 SELECT with "IN" clause?

0

Is there any restriction using an "IN" clause with S3 Select?

Too limit data in Lambda function, I was planning to stream IDs from Dataset 1 using S3Select, and then use this dataset as the set of IDs to filter for the stream of Dataset 2 (also from S3Select).

So the S3Select query for Dataset 2 would be something like "Select * FROM Dataset1 WHERE ID IN (Dataset2)".

Would that work?

  • Antonio_Lagrotteria EXPERT
    a year ago

    Hi, I d appreciate if below answer, if helped you, can be accept it so that resolution is clear for community when searching for similar questions, thanks!

Topics
Storage
Tags
S3 Select
Language
English
dmarcus
asked a year ago292 views
1 Answer
1

Hi dmarcus,

Something like this should work, very similar to traditional SQL: Select * FROM Dataset1 WHERE ID IN (Select ID FROM Dataset2)

profile picture
EXPERT
Antonio_Lagrotteria
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content