1 Respuesta
- Más nuevo
- Más votos
- Más comentarios
0
Can you execute SHOW CREATE TABLE de-dup-db.input_data; to validate that the column is called name and that there are no additional characters or encodings?
This error is typically caused when the column does not exist. If you think it should exist, there may be a misspelling or extra character due to encoding.
Contenido relevante
OFICIAL DE AWSActualizada hace un año- OFICIAL DE AWSActualizada hace un año
- OFICIAL DE AWSActualizada hace un año
- OFICIAL DE AWSActualizada hace 2 años
I Executed the above script, got an error as : "Queries of this type are not supported"
Following are the columns: name, id, age, salary
Also these tables are created via AWS Glue, hence data source should be AwsDataCatalog.
In the Athena Query Editor, can you click the 3 dots next to the table and click "Generate Table DDL"?
Even that's not coming up Chris. Error thrown out. Gave all the relevant data lake permissions on databse, tables as well as on the columns. Am observing this for the first time.