这是查询资源的波动
这是分析简图耗时1s.txt (70.3 KB) 耗时4s.txt (70.9 KB)
背景：使用3.13版本的时候做并发测试，发现多并发情况下比单并发耗时大了几倍。
CREATE TABLE
dws_defect_info (PARTITION int(11) NOT NULL COMMENT “”,lot_id varchar(65533) NOT NULL COMMENT “”,wid varchar(65533) NOT NULL COMMENT “”,did varchar(65533) NOT NULL COMMENT “”,wafer_id varchar(65533) NULL COMMENT “”,step_id varchar(65533) NULL COMMENT “”,klf_file_timestamp datetime NULL COMMENT “”,defect_id int(11) NULL COMMENT “”,absolute_x decimal64(16, 3) NULL COMMENT “”,absolute_y decimal64(16, 3) NULL COMMENT “”,radius decimal64(16, 3) NULL COMMENT “”,xrel decimal64(16, 3) NULL COMMENT “”,yrel decimal64(16, 3) NULL COMMENT “”,xindex int(11) NULL COMMENT “”,yindex int(11) NULL COMMENT “”,xsize decimal64(16, 3) NULL COMMENT “”,ysize decimal64(16, 3) NULL COMMENT “”,defect_area decimal64(16, 3) NULL COMMENT “”,dsize decimal64(16, 3) NULL COMMENT “”,test int(11) NULL COMMENT “”,rough_bin int(11) NULL COMMENT “”,manual_bin int(11) NULL COMMENT “”,adc_bin int(11) NULL COMMENT “”,manual_sem_bin int(11) NULL COMMENT “”,auto_sem_bin int(11) NULL COMMENT “”,ssa_micro_bin int(11) NULL COMMENT “”,ssa_macro_bin int(11) NULL COMMENT “”,best_bin int(11) NULL COMMENT “”,last_bin int(11) NULL COMMENT “”,fine_bin int(11) NULL COMMENT “”,distance_to_center decimal64(16, 3) NULL COMMENT “”,angle decimal64(16, 3) NULL COMMENT “”,image_count int(11) NULL COMMENT “”,image_paths varchar(65533) NULL COMMENT “”,tiff_file_names varchar(65533) NULL COMMENT “”,cluster_id int(11) NULL COMMENT “”,defect_cluster_id int(11) NULL COMMENT “”,repeater_id_tolerance1 int(11) NULL COMMENT “”,repeater_id_tolerance2 int(11) NULL COMMENT “”,repeater_id_tolerance3 int(11) NULL COMMENT “”,repeater_id_tolerance4 int(11) NULL COMMENT “”,repeater_id_tolerance5 int(11) NULL COMMENT “”,inspection_tool varchar(65533) NULL COMMENT “”,pre_relation_tolerance1 int(11) NULL COMMENT “”,pre_relation_tolerance2 int(11) NULL COMMENT “”,pre_relation_tolerance3 int(11) NULL COMMENT “”,pre_relation_tolerance4 int(11) NULL COMMENT “”,pre_relation_tolerance5 int(11) NULL COMMENT “”,missing_defect_tolerance1 int(11) NULL COMMENT “”,missing_defect_tolerance2 int(11) NULL COMMENT “”,missing_defect_tolerance3 int(11) NULL COMMENT “”,missing_defect_tolerance4 int(11) NULL COMMENT “”,missing_defect_tolerance5 int(11) NULL COMMENT “”,zone_index int(11) NULL COMMENT “”,subdie_index varchar(65533) NULL COMMENT “”,reticle_position_x decimal64(16, 3) NULL COMMENT “”,reticle_position_y decimal64(16, 3) NULL COMMENT “”,position_x int(11) NULL COMMENT “”,position_y int(11) NULL COMMENT “”,thumbnail_names varchar(65533) NULL COMMENT “”,huge_defect int(11) NULL COMMENT “”,remark varchar(65533) NULL COMMENT “”,wafer_grid_number int(11) NULL COMMENT “”,die_grid_number int(11) NULL COMMENT “”,reticle_grid_number int(11) NULL COMMENT “”,reclass_detail varchar(65533) NULL COMMENT “reclass详情”,create_time datetime NULL COMMENT “”,update_time datetime NULL COMMENT “”) ENGINE=OLAP
PRIMARY KEY(
PARTITION, lot_id, wid, did)PARTITION BY (
PARTITION)DISTRIBUTED BY HASH(
lot_id)ORDER BY(
PARTITION, lot_id, wid, did)PROPERTIES (
“replication_num” = “3”,
“in_memory” = “false”,
“enable_persistent_index” = “true”,
“replicated_storage” = “true”,
“compression” = “LZ4”
);
这是建表语句
