Unable to drop Athena View

Question

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

Accepted Answer

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](https://stackoverflow.com/questions/70545028/aws-athena-view-will-not-drop) 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

Unable to drop Athena View

Contenuto pertinente