Passer au contenu
En utilisant AWS re:Post, vous acceptez les AWS re:Post Conditions d’utilisation
AWS re:Postre:Post
À propos de re: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
    il y a 3 ans

    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!

Balises
S3 Select
Langue
English

demandé il y a 3 ans591 vues

1 réponse
1

Hi dmarcus,

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

EXPERT

répondu il y a 3 ans

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Contenus pertinents