{ "table_id": 65006927, "partition_id": 69396946, "tablet_id": 69396992, "schema_hash": 381861089, "shard_id": 164, "creation_time": 1774505238, "cumulative_layer_point": -1, "tablet_state": "PB_RUNNING", "schema": { "keys_type": "UNIQUE_KEYS", "column": [ { "unique_id": 0, "name": "id", "type": "BIGINT", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 1, "name": "province_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "factory_full_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 3, "name": "product_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 4, "name": "product_model", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "name": "zone_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 6, "name": "factory_code", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 7, "name": "factory_short_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 8, "name": "machine_category_id", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 9, "name": "machine_category_code", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 10, "name": "machine_category_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 130, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 11, "name": "machine_category_id_path", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 12, "name": "machine_category_name_path", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 13, "name": "machine_wnong_category_code", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 14, "name": "machine_wnong_category_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 15, "name": "product_sale_money", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 16, "name": "product_photo_files", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1002, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 17, "name": "product_core_param_type", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 18, "name": "product_core_param_val", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 19, "name": "product_nameplate_files", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1002, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 20, "name": "cert_org_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 21, "name": "cert_start_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 22, "name": "cert_end_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 23, "name": "source_origin_id", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 24, "name": "clean_task_id", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 25, "name": "etl_batch_no", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 26, "name": "is_deleted", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true, "result_is_nullable": false }, { "unique_id": 27, "name": "create_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 28, "name": "update_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 29, "name": "__DORIS_DELETE_SIGN__", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true, "result_is_nullable": false }, { "unique_id": 30, "name": "__DORIS_VERSION_COL__", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false } ], "num_short_key_columns": 2, "num_rows_per_row_block": 1024, "compress_kind": "COMPRESS_LZ4", "next_column_unique_id": 31, "is_in_memory": false, "delete_sign_idx": 29, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 5, "compression_type": "LZ4F", "schema_version": 0, "disable_auto_compaction": false, "version_col_idx": -1, "store_row_column": false, "enable_single_replica_compaction": false, "skip_write_index_on_load": false, "inverted_index_storage_format": "V1" }, "rs_metas": [ { "rowset_id": 0, "partition_id": 69396946, "tablet_id": 69396992, "tablet_schema_hash": 381861089, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 0, "end_version": 8570, "num_rows": 77975, "total_disk_size": 7788383, "data_disk_size": 7788383, "index_disk_size": 282985857458641959, "empty": false, "creation_time": 1777650383, "tablet_uid": { "hi": -4446207284654699731, "lo": 4599060047577645477 }, "num_segments": 1, "rowset_id_v2": "0200000000d2162c3e4f039611b6885945b9c09748d2b3ba", "newest_write_timestamp": 1777410885, "segments_key_bounds": [ { "min_key": "\u0002\u001A\u001B`\u0015\u0002北京市\u0002山东美迪奔野拖拉机有限公司\u0002轮式拖拉机\u0002现:704-2E(G4)(原:704-2E)", "max_key": "\u0002E:̋`\u0010\u0002广西壮族自治区\u0002广州星科途信息技术有限公司\u0002北斗农业机械自动导航驾驶系统\u0002AP10BDS-2.5GD" } ], "tablet_schema": { "keys_type": "UNIQUE_KEYS", "column": [ { "unique_id": 0, "name": "id", "type": "BIGINT", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 1, "name": "province_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "factory_full_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 3, "name": "product_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 4, "name": "product_model", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "name": "zone_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 6, "name": "factory_code", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 7, "name": "factory_short_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 8, "name": "machine_category_id", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 9, "name": "machine_category_code", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 10, "name": "machine_category_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 130, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 11, "name": "machine_category_id_path", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 12, "name": "machine_category_name_path", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 13, "name": "machine_wnong_category_code", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 14, "name": "machine_wnong_category_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 15, "name": "product_sale_money", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 16, "name": "product_photo_files", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1002, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 17, "name": "product_core_param_type", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 18, "name": "product_core_param_val", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 19, "name": "product_nameplate_files", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1002, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 20, "name": "cert_org_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 21, "name": "cert_start_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 22, "name": "cert_end_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 23, "name": "source_origin_id", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 24, "name": "clean_task_id", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 25, "name": "etl_batch_no", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 26, "name": "is_deleted", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true, "result_is_nullable": false }, { "unique_id": 27, "name": "create_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 28, "name": "update_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 29, "name": "__DORIS_DELETE_SIGN__", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true, "result_is_nullable": false }, { "unique_id": 30, "name": "__DORIS_VERSION_COL__", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false } ], "num_short_key_columns": 2, "num_rows_per_row_block": 1024, "compress_kind": "COMPRESS_LZ4", "next_column_unique_id": 31, "is_in_memory": false, "delete_sign_idx": 29, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 5, "compression_type": "LZ4F", "schema_version": 0, "disable_auto_compaction": false, "version_col_idx": -1, "store_row_column": false, "enable_single_replica_compaction": false, "skip_write_index_on_load": false, "inverted_index_storage_format": "V1" }, "segments_overlap_pb": "NONOVERLAPPING" }, { "rowset_id": 0, "partition_id": 69396946, "tablet_id": 69396992, "tablet_schema_hash": 381861089, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 8571, "end_version": 8575, "num_rows": 178, "total_disk_size": 33917, "data_disk_size": 33917, "index_disk_size": 3260425700591851085, "empty": false, "creation_time": 1778012743, "tablet_uid": { "hi": -4446207284654699731, "lo": 4599060047577645477 }, "num_segments": 1, "rowset_id_v2": "0200000000d7b29b3e4f039611b6885945b9c09748d2b3ba", "newest_write_timestamp": 1778012735, "segments_key_bounds": [ { "min_key": "\u0002N+`\u0000\u0002湖南省\u0002云南郑通机械设备制造有限公司\u0002旋耕机\u00021GKN-170", "max_key": "\u0002NMC`\u0000\u0002湖北省\u0002湖北佳粮机械股份有限公司\u0002组合碾米机\u00026LN-20/16QSp" } ], "tablet_schema": { "keys_type": "UNIQUE_KEYS", "column": [ { "unique_id": 0, "name": "id", "type": "BIGINT", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 1, "name": "province_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "factory_full_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 3, "name": "product_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 4, "name": "product_model", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "name": "zone_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 6, "name": "factory_code", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 7, "name": "factory_short_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 8, "name": "machine_category_id", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 9, "name": "machine_category_code", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 10, "name": "machine_category_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 130, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 11, "name": "machine_category_id_path", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 12, "name": "machine_category_name_path", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 13, "name": "machine_wnong_category_code", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 14, "name": "machine_wnong_category_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 15, "name": "product_sale_money", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 16, "name": "product_photo_files", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1002, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 17, "name": "product_core_param_type", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 18, "name": "product_core_param_val", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 19, "name": "product_nameplate_files", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1002, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 20, "name": "cert_org_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 21, "name": "cert_start_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 22, "name": "cert_end_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 23, "name": "source_origin_id", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 24, "name": "clean_task_id", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 25, "name": "etl_batch_no", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 26, "name": "is_deleted", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true, "result_is_nullable": false }, { "unique_id": 27, "name": "create_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 28, "name": "update_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 29, "name": "__DORIS_DELETE_SIGN__", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true, "result_is_nullable": false }, { "unique_id": 30, "name": "__DORIS_VERSION_COL__", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false } ], "num_short_key_columns": 2, "num_rows_per_row_block": 1024, "compress_kind": "COMPRESS_LZ4", "next_column_unique_id": 31, "is_in_memory": false, "delete_sign_idx": 29, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 5, "compression_type": "LZ4F", "schema_version": 0, "disable_auto_compaction": false, "version_col_idx": 30, "store_row_column": false, "enable_single_replica_compaction": false, "skip_write_index_on_load": false, "inverted_index_storage_format": "V1" }, "segments_overlap_pb": "NONOVERLAPPING" }, { "rowset_id": 0, "partition_id": 69396946, "tablet_id": 69396992, "txn_id": 16372165, "tablet_schema_hash": 381861089, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 8576, "end_version": 8576, "num_rows": 68, "total_disk_size": 28720, "data_disk_size": 28720, "index_disk_size": 5631, "empty": false, "load_id": { "hi": 3716636834519927738, "lo": -7453245848111212324 }, "creation_time": 1778013311, "tablet_uid": { "hi": -4446207284654699731, "lo": 4599060047577645477 }, "num_segments": 1, "rowset_id_v2": "0200000000d7b63d3e4f039611b6885945b9c09748d2b3ba", "newest_write_timestamp": 1778013311, "segments_key_bounds": [ { "min_key": "\u0002NON`\u0000\u0002新疆维吾尔自治区\u0002常州东风农机集团有限公司\u0002轮式拖拉机\u0002DF904-3H", "max_key": "\u0002NOC`\u0000\u0002新疆维吾尔自治区\u0002斯维垦智能科技(深圳)有限公司\u0002斯农F100C单北斗自动驾驶系统\u0002SF210BDS-2.5GD" } ], "tablet_schema": { "keys_type": "UNIQUE_KEYS", "column": [ { "unique_id": 0, "name": "id", "type": "BIGINT", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 1, "name": "province_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "factory_full_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 3, "name": "product_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 4, "name": "product_model", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "name": "zone_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 6, "name": "factory_code", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 7, "name": "factory_short_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 8, "name": "machine_category_id", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 9, "name": "machine_category_code", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 10, "name": "machine_category_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 130, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 11, "name": "machine_category_id_path", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 12, "name": "machine_category_name_path", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 13, "name": "machine_wnong_category_code", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 14, "name": "machine_wnong_category_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 15, "name": "product_sale_money", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 16, "name": "product_photo_files", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1002, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 17, "name": "product_core_param_type", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 18, "name": "product_core_param_val", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 19, "name": "product_nameplate_files", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1002, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 20, "name": "cert_org_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 21, "name": "cert_start_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 22, "name": "cert_end_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 23, "name": "source_origin_id", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 24, "name": "clean_task_id", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 25, "name": "etl_batch_no", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 26, "name": "is_deleted", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true, "result_is_nullable": false }, { "unique_id": 27, "name": "create_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 28, "name": "update_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 29, "name": "__DORIS_DELETE_SIGN__", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true, "result_is_nullable": false }, { "unique_id": 30, "name": "__DORIS_VERSION_COL__", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false } ], "num_short_key_columns": 2, "num_rows_per_row_block": 1024, "compress_kind": "COMPRESS_LZ4", "next_column_unique_id": 31, "is_in_memory": false, "delete_sign_idx": 29, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 5, "compression_type": "LZ4F", "schema_version": 0, "disable_auto_compaction": false, "version_col_idx": 30, "store_row_column": false, "enable_single_replica_compaction": false, "skip_write_index_on_load": false, "inverted_index_storage_format": "V1" }, "segments_overlap_pb": "NONOVERLAPPING" }, { "rowset_id": 0, "partition_id": 69396946, "tablet_id": 69396992, "txn_id": 16372283, "tablet_schema_hash": 381861089, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 8577, "end_version": 8577, "num_rows": 0, "total_disk_size": 0, "data_disk_size": 0, "index_disk_size": 0, "empty": true, "load_id": { "hi": 1422009873144106950, "lo": -7104370273887810019 }, "creation_time": 1778013324, "tablet_uid": { "hi": -4446207284654699731, "lo": 4599060047577645477 }, "num_segments": 0, "rowset_id_v2": "0200000000d7b9543e4f039611b6885945b9c09748d2b3ba", "newest_write_timestamp": 1778013324, "tablet_schema": { "keys_type": "UNIQUE_KEYS", "column": [ { "unique_id": 0, "name": "id", "type": "BIGINT", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 1, "name": "province_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "factory_full_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 3, "name": "product_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 4, "name": "product_model", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "name": "zone_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 6, "name": "factory_code", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 7, "name": "factory_short_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 8, "name": "machine_category_id", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 9, "name": "machine_category_code", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 10, "name": "machine_category_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 130, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 11, "name": "machine_category_id_path", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 12, "name": "machine_category_name_path", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 13, "name": "machine_wnong_category_code", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 14, "name": "machine_wnong_category_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 15, "name": "product_sale_money", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 16, "name": "product_photo_files", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1002, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 17, "name": "product_core_param_type", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 18, "name": "product_core_param_val", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 19, "name": "product_nameplate_files", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1002, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 20, "name": "cert_org_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 21, "name": "cert_start_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 22, "name": "cert_end_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 23, "name": "source_origin_id", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 24, "name": "clean_task_id", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 25, "name": "etl_batch_no", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 26, "name": "is_deleted", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true, "result_is_nullable": false }, { "unique_id": 27, "name": "create_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 28, "name": "update_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 29, "name": "__DORIS_DELETE_SIGN__", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true, "result_is_nullable": false }, { "unique_id": 30, "name": "__DORIS_VERSION_COL__", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false } ], "num_short_key_columns": 2, "num_rows_per_row_block": 1024, "compress_kind": "COMPRESS_LZ4", "next_column_unique_id": 31, "is_in_memory": false, "delete_sign_idx": 29, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 5, "compression_type": "LZ4F", "schema_version": 0, "disable_auto_compaction": false, "version_col_idx": 30, "store_row_column": false, "enable_single_replica_compaction": false, "skip_write_index_on_load": false, "inverted_index_storage_format": "V1" }, "segments_overlap_pb": "OVERLAPPING" } ], "in_restore_mode": false, "tablet_uid": { "hi": -4446207284654699731, "lo": 4599060047577645477 }, "preferred_rowset_type": "BETA_ROWSET", "tablet_type": "TABLET_TYPE_DISK", "replica_id": 69396993, "delete_bitmap": {}, "enable_unique_key_merge_on_write": true, "binlog_config": { "enable": false, "ttl_seconds": 86400, "max_bytes": 9223372036854775807, "max_history_nums": 9223372036854775807 }, "compaction_policy": "size_based", "time_series_compaction_goal_size_mbytes": 1024, "time_series_compaction_file_count_threshold": 2000, "time_series_compaction_time_threshold_seconds": 3600, "time_series_compaction_empty_rowsets_threshold": 5, "time_series_compaction_level_threshold": 1 }