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:

已提問 1 年前檢視次數 5619 次
1 個回答
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

已回答 1 年前
AWS
專家
已審閱 1 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南