Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

line 1:8: mismatched input 'external'. expecting: 'or', 'schema', 'table', 'view'

0

I have the error of the title using this query: CREATE EXTERNAL TABLE (id BIGINT, idade BIGINT, sexo STRING, dependentes BIGINT, escolaridade STRING, tipocartao STRING, limitecredito DOUBLE, valortransacoes12m DOUBLE, qtdtransacoes12m BIGINT) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde' STORED AS TEXTFILE WITH SERDEPROPERTIES ('separatorChar' = ',','quoteChar' = '"','escapeChar' = '\') LOCATION 's3://klausbucketsql/'

How can I solve it:

Topics
Analytics
Tags
Amazon Athena
Language
English
asked 3 years ago8.4K views
1 Answer
2

You don't specify the table name, which goes before the first open parenthesis. Here's an example. https://docs.aws.amazon.com/emr/latest/ReleaseGuide/EMR_Hive_Commands.html

answered 3 years ago
AWS
EXPERT
reviewed 3 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content