1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
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.
Contenus pertinents
- demandé il y a 7 mois
- demandé il y a un an
- demandé il y a 3 mois
- AWS OFFICIELA mis à jour il y a un an
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.