Ao usar o AWS re:Post, você concorda com os AWS re:Post Termos de uso
AWS re:Postre:Post

Error While querying in Athena query editor.

0

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

Tópicos
Análise
Tags
Amazon Athena
Idioma
English
AWS-User-4000301
feita há 2 anos3936 visualizações
1 Resposta
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.

profile pictureAWS
ESPECIALISTA
Chris_G
respondido há 2 anos
  • AWS-User-4000301
    há 2 anos

    I Executed the above script, got an error as : "Queries of this type are not supported"

    Following are the columns: name, id, age, salary

  • AWS-User-4000301
    há 2 anos

    Also these tables are created via AWS Glue, hence data source should be AwsDataCatalog.

  • Chris_G ESPECIALISTA
    há 2 anos

    In the Athena Query Editor, can you click the 3 dots next to the table and click "Generate Table DDL"?

  • AWS-User-4000301
    há 2 anos

    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.

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Diretrizes para responder a perguntas

Conteúdo relevante