社区开发版insert into hive的问题
2023-08-25 10:59:52 2023-08-25 15:18:15 109
0: jdbc:hive2://10.10.26.190:10000/mjs_argodb> CREATE TABLE argo_1(
. . . . . . . . . . . . . . . . . . . . . . .> id INT NOT NULL DEFAULT 0 PRIMARY KEY,
. . . . . . . . . . . . . . . . . . . . . . .> os_type TINYINT NOT NULL DEFAULT 0
. . . . . . . . . . . . . . . . . . . . . . .> ) CLUSTERED BY (os_type) INTO 2 BUCKETS STORED AS ORC TBLPROPERTIES ("transactional"="true");
No rows affected (0.314 seconds)
0: jdbc:hive2://10.10.26.190:10000/mjs_argodb> insert into argo_1 values (1,1);
Error: EXECUTION FAILED: Task MAPRED-SPARK error RuntimeException: [Error 1] java.lang.RuntimeException: Exception found during closeOp. See more detail on executor log. (state=08S01,code=1)
2023-08-25 02:50:02,337 WARN action.SqlCalciteUtils: [InceptorServer2-Handler-Pool: Thread-219(SessionHandle=ea3e47b9-74b9-4fc3-8aa0-91a82f26c4e1)] - [CalciteOptimizer] The given query is not supported within Calcite framework. Because: Not invoking Calcite Optimizer because the statement doesn't have QUERY or EXPLAIN as root and not a CTAS; . Calcite Optimization will be skipped.
我不明白为什么已经设置了orc还是不能insert into
. . . . . . . . . . . . . . . . . . . . . . .> id INT NOT NULL DEFAULT 0 PRIMARY KEY,
. . . . . . . . . . . . . . . . . . . . . . .> os_type TINYINT NOT NULL DEFAULT 0
. . . . . . . . . . . . . . . . . . . . . . .> ) CLUSTERED BY (os_type) INTO 2 BUCKETS STORED AS ORC TBLPROPERTIES ("transactional"="true");
No rows affected (0.314 seconds)
0: jdbc:hive2://10.10.26.190:10000/mjs_argodb> insert into argo_1 values (1,1);
Error: EXECUTION FAILED: Task MAPRED-SPARK error RuntimeException: [Error 1] java.lang.RuntimeException: Exception found during closeOp. See more detail on executor log. (state=08S01,code=1)
2023-08-25 02:50:02,337 WARN action.SqlCalciteUtils: [InceptorServer2-Handler-Pool: Thread-219(SessionHandle=ea3e47b9-74b9-4fc3-8aa0-91a82f26c4e1)] - [CalciteOptimizer] The given query is not supported within Calcite framework. Because: Not invoking Calcite Optimizer because the statement doesn't have QUERY or EXPLAIN as root and not a CTAS; . Calcite Optimization will be skipped.
我不明白为什么已经设置了orc还是不能insert into
回答
登录后可回答问题
.jpg)
