2 Respuestas
- Más nuevo
- Más votos
- Más comentarios
0
I never found a root cause to the issue but it now seems to be working again (in Version 2 of the Athena engine only).
Version 3 of the Athena engine still encounters the same issues.
respondido hace 2 años
0
I solved this problem by granting the right permission to my account or IAM role on Data Lake permission at Lake Formation. This has nothing to do with Athena's Version. Just be careful which one you use when you log into AWS. your account or IAM role, you need to assign the permission to the right one. This one is related to COLUMN_NOT_FOUND: line 1:8: and SYNTAX_ERROR: line 1:8: SELECT * not allowed from relation that has no columns.
respondido hace un año
Contenido relevante
- OFICIAL DE AWSActualizada hace un año
- OFICIAL DE AWSActualizada hace un año
- OFICIAL DE AWSActualizada hace 3 años
- OFICIAL DE AWSActualizada hace 2 años
I'm having the same problem.
I am having the same issue. I cannot access to all the Iceberg tables via Athena but I can access through Spark/Presto.