1 Respuesta
- Más nuevo
- Más votos
- Más comentarios
0
You are just missing the double quotes around table alias :
bash$ aws athena start-query-execution --query-string "select \"lds\".\"info\".\"release_date\" from \"dynamodb\".\"default\".\"movies\" as \"lds\" where year = 1985" --region us-east-1 --work-group AmazonAthenaPreviewFunctionality
You should also check your table schema. You can do so by executing this query in Athena :
DESCRIBE dynamodb.default.movies
If your column is missing from that schema, then you should :
- Verify your Glue catalog : you might have created a table named "movies" that have an incorrect schema
- Either remove that table from Glue catalog, or make sure it gets created with the right schema.
Just for info, your query works for me. I don't have the table defined in Glue Catalog, so the schema is inferred by the connector
Hope this will help
respondido hace 4 años
Contenido relevante
- OFICIAL DE AWSActualizada hace 2 años
- OFICIAL DE AWSActualizada hace 3 años