{ "table_id": 66056087, "partition_id": 69431552, "tablet_id": 69431565, "schema_hash": 1780330714, "shard_id": 285, "creation_time": 1774523042, "cumulative_layer_point": -1, "tablet_state": "PB_RUNNING", "schema": { "keys_type": "DUP_KEYS", "column": [ { "unique_id": 0, "name": "year_num", "type": "INT", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 1, "name": "province_code", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "crawl_task_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": 3, "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": 4, "name": "province_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "name": "source_record_id", "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": 6, "name": "source_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": 7, "name": "source_page_no", "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": 8, "name": "raw_hash", "type": "CHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 32, "index_length": 32, "visible": true, "result_is_nullable": false }, { "unique_id": 9, "name": "is_duplicate", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true, "result_is_nullable": false }, { "unique_id": 10, "name": "duplicate_of", "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": 11, "name": "serial_no", "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": 12, "name": "buyer_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": 13, "name": "buyer_province", "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": 14, "name": "buyer_county", "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": "buyer_town", "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": 16, "name": "dealer_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": 17, "name": "factory_full_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": 18, "name": "machine_item", "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": "machine_product", "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": 20, "name": "machine_model", "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": "machine_count", "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": 22, "name": "buy_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": "machine_price", "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": 24, "name": "subsidy_central_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": 25, "name": "subsidy_province_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": 26, "name": "subsidy_city_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": 27, "name": "subsidy_county_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": 28, "name": "subsidy_interest_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": 29, "name": "subsidy_amount", "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": 30, "name": "accessory_count", "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": 31, "name": "accessory_subsidy_central_money_one", "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": 32, "name": "accessory_subsidy_central_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": 33, "name": "accessory_subsidy_province_money_one", "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": 34, "name": "accessory_subsidy_province_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": 35, "name": "machine_card", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 65535, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 36, "name": "status", "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": 37, "name": "exceed_status", "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": 38, "name": "raw_json", "type": "STRING", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 2147483647, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 39, "name": "raw_ext", "type": "STRING", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 2147483647, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 40, "name": "created_at", "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 } ], "num_short_key_columns": 2, "num_rows_per_row_block": 1024, "compress_kind": "COMPRESS_LZ4", "next_column_unique_id": 41, "is_in_memory": false, "delete_sign_idx": -1, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 4, "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": 69431552, "tablet_id": 69431565, "tablet_schema_hash": 1780330714, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 0, "end_version": 1, "num_rows": 0, "total_disk_size": 0, "data_disk_size": 0, "index_disk_size": 0, "empty": true, "creation_time": 1774523042, "tablet_uid": { "hi": 1462401456881840023, "lo": 4672618474348421804 }, "num_segments": 0, "rowset_id_v2": "0200000000566cae3e4f039611b6885945b9c09748d2b3ba", "newest_write_timestamp": 1774523042, "tablet_schema": { "keys_type": "DUP_KEYS", "column": [ { "unique_id": 0, "name": "year_num", "type": "INT", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 1, "name": "province_code", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "crawl_task_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": 3, "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": 4, "name": "province_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "name": "source_record_id", "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": 6, "name": "source_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": 7, "name": "source_page_no", "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": 8, "name": "raw_hash", "type": "CHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 32, "index_length": 32, "visible": true, "result_is_nullable": false }, { "unique_id": 9, "name": "is_duplicate", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true, "result_is_nullable": false }, { "unique_id": 10, "name": "duplicate_of", "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": 11, "name": "serial_no", "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": 12, "name": "buyer_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": 13, "name": "buyer_province", "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": 14, "name": "buyer_county", "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": "buyer_town", "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": 16, "name": "dealer_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": 17, "name": "factory_full_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": 18, "name": "machine_item", "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": "machine_product", "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": 20, "name": "machine_model", "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": "machine_count", "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": 22, "name": "buy_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": "machine_price", "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": 24, "name": "subsidy_central_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": 25, "name": "subsidy_province_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": 26, "name": "subsidy_city_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": 27, "name": "subsidy_county_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": 28, "name": "subsidy_interest_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": 29, "name": "subsidy_amount", "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": 30, "name": "accessory_count", "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": 31, "name": "accessory_subsidy_central_money_one", "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": 32, "name": "accessory_subsidy_central_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": 33, "name": "accessory_subsidy_province_money_one", "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": 34, "name": "accessory_subsidy_province_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": 35, "name": "machine_card", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 65535, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 36, "name": "status", "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": 37, "name": "exceed_status", "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": 38, "name": "raw_json", "type": "STRING", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 2147483647, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 39, "name": "raw_ext", "type": "STRING", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 2147483647, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 40, "name": "created_at", "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 } ], "num_short_key_columns": 2, "num_rows_per_row_block": 1024, "compress_kind": "COMPRESS_LZ4", "next_column_unique_id": 41, "is_in_memory": false, "delete_sign_idx": -1, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 4, "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": "OVERLAP_UNKNOWN" }, { "rowset_id": 0, "partition_id": 69431552, "tablet_id": 69431565, "tablet_schema_hash": 1780330714, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 2, "end_version": 8131, "num_rows": 124947, "total_disk_size": 30722454, "data_disk_size": 30722454, "index_disk_size": 1258293481042265, "empty": false, "creation_time": 1776960283, "tablet_uid": { "hi": 1462401456881840023, "lo": 4672618474348421804 }, "num_segments": 1, "rowset_id_v2": "0200000000bc1f353e4f039611b6885945b9c09748d2b3ba", "newest_write_timestamp": 1776960269, "segments_key_bounds": [ { "min_key": "\u0002€\u0000\u0007ê\u0002110000\u0002€\u0000\u0000\u0000\u0000\u0000\u0000'\u0002„\u001AS#•Ã`E", "max_key": "\u0002€\u0000\u0007ê\u0002660000\u0002€\u0000\u0000\u0000\u0000\u0000\u0001¢\u0002„5œ4±Ãaˆ" } ], "tablet_schema": { "keys_type": "DUP_KEYS", "column": [ { "unique_id": 0, "name": "year_num", "type": "INT", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 1, "name": "province_code", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "crawl_task_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": 3, "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": 4, "name": "province_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "name": "source_record_id", "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": 6, "name": "source_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": 7, "name": "source_page_no", "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": 8, "name": "raw_hash", "type": "CHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 32, "index_length": 32, "visible": true, "result_is_nullable": false }, { "unique_id": 9, "name": "is_duplicate", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true, "result_is_nullable": false }, { "unique_id": 10, "name": "duplicate_of", "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": 11, "name": "serial_no", "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": 12, "name": "buyer_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": 13, "name": "buyer_province", "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": 14, "name": "buyer_county", "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": "buyer_town", "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": 16, "name": "dealer_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": 17, "name": "factory_full_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": 18, "name": "machine_item", "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": "machine_product", "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": 20, "name": "machine_model", "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": "machine_count", "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": 22, "name": "buy_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": "machine_price", "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": 24, "name": "subsidy_central_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": 25, "name": "subsidy_province_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": 26, "name": "subsidy_city_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": 27, "name": "subsidy_county_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": 28, "name": "subsidy_interest_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": 29, "name": "subsidy_amount", "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": 30, "name": "accessory_count", "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": 31, "name": "accessory_subsidy_central_money_one", "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": 32, "name": "accessory_subsidy_central_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": 33, "name": "accessory_subsidy_province_money_one", "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": 34, "name": "accessory_subsidy_province_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": 35, "name": "machine_card", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 65535, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 36, "name": "status", "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": 37, "name": "exceed_status", "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": 38, "name": "raw_json", "type": "STRING", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 2147483647, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 39, "name": "raw_ext", "type": "STRING", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 2147483647, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 40, "name": "created_at", "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 } ], "num_short_key_columns": 2, "num_rows_per_row_block": 1024, "compress_kind": "COMPRESS_LZ4", "next_column_unique_id": 41, "is_in_memory": false, "delete_sign_idx": -1, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 4, "compression_type": "LZ4F", "schema_version": 2, "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": 69431552, "tablet_id": 69431565, "tablet_schema_hash": 1780330714, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 8132, "end_version": 10270, "num_rows": 33143, "total_disk_size": 8559668, "data_disk_size": 8559668, "index_disk_size": 1258302026151420, "empty": false, "creation_time": 1777565118, "tablet_uid": { "hi": 1462401456881840023, "lo": 4672618474348421804 }, "num_segments": 1, "rowset_id_v2": "0200000000cfc36b3e4f039611b6885945b9c09748d2b3ba", "newest_write_timestamp": 1777565115, "segments_key_bounds": [ { "min_key": "\u0002€\u0000\u0007ê\u0002110000\u0002€\u0000\u0000\u0000\u0000\u0000\u0002\u0015\u0002„G¡\u0003yC`\u000B", "max_key": "\u0002€\u0000\u0007ê\u0002660000\u0002€\u0000\u0000\u0000\u0000\u0000\u0001î\u0002„>ŸlkÃa¥" } ], "tablet_schema": { "keys_type": "DUP_KEYS", "column": [ { "unique_id": 0, "name": "year_num", "type": "INT", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 1, "name": "province_code", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "crawl_task_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": 3, "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": 4, "name": "province_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "name": "source_record_id", "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": 6, "name": "source_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": 7, "name": "source_page_no", "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": 8, "name": "raw_hash", "type": "CHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 32, "index_length": 32, "visible": true, "result_is_nullable": false }, { "unique_id": 9, "name": "is_duplicate", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true, "result_is_nullable": false }, { "unique_id": 10, "name": "duplicate_of", "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": 11, "name": "serial_no", "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": 12, "name": "buyer_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": 13, "name": "buyer_province", "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": 14, "name": "buyer_county", "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": "buyer_town", "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": 16, "name": "dealer_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": 17, "name": "factory_full_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": 18, "name": "machine_item", "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": "machine_product", "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": 20, "name": "machine_model", "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": "machine_count", "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": 22, "name": "buy_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": "machine_price", "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": 24, "name": "subsidy_central_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": 25, "name": "subsidy_province_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": 26, "name": "subsidy_city_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": 27, "name": "subsidy_county_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": 28, "name": "subsidy_interest_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": 29, "name": "subsidy_amount", "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": 30, "name": "accessory_count", "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": 31, "name": "accessory_subsidy_central_money_one", "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": 32, "name": "accessory_subsidy_central_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": 33, "name": "accessory_subsidy_province_money_one", "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": 34, "name": "accessory_subsidy_province_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": 35, "name": "machine_card", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 65535, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 36, "name": "status", "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": 37, "name": "exceed_status", "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": 38, "name": "raw_json", "type": "STRING", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 2147483647, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 39, "name": "raw_ext", "type": "STRING", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 2147483647, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 40, "name": "created_at", "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 } ], "num_short_key_columns": 2, "num_rows_per_row_block": 1024, "compress_kind": "COMPRESS_LZ4", "next_column_unique_id": 41, "is_in_memory": false, "delete_sign_idx": -1, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 4, "compression_type": "LZ4F", "schema_version": 2, "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": 69431552, "tablet_id": 69431565, "tablet_schema_hash": 1780330714, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 10271, "end_version": 10989, "num_rows": 11168, "total_disk_size": 2958945, "data_disk_size": 2958945, "index_disk_size": -1220446309396124409, "empty": false, "creation_time": 1777565850, "tablet_uid": { "hi": 1462401456881840023, "lo": 4672618474348421804 }, "num_segments": 1, "rowset_id_v2": "0200000000d034fd3e4f039611b6885945b9c09748d2b3ba", "newest_write_timestamp": 1777565846, "segments_key_bounds": [ { "min_key": "\u0002€\u0000\u0007ê\u0002130000\u0002€\u0000\u0000\u0000\u0000\u0000\u0002\u0017\u0002„G¢.Ôƒ`N", "max_key": "\u0002€\u0000\u0007ê\u0002660000\u0002€\u0000\u0000\u0000\u0000\u0000\u0002:\u0002„G¢”Öƒa\u0011" } ], "tablet_schema": { "keys_type": "DUP_KEYS", "column": [ { "unique_id": 0, "name": "year_num", "type": "INT", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 1, "name": "province_code", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "crawl_task_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": 3, "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": 4, "name": "province_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "name": "source_record_id", "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": 6, "name": "source_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": 7, "name": "source_page_no", "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": 8, "name": "raw_hash", "type": "CHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 32, "index_length": 32, "visible": true, "result_is_nullable": false }, { "unique_id": 9, "name": "is_duplicate", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true, "result_is_nullable": false }, { "unique_id": 10, "name": "duplicate_of", "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": 11, "name": "serial_no", "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": 12, "name": "buyer_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": 13, "name": "buyer_province", "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": 14, "name": "buyer_county", "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": "buyer_town", "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": 16, "name": "dealer_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": 17, "name": "factory_full_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": 18, "name": "machine_item", "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": "machine_product", "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": 20, "name": "machine_model", "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": "machine_count", "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": 22, "name": "buy_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": "machine_price", "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": 24, "name": "subsidy_central_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": 25, "name": "subsidy_province_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": 26, "name": "subsidy_city_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": 27, "name": "subsidy_county_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": 28, "name": "subsidy_interest_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": 29, "name": "subsidy_amount", "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": 30, "name": "accessory_count", "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": 31, "name": "accessory_subsidy_central_money_one", "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": 32, "name": "accessory_subsidy_central_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": 33, "name": "accessory_subsidy_province_money_one", "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": 34, "name": "accessory_subsidy_province_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": 35, "name": "machine_card", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 65535, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 36, "name": "status", "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": 37, "name": "exceed_status", "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": 38, "name": "raw_json", "type": "STRING", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 2147483647, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 39, "name": "raw_ext", "type": "STRING", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 2147483647, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 40, "name": "created_at", "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 } ], "num_short_key_columns": 2, "num_rows_per_row_block": 1024, "compress_kind": "COMPRESS_LZ4", "next_column_unique_id": 41, "is_in_memory": false, "delete_sign_idx": -1, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 4, "compression_type": "LZ4F", "schema_version": 2, "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": 69431552, "tablet_id": 69431565, "tablet_schema_hash": 1780330714, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 10990, "end_version": 11267, "num_rows": 4272, "total_disk_size": 1138599, "data_disk_size": 1138599, "index_disk_size": -4303978422204783424, "empty": false, "creation_time": 1777566576, "tablet_uid": { "hi": 1462401456881840023, "lo": 4672618474348421804 }, "num_segments": 1, "rowset_id_v2": "0200000000d06e1d3e4f039611b6885945b9c09748d2b3ba", "newest_write_timestamp": 1777566573, "segments_key_bounds": [ { "min_key": "\u0002€\u0000\u0007ê\u0002150000\u0002€\u0000\u0000\u0000\u0000\u0000\u0002\u0019\u0002„G¤üXÃ`\u0000", "max_key": "\u0002€\u0000\u0007ê\u0002620000\u0002€\u0000\u0000\u0000\u0000\u0000\u00026\u0002„G¦?\u0010ƒ`g" } ], "tablet_schema": { "keys_type": "DUP_KEYS", "column": [ { "unique_id": 0, "name": "year_num", "type": "INT", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 1, "name": "province_code", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "crawl_task_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": 3, "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": 4, "name": "province_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "name": "source_record_id", "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": 6, "name": "source_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": 7, "name": "source_page_no", "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": 8, "name": "raw_hash", "type": "CHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 32, "index_length": 32, "visible": true, "result_is_nullable": false }, { "unique_id": 9, "name": "is_duplicate", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true, "result_is_nullable": false }, { "unique_id": 10, "name": "duplicate_of", "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": 11, "name": "serial_no", "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": 12, "name": "buyer_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": 13, "name": "buyer_province", "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": 14, "name": "buyer_county", "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": "buyer_town", "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": 16, "name": "dealer_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": 17, "name": "factory_full_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": 18, "name": "machine_item", "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": "machine_product", "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": 20, "name": "machine_model", "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": "machine_count", "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": 22, "name": "buy_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": "machine_price", "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": 24, "name": "subsidy_central_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": 25, "name": "subsidy_province_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": 26, "name": "subsidy_city_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": 27, "name": "subsidy_county_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": 28, "name": "subsidy_interest_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": 29, "name": "subsidy_amount", "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": 30, "name": "accessory_count", "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": 31, "name": "accessory_subsidy_central_money_one", "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": 32, "name": "accessory_subsidy_central_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": 33, "name": "accessory_subsidy_province_money_one", "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": 34, "name": "accessory_subsidy_province_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": 35, "name": "machine_card", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 65535, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 36, "name": "status", "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": 37, "name": "exceed_status", "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": 38, "name": "raw_json", "type": "STRING", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 2147483647, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 39, "name": "raw_ext", "type": "STRING", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 2147483647, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 40, "name": "created_at", "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 } ], "num_short_key_columns": 2, "num_rows_per_row_block": 1024, "compress_kind": "COMPRESS_LZ4", "next_column_unique_id": 41, "is_in_memory": false, "delete_sign_idx": -1, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 4, "compression_type": "LZ4F", "schema_version": 2, "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": 69431552, "tablet_id": 69431565, "tablet_schema_hash": 1780330714, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 11268, "end_version": 11412, "num_rows": 2221, "total_disk_size": 589416, "data_disk_size": 589416, "index_disk_size": 1258364809411521, "empty": false, "creation_time": 1777568457, "tablet_uid": { "hi": 1462401456881840023, "lo": 4672618474348421804 }, "num_segments": 1, "rowset_id_v2": "0200000000d0bdb83e4f039611b6885945b9c09748d2b3ba", "newest_write_timestamp": 1777568425, "segments_key_bounds": [ { "min_key": "\u0002€\u0000\u0007ê\u0002410000\u0002€\u0000\u0000\u0000\u0000\u0000\u0002)\u0002„G§½iC`\f", "max_key": "\u0002€\u0000\u0007ê\u0002530000\u0002€\u0000\u0000\u0000\u0000\u0000\u00023\u0002„G©…ÇC`" } ], "tablet_schema": { "keys_type": "DUP_KEYS", "column": [ { "unique_id": 0, "name": "year_num", "type": "INT", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 1, "name": "province_code", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "crawl_task_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": 3, "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": 4, "name": "province_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "name": "source_record_id", "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": 6, "name": "source_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": 7, "name": "source_page_no", "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": 8, "name": "raw_hash", "type": "CHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 32, "index_length": 32, "visible": true, "result_is_nullable": false }, { "unique_id": 9, "name": "is_duplicate", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true, "result_is_nullable": false }, { "unique_id": 10, "name": "duplicate_of", "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": 11, "name": "serial_no", "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": 12, "name": "buyer_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": 13, "name": "buyer_province", "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": 14, "name": "buyer_county", "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": "buyer_town", "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": 16, "name": "dealer_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": 17, "name": "factory_full_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": 18, "name": "machine_item", "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": "machine_product", "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": 20, "name": "machine_model", "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": "machine_count", "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": 22, "name": "buy_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": "machine_price", "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": 24, "name": "subsidy_central_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": 25, "name": "subsidy_province_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": 26, "name": "subsidy_city_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": 27, "name": "subsidy_county_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": 28, "name": "subsidy_interest_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": 29, "name": "subsidy_amount", "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": 30, "name": "accessory_count", "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": 31, "name": "accessory_subsidy_central_money_one", "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": 32, "name": "accessory_subsidy_central_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": 33, "name": "accessory_subsidy_province_money_one", "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": 34, "name": "accessory_subsidy_province_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": 35, "name": "machine_card", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 65535, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 36, "name": "status", "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": 37, "name": "exceed_status", "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": 38, "name": "raw_json", "type": "STRING", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 2147483647, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 39, "name": "raw_ext", "type": "STRING", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 2147483647, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 40, "name": "created_at", "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 } ], "num_short_key_columns": 2, "num_rows_per_row_block": 1024, "compress_kind": "COMPRESS_LZ4", "next_column_unique_id": 41, "is_in_memory": false, "delete_sign_idx": -1, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 4, "compression_type": "LZ4F", "schema_version": 2, "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": 69431552, "tablet_id": 69431565, "tablet_schema_hash": 1780330714, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 11413, "end_version": 11455, "num_rows": 665, "total_disk_size": 176979, "data_disk_size": 176979, "index_disk_size": 1258293536645991, "empty": false, "creation_time": 1777570510, "tablet_uid": { "hi": 1462401456881840023, "lo": 4672618474348421804 }, "num_segments": 1, "rowset_id_v2": "0200000000d0e7873e4f039611b6885945b9c09748d2b3ba", "newest_write_timestamp": 1777570474, "segments_key_bounds": [ { "min_key": "\u0002€\u0000\u0007ê\u0002430000\u0002€\u0000\u0000\u0000\u0000\u0000\u0002+\u0002„G®ö\u0014\u0003`C", "max_key": "\u0002€\u0000\u0007ê\u0002430000\u0002€\u0000\u0000\u0000\u0000\u0000\u0002+\u0002„G¶™î\u0003aä" } ], "tablet_schema": { "keys_type": "DUP_KEYS", "column": [ { "unique_id": 0, "name": "year_num", "type": "INT", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 1, "name": "province_code", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "crawl_task_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": 3, "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": 4, "name": "province_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "name": "source_record_id", "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": 6, "name": "source_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": 7, "name": "source_page_no", "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": 8, "name": "raw_hash", "type": "CHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 32, "index_length": 32, "visible": true, "result_is_nullable": false }, { "unique_id": 9, "name": "is_duplicate", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true, "result_is_nullable": false }, { "unique_id": 10, "name": "duplicate_of", "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": 11, "name": "serial_no", "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": 12, "name": "buyer_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": 13, "name": "buyer_province", "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": 14, "name": "buyer_county", "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": "buyer_town", "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": 16, "name": "dealer_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": 17, "name": "factory_full_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": 18, "name": "machine_item", "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": "machine_product", "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": 20, "name": "machine_model", "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": "machine_count", "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": 22, "name": "buy_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": "machine_price", "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": 24, "name": "subsidy_central_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": 25, "name": "subsidy_province_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": 26, "name": "subsidy_city_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": 27, "name": "subsidy_county_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": 28, "name": "subsidy_interest_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": 29, "name": "subsidy_amount", "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": 30, "name": "accessory_count", "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": 31, "name": "accessory_subsidy_central_money_one", "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": 32, "name": "accessory_subsidy_central_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": 33, "name": "accessory_subsidy_province_money_one", "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": 34, "name": "accessory_subsidy_province_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": 35, "name": "machine_card", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 65535, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 36, "name": "status", "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": 37, "name": "exceed_status", "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": 38, "name": "raw_json", "type": "STRING", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 2147483647, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 39, "name": "raw_ext", "type": "STRING", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 2147483647, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 40, "name": "created_at", "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 } ], "num_short_key_columns": 2, "num_rows_per_row_block": 1024, "compress_kind": "COMPRESS_LZ4", "next_column_unique_id": 41, "is_in_memory": false, "delete_sign_idx": -1, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 4, "compression_type": "LZ4F", "schema_version": 2, "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": 69431552, "tablet_id": 69431565, "txn_id": 16259769, "tablet_schema_hash": 1780330714, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 11456, "end_version": 11456, "num_rows": 15, "total_disk_size": 25647, "data_disk_size": 25647, "index_disk_size": 1598, "empty": false, "load_id": { "hi": 5715014056840520313, "lo": -8514425924012676480 }, "creation_time": 1777570547, "tablet_uid": { "hi": 1462401456881840023, "lo": 4672618474348421804 }, "num_segments": 1, "rowset_id_v2": "0200000000d0e79b3e4f039611b6885945b9c09748d2b3ba", "newest_write_timestamp": 1777570547, "segments_key_bounds": [ { "min_key": "\u0002€\u0000\u0007ê\u0002430000\u0002€\u0000\u0000\u0000\u0000\u0000\u0002+\u0002„G¶á€ƒ`\n", "max_key": "\u0002€\u0000\u0007ê\u0002430000\u0002€\u0000\u0000\u0000\u0000\u0000\u0002+\u0002„G¶á€ƒaâ" } ], "tablet_schema": { "keys_type": "DUP_KEYS", "column": [ { "unique_id": 0, "name": "year_num", "type": "INT", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 1, "name": "province_code", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "crawl_task_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": 3, "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": 4, "name": "province_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "name": "source_record_id", "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": 6, "name": "source_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": 7, "name": "source_page_no", "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": 8, "name": "raw_hash", "type": "CHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 32, "index_length": 32, "visible": true, "result_is_nullable": false }, { "unique_id": 9, "name": "is_duplicate", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true, "result_is_nullable": false }, { "unique_id": 10, "name": "duplicate_of", "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": 11, "name": "serial_no", "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": 12, "name": "buyer_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": 13, "name": "buyer_province", "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": 14, "name": "buyer_county", "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": "buyer_town", "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": 16, "name": "dealer_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": 17, "name": "factory_full_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": 18, "name": "machine_item", "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": "machine_product", "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": 20, "name": "machine_model", "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": "machine_count", "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": 22, "name": "buy_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": "machine_price", "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": 24, "name": "subsidy_central_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": 25, "name": "subsidy_province_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": 26, "name": "subsidy_city_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": 27, "name": "subsidy_county_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": 28, "name": "subsidy_interest_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": 29, "name": "subsidy_amount", "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": 30, "name": "accessory_count", "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": 31, "name": "accessory_subsidy_central_money_one", "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": 32, "name": "accessory_subsidy_central_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": 33, "name": "accessory_subsidy_province_money_one", "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": 34, "name": "accessory_subsidy_province_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": 35, "name": "machine_card", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 65535, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 36, "name": "status", "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": 37, "name": "exceed_status", "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": 38, "name": "raw_json", "type": "STRING", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 2147483647, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 39, "name": "raw_ext", "type": "STRING", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 2147483647, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 40, "name": "created_at", "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 } ], "num_short_key_columns": 2, "num_rows_per_row_block": 1024, "compress_kind": "COMPRESS_LZ4", "next_column_unique_id": 41, "is_in_memory": false, "delete_sign_idx": -1, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 4, "compression_type": "LZ4F", "schema_version": 2, "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": 69431552, "tablet_id": 69431565, "txn_id": 16259773, "tablet_schema_hash": 1780330714, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 11457, "end_version": 11457, "num_rows": 8, "total_disk_size": 18820, "data_disk_size": 18820, "index_disk_size": 1598, "empty": false, "load_id": { "hi": 2183157273578353934, "lo": -1080501839320920405 }, "creation_time": 1777570564, "tablet_uid": { "hi": 1462401456881840023, "lo": 4672618474348421804 }, "num_segments": 1, "rowset_id_v2": "0200000000d0e7bd3e4f039611b6885945b9c09748d2b3ba", "newest_write_timestamp": 1777570564, "segments_key_bounds": [ { "min_key": "\u0002€\u0000\u0007ê\u0002430000\u0002€\u0000\u0000\u0000\u0000\u0000\u0002+\u0002„G¶ñéÃ`\u0006", "max_key": "\u0002€\u0000\u0007ê\u0002430000\u0002€\u0000\u0000\u0000\u0000\u0000\u0002+\u0002„G¶ñéÃ`°" } ], "tablet_schema": { "keys_type": "DUP_KEYS", "column": [ { "unique_id": 0, "name": "year_num", "type": "INT", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 1, "name": "province_code", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "crawl_task_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": 3, "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": 4, "name": "province_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "name": "source_record_id", "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": 6, "name": "source_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": 7, "name": "source_page_no", "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": 8, "name": "raw_hash", "type": "CHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 32, "index_length": 32, "visible": true, "result_is_nullable": false }, { "unique_id": 9, "name": "is_duplicate", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true, "result_is_nullable": false }, { "unique_id": 10, "name": "duplicate_of", "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": 11, "name": "serial_no", "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": 12, "name": "buyer_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": 13, "name": "buyer_province", "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": 14, "name": "buyer_county", "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": "buyer_town", "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": 16, "name": "dealer_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": 17, "name": "factory_full_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": 18, "name": "machine_item", "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": "machine_product", "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": 20, "name": "machine_model", "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": "machine_count", "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": 22, "name": "buy_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": "machine_price", "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": 24, "name": "subsidy_central_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": 25, "name": "subsidy_province_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": 26, "name": "subsidy_city_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": 27, "name": "subsidy_county_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": 28, "name": "subsidy_interest_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": 29, "name": "subsidy_amount", "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": 30, "name": "accessory_count", "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": 31, "name": "accessory_subsidy_central_money_one", "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": 32, "name": "accessory_subsidy_central_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": 33, "name": "accessory_subsidy_province_money_one", "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": 34, "name": "accessory_subsidy_province_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": 35, "name": "machine_card", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 65535, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 36, "name": "status", "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": 37, "name": "exceed_status", "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": 38, "name": "raw_json", "type": "STRING", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 2147483647, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 39, "name": "raw_ext", "type": "STRING", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 2147483647, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 40, "name": "created_at", "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 } ], "num_short_key_columns": 2, "num_rows_per_row_block": 1024, "compress_kind": "COMPRESS_LZ4", "next_column_unique_id": 41, "is_in_memory": false, "delete_sign_idx": -1, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 4, "compression_type": "LZ4F", "schema_version": 2, "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" } ], "in_restore_mode": false, "tablet_uid": { "hi": 1462401456881840023, "lo": 4672618474348421804 }, "preferred_rowset_type": "BETA_ROWSET", "tablet_type": "TABLET_TYPE_DISK", "replica_id": 69431566, "enable_unique_key_merge_on_write": false, "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 }