0: jdbc:hive2://master:10000/> truncate student; 表失败了

南方Go 发布于 2019/09/27 15:28
阅读 683
收藏 0

【开源中国 APP 全新上线】“动弹” 回归、集成大模型对话、畅读技术报告”

 

 

0: jdbc:hive2://master:10000/> truncate student;
Error: Error while compiling statement: FAILED: ParseException line 1:9 missing TABLE at 'student' near '<EOF>' (state=42000,code=40000)

.

但是select不报错,这是为啥呢

 

 

 

 

 

 

0: jdbc:hive2://master:10000/> select  *  from student limit 1;
INFO  : Compiling command(queryId=hive_20190927152605_62e5072f-c4ba-4eb9-bfd8-f821238f53c4): select  *  from student limit 1
INFO  : Semantic Analysis Completed
INFO  : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:student.id, type:string, comment:null), FieldSchema(name:student.name, type:string, comment:null)], properties:null)
INFO  : Completed compiling command(queryId=hive_20190927152605_62e5072f-c4ba-4eb9-bfd8-f821238f53c4); Time taken: 0.107 seconds
INFO  : Executing command(queryId=hive_20190927152605_62e5072f-c4ba-4eb9-bfd8-f821238f53c4): select  *  from student limit 1
INFO  : Completed executing command(queryId=hive_20190927152605_62e5072f-c4ba-4eb9-bfd8-f821238f53c4); Time taken: 0.0 seconds
INFO  : OK
+----------------------------------------------------+---------------+
|                     student.id                     | student.name  |
+----------------------------------------------------+---------------+
| ORC$�bb����E'���M�=/A�g�v��sw�q�"�#�N3{�s��F|_�' ��� | NULL          |
+----------------------------------------------------+---------------+
1 row selected (0.223 seconds)

 

加载中
0
南方Go
南方Go

truncate table student;
 

0
J
Janvn

错误已经提示了,缺少TABLE关键字。语法错误了,正确语句:truncate table student;

OSCHINA
登录后可查看更多优质内容
返回顶部
顶部