1 回答
- 最新
- 投票最多
- 评论最多
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
已回答 4 年前
相关内容
- AWS 官方已更新 9 个月前