- Mais recentes
- Mais votos
- Mais comentários
Hi,
The error message "SYNTAX_ERROR: line 1:8: SELECT * not allowed from relation that has no columns" can be caused by various reasons and the error message is a bit misleading. Please refer the document [1].
The error "COLUMN_NOT_FOUND: line 1:8: SELECT * not allowed ..." typically occurs when (1) the user/role does not have sufficient permissions on the table in Lake Formation. (2) the table's classification is UNKNOWN or the table has no column definitions.
Regrading this error: SYNTAX_ERROR: line 1:8: Column 'column_1' cannot be resolved. This error may also occur when the said column is missing from the Athena data source. If your Data source does have that column and the issue still persists, you can open a support case with AWS Athena team with query ID and region name.
How can I resolve the "SYNTAX_ERROR: line 1:8: SELECT * not allowed in queries without FROM clause" error in Amazon Athena? - [1] https://repost.aws/knowledge-center/athena-syntax-error-select-not-allowed
Conteúdo relevante
- AWS OFICIALAtualizada há um ano
- AWS OFICIALAtualizada há um ano
- AWS OFICIALAtualizada há 3 anos