teledb=# set max_parallel_workers_per_gather to 0; SET Time: 0.214 ms teledb=# select count(1) from t_count; count ---------- 20000000 (1 row) Time: 2700.569 ms (00:02.701) teledb=# set max_parallel_workers_per_gather to 2; SET Time: 0.269 ms teledb=#
:2664) at org.apache.hadoop.conf.Configuration.getClass(Configuration.java:2688) ... 31 common frames omitted Caused by: java.lang.ClassNotFoundException: Class org.apache.hadoop.fs.obs.metrics.OBSAMetricsProvider not found at org.apache.hadoop.conf.Configuration.getClassByName
ALTER TABLE customer_address SPLIT PARTITION P8 AT (60000) INTO ( PARTITION P81, PARTITION P82 ); 2.使用drop命令删除分区p82(此时p82分区没有数据)。 ALTER TABLE customer_address drop partition p82; 3.使用split命令将p81分割成为p8和p9, [40000,50000)的分区p8就创建成功了。