- 最新
- 最多得票
- 最多評論
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
相關內容
- 已提問 1 年前
- AWS 官方已更新 3 年前