Saltar al contenido
Al usar AWS re:Post, aceptas las AWS re:Post Términos de uso
AWS re:Postre:Post
Acerca 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 EXPERTO
    hace 3 años

    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!

Etiquetas
S3 Select
Idioma
English

preguntada hace 3 años591 visualizaciones

1 Respuesta
1

Hi dmarcus,

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

EXPERTO

respondido hace 3 años

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Contenido relevante