【以下的问题经过翻译处理】 我正在尝试在DynamoDB文档中提供的示例电影表上执行查询。我尝试了以下几种变体,但结果都是相同的语法错误。
可以在以下网址上找到数据样本:
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/GettingStarted.Python.02.html
以下是Athena查询和输出。具体错误是:“无法解析列'lds。”info“。”release_date“'”
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
{
"QueryExecutionId": "f1c21259-43ea-4c69-8c42-55ff70998953"
}
bash$ aws athena get-query-execution --query-execution-id f1c21259-43ea-4c69-8c42-55ff70998953
{
"QueryExecution": {
"QueryExecutionId": "f1c21259-43ea-4c69-8c42-55ff70998953",
"Query": "select lds.\"info\".\"release_date\" from \"dynamodb\".\"default\".\"movies\" as lds where year = 1985",
"StatementType": "DML",
"ResultConfiguration": {
"OutputLocation": "s3://<BUCKET-NAME>/results/f1c21259-43ea-4c69-8c42-55ff70998953.csv"
},
"QueryExecutionContext": {},
"Status": {
"State": "FAILED",
"StateChangeReason": "SYNTAX_ERROR: line 1:8: Column 'lds.\"info\".\"release_date\"' cannot be resolved",
"SubmissionDateTime": 1589221630.629,
"CompletionDateTime": 1589221632.273
},
"Statistics": {
"EngineExecutionTimeInMillis": 998,
"DataScannedInBytes": 0,
"TotalExecutionTimeInMillis": 1644,
"QueryQueueTimeInMillis": 625,
"ServiceProcessingTimeInMillis": 21
},
"WorkGroup": "AmazonAthenaPreviewFunctionality"
}
}