1 個回答
- 最新
- 最多得票
- 最多評論
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.
相關內容
- AWS 官方已更新 3 年前
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.