AWS announces preview of AWS Interconnect - multicloud

AWS announces AWS Interconnect – multicloud (preview), providing simple, resilient, high-speed private connections to other cloud service providers. AWS Interconnect - multicloud is easy to configure and provides high-speed, resilient connectivity with dedicated bandwidth, enabling customers to interconnect AWS networking services such as AWS Transit Gateway, AWS Cloud WAN, and Amazon VPC to other cloud service providers with ease.

Unable to drop Athena View

Hi, we have stumbled on the situation when we are not able to recreate or delete the Athena view. We have tried to re-recrate view (CREATE OR REPLACE VIEW "my_view" AS SELECT...) with different underlying query however getting this error: Row type must have at least one parameter When we are trying to drop the view(DROP view "my_view"), the same error appears. When running select from the view the following error appears: View 'awsdatacatalog.my_view' is stale; it must be re-created We have a bunch of quicksight datasets relying on the view and would be great to be able to re-create it. The data source underneath is S3

トピック: 分析
タグ: Amazon Athena
言語: English

Denys

質問済み 3年前501ビュー

1回答

新しい順
投票が多い順
コメントが多い順

承認された回答

Hi , without seeing the full View DDL it is hard to understand if there is a specific issue with the view. A workaorund that was previously suggested by on stackoverflow by someone I trust is to try deleting the view object from the Glue Data Catalog directly, via console or using the following command in the CLI:

$ aws glue delete-table \
  --region THE_REGION \
  --database-name THE_DATABASE \
  --name THE_NAME_OF_THE_VIEW

hope this helps

エキスパート

Fabrizio

回答済み 3年前

Unable to drop Athena View

回答を追加する

関連するコンテンツ