Use of S3 SELECT with "IN" clause?


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?

  • 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!

asked a year ago326 views
1 Answer

Hi dmarcus,

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

profile picture
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