CREATE TABLE article ( > id INT, > title STRING, > type STRING, > data_time INT, > source STRING, > content STRING, > PRIMARY KEY (id) > ) > ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' > TBLPROPERTIES ("constraint"="NOT_ENFORCED"); FAILED: SemanticException [Error 10326]: Invalid Constraint syntax ENABLE/ENFORCED feature not supported yet. Please use DISABLE/NOT ENFORCED instead.
时间: 2023-12-03 07:44:23 浏览: 36
这是一个创建表的 SQL 语句,但是在其中使用了一个无效的约束语法。在该语句中,TBLPROPERTIES 中使用了 "constraint"="NOT_ENFORCED",但是 Hive 不支持 ENABLE/ENFORCED 这种语法,需要使用 DISABLE/NOT ENFORCED。因此,你需要修改该语句如下:
```
CREATE TABLE article (
id INT,
title STRING,
type STRING,
data_time INT,
source STRING,
content STRING,
PRIMARY KEY (id)
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
TBLPROPERTIES ("constraint"="NOT ENFORCED");
```
修改后的语句中,使用了 "constraint"="NOT ENFORCED",这是有效的约束语法。
相关问题
create table article( > id int, > title string, > type string, > data_time int, > source string, > content string, > primary key (id) > ); FAILED: SemanticException [Error 10326]: Invalid Constraint syntax ENABLE/ENFORCED feature not supported yet. Please use DISABLE/NOT ENFORCED instead.
这个错误提示是因为在创建表时,使用了不支持的约束语法。根据错误提示,你需要将约束中的 "ENABLE/ENFORCED" 改为 "DISABLE/NOT ENFORCED",如下所示:
```
create table article(
id int,
title string,
type string,
data_time int,
source string,
content string,
primary key (id) DISABLED
);
```
这样就可以成功创建表了。注意,这里我们将主键约束禁用了,如果需要启用主键约束,只需将 "DISABLED" 改为 "ENABLED" 即可。
CREATE TABLE article ( > id INT, > title STRING, > type STRING, > data_time INT, > source STRING, > content STRING, > PRIMARY KEY (id) > ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ','; FAILED: SemanticException [Error 10326]: Invalid Constraint syntax ENABLE/ENFORCED feature not supported yet. Please use DISABLE/NOT ENFORCED instead.
这个错误是因为你在创建表时使用了 `ENABLE/ENFORCED` 语法,但是当前版本的Hive中不支持该语法。你需要使用 `DISABLE/NOT ENFORCED` 代替。例如:
```
CREATE TABLE article (
id INT,
title STRING,
type STRING,
data_time INT,
source STRING,
content STRING,
PRIMARY KEY (id)
) ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
TBLPROPERTIES ("CONSTRAINT"="PRIMARY KEY (id) DISABLE NOVALIDATE");
```
相关推荐
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)