- Le plus récent
- Le plus de votes
- La plupart des commentaires
The issue is that CTAS queries do not work with table names using special characters. So any table name using -
produces this error.
For information about the CTAS query syntax, please see Considerations and Limitations for CTAS Queries https://docs.aws.amazon.com/athena/latest/ug/considerations-ctas.html. It is stated there, quoting:
"Table, database, or column names for CTAS queries should not contain quotes or backticks. To ensure this, check that your table, database, or column names do not represent reserved words: https://docs.aws.amazon.com/athena/latest/ug/reserved-words.html, and do not contain special characters (which require enclosing them in quotes or backticks). For more information, see Names for Tables, Databases, and Columns, in https://docs.aws.amazon.com/athena/latest/ug/tables-databases-columns-names.html."
Edited by: JM-AWS on Mar 25, 2019 1:38 PM
Edited by: JM-AWS on Mar 25, 2019 1:42 PM
Edited by: JM-AWS on Mar 25, 2019 1:43 PM
Contenus pertinents
- demandé il y a 6 mois
- demandé il y a 9 mois
- demandé il y a 2 mois
- Comment définir le nombre ou la taille des fichiers lorsque j'exécute une requête CTAS dans Athena ?AWS OFFICIELA mis à jour il y a 3 ans
- AWS OFFICIELA mis à jour il y a 3 ans