Error While querying in Athena query editor.
Dears,
I have a file in S3, and while querying got the following error: Need your suggestion to get this fixed.
Qry : SELECT * FROM "de-dup-db"."input_data" limit 10;
Error : SYNTAX_ERROR: line 1:8: Column 'name' cannot be resolved This query ran against the "de-dup-db" database, unless qualified by the query. Please post the error message on our forum or contact customer support with Query Id: c7dde2fc-69be-4814-831f-71448486d4cb
Regards, Keshava
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.
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.
Relevant questions
Best way to overcome HIVE_PARTITION_SCHEMA_MISMATCH error in Athena while preserving structure of structs?
asked a month agoError While querying in Athena query editor.
asked 3 months agoHIVE_UNKNOWN_ERROR: Duplicate key string
asked 3 months agoHow to query .json.gz files from Amazon Athena?
Accepted Answerasked 3 years agoUnsupported case of DataType
asked a month agocrawled data can not be queried in athena
Accepted Answerasked 5 years agoHIVE_CANNOT_OPEN_SPLIT Error from Athena query
asked a month agoGENERIC_USER_ERROR for Athena + Dynamodb
asked 25 days agoI cannot use current_date + interval in Athena boto3 query in Lambda
Accepted Answerasked 3 months agoQuerying postgres RDS from Athena
asked a year ago
I Executed the above script, got an error as : "Queries of this type are not supported"
Following are the columns: name, id, age, salary