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
Contenido relevante
preguntada hace un año
preguntada hace un año
preguntada hace 10 meses
