1 Antwort
- Neueste
- Die meisten Stimmen
- Die meisten Kommentare
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.
Relevanter Inhalt
- AWS OFFICIALAktualisiert vor 2 Jahren
- AWS OFFICIALAktualisiert vor einem Jahr
- AWS OFFICIALAktualisiert vor 2 Jahren
- AWS OFFICIALAktualisiert vor 3 Jahren
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.