1 Respuesta
- Más nuevo
- Más votos
- Más comentarios
0
Greetings from AWS. If I understood correctly your requirement is to fetch JSON objects in batches using S3 select query. For example : in a JSON file with 50 records present in it. with S3 select query you want to retrieve first 10 records completely and then next 10 and so on.
Have you tried using LIMIT, for example the following query would return 10 records with all fields.
SELECT * from S3Object[*] LIMIT 10
Please refer to the examples here to query specific fields based on conditions: https://docs.aws.amazon.com/AmazonS3/latest/userguide/s3-glacier-select-sql-reference-select.html
Please reply with example input and expected output if there are any questions. Thanks for contacting AWS, stay safe and have a wonderful day.
respondido hace un año
Contenido relevante
- OFICIAL DE AWSActualizada hace un año
- OFICIAL DE AWSActualizada hace un año
- OFICIAL DE AWSActualizada hace 3 años
- OFICIAL DE AWSActualizada hace 2 años