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:

asked a year ago5333 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 a year ago
AWS
EXPERT
reviewed a year 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.

Guidelines for Answering Questions