1개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
0
"SYNTAX_ERROR: line 1:19: Table awsdatacatalog.default.lambda-dynamodb-stream does not exist"
You are referencing the Glue Catalog in your query, that will not work for your DynamoDB table. You have to create a new data source; refer to part 2 of this doc : https://docs.aws.amazon.com/athena/latest/ug/connect-to-a-data-source-lambda.html
On Athena console You have to create a new data source to query your DynamoDB :
- Choose DynamoDB, and pick your Lambda function.
- Choose a catalog name: ("ddb" for example) => it's this name that you need to specify when querying your DynamoDB tables. In this case :
select value from ddb.default.lambda-dynamodb-stream
Please note that if you don't have a table defined in the Glue catalog that matches your DynamoDB table name, then the schema will be inferred by the DynamoDB Connector, as described here (https://github.com/awslabs/aws-athena-query-federation/blob/master/athena-dynamodb/README.md#setting-up-databases--tables-in-glue)
답변함 4년 전
관련 콘텐츠
- AWS 공식업데이트됨 2년 전