{ "table_id": 66056087, "partition_id": 69431552, "tablet_id": 69431571, "schema_hash": 1780330714, "shard_id": 287, "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": 69431571, "tablet_schema_hash": 1780330714, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 0, "end_version": 21802, "num_rows": 336841, "total_disk_size": 82797304, "data_disk_size": 82797304, "index_disk_size": -7782664836345411840, "empty": false, "creation_time": 1780096616, "tablet_uid": { "hi": -3365358311342906280, "lo": 4796858515863088808 }, "num_segments": 1, "rowset_id_v2": "0200000001287e013e4f039611b6885945b9c09748d2b3ba", "newest_write_timestamp": 1780006609, "segments_key_bounds": [ { "min_key": "\u0002€\u0000\u0007κ\u0002110000\u0002€\u0000\u0000\u0000\u0000\u0000\u0000'\u0002„\u001AS#•Γ`\t", "max_key": "\u0002€\u0000\u0007κ\u0002660000\u0002€\u0000\u0000\u0000\u0000\u0000\u0003j\u0002„k±­\u0015\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": 69431571, "tablet_schema_hash": 1780330714, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 21803, "end_version": 29816, "num_rows": 122136, "total_disk_size": 30176833, "data_disk_size": 30176833, "index_disk_size": -6413106112684134768, "empty": false, "creation_time": 1781799532, "tablet_uid": { "hi": -3365358311342906280, "lo": 4796858515863088808 }, "num_segments": 1, "rowset_id_v2": "020000000156c78d3e4f039611b6885945b9c09748d2b3ba", "newest_write_timestamp": 1781799517, "segments_key_bounds": [ { "min_key": "\u0002€\u0000\u0007κ\u0002110000\u0002€\u0000\u0000\u0000\u0000\u0000\u0003‘\u0002„t°¬\u0016ƒ`H", "max_key": "\u0002€\u0000\u0007κ\u0002660000\u0002€\u0000\u0000\u0000\u0000\u0000\u0004N\u0002„†ΊνΓ\u0003`η" } ], "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": 69431571, "tablet_schema_hash": 1780330714, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 29817, "end_version": 30708, "num_rows": 13830, "total_disk_size": 3557093, "data_disk_size": 3557093, "index_disk_size": 1258293825831971, "empty": false, "creation_time": 1781801200, "tablet_uid": { "hi": -3365358311342906280, "lo": 4796858515863088808 }, "num_segments": 1, "rowset_id_v2": "0200000001576ad13e4f039611b6885945b9c09748d2b3ba", "newest_write_timestamp": 1781801193, "segments_key_bounds": [ { "min_key": "\u0002€\u0000\u0007κ\u0002130000\u0002€\u0000\u0000\u0000\u0000\u0000\u0004+\u0002„†»#Oƒ`\r", "max_key": "\u0002€\u0000\u0007κ\u0002650000\u0002€\u0000\u0000\u0000\u0000\u0000\u0004M\u0002„†½9\u0011Γam" } ], "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": 69431571, "tablet_schema_hash": 1780330714, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 30709, "end_version": 31049, "num_rows": 5305, "total_disk_size": 1386476, "data_disk_size": 1386476, "index_disk_size": 645993802966873092, "empty": false, "creation_time": 1781806158, "tablet_uid": { "hi": -3365358311342906280, "lo": 4796858515863088808 }, "num_segments": 1, "rowset_id_v2": "020000000158245b3e4f039611b6885945b9c09748d2b3ba", "newest_write_timestamp": 1781806146, "segments_key_bounds": [ { "min_key": "\u0002€\u0000\u0007κ\u0002410000\u0002€\u0000\u0000\u0000\u0000\u0000\u0004=\u0002„†Α”ώ\u0003`\n", "max_key": "\u0002€\u0000\u0007κ\u0002530000\u0002€\u0000\u0000\u0000\u0000\u0000\u0004G\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": 69431571, "tablet_schema_hash": 1780330714, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 31050, "end_version": 31072, "num_rows": 360, "total_disk_size": 110808, "data_disk_size": 110808, "index_disk_size": 1258365410296966, "empty": false, "creation_time": 1781807243, "tablet_uid": { "hi": -3365358311342906280, "lo": 4796858515863088808 }, "num_segments": 1, "rowset_id_v2": "0200000001582a883e4f039611b6885945b9c09748d2b3ba", "newest_write_timestamp": 1781807240, "segments_key_bounds": [ { "min_key": "\u0002€\u0000\u0007κ\u0002430000\u0002€\u0000\u0000\u0000\u0000\u0000\u0004?\u0002„†ΤŒ©C`G", "max_key": "\u0002€\u0000\u0007κ\u0002430000\u0002€\u0000\u0000\u0000\u0000\u0000\u0004?\u0002„†Ψ”—ƒ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": 69431571, "txn_id": 17839689, "tablet_schema_hash": 1780330714, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 31073, "end_version": 31073, "num_rows": 15, "total_disk_size": 26736, "data_disk_size": 26736, "index_disk_size": 1598, "empty": false, "load_id": { "hi": -1421105711171407949, "lo": -2830808229321911153 }, "creation_time": 1781807286, "tablet_uid": { "hi": -3365358311342906280, "lo": 4796858515863088808 }, "num_segments": 1, "rowset_id_v2": "0200000001582a9a3e4f039611b6885945b9c09748d2b3ba", "newest_write_timestamp": 1781807286, "segments_key_bounds": [ { "min_key": "\u0002€\u0000\u0007κ\u0002430000\u0002€\u0000\u0000\u0000\u0000\u0000\u0004?\u0002„†ΨΑ€Γ`\u0007", "max_key": "\u0002€\u0000\u0007κ\u0002430000\u0002€\u0000\u0000\u0000\u0000\u0000\u0004?\u0002„†ΨΑ€Γ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": 69431571, "txn_id": 17839690, "tablet_schema_hash": 1780330714, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 31074, "end_version": 31074, "num_rows": 3, "total_disk_size": 13899, "data_disk_size": 13899, "index_disk_size": 1598, "empty": false, "load_id": { "hi": 8883348129297049243, "lo": 5658817895312720027 }, "creation_time": 1781807288, "tablet_uid": { "hi": -3365358311342906280, "lo": 4796858515863088808 }, "num_segments": 1, "rowset_id_v2": "0200000001582ab93e4f039611b6885945b9c09748d2b3ba", "newest_write_timestamp": 1781807287, "segments_key_bounds": [ { "min_key": "\u0002€\u0000\u0007κ\u0002430000\u0002€\u0000\u0000\u0000\u0000\u0000\u0004?\u0002„†ΨΓ\\C`\u000B", "max_key": "\u0002€\u0000\u0007κ\u0002430000\u0002€\u0000\u0000\u0000\u0000\u0000\u0004?\u0002„†ΨΓ\\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" } ], "in_restore_mode": false, "tablet_uid": { "hi": -3365358311342906280, "lo": 4796858515863088808 }, "preferred_rowset_type": "BETA_ROWSET", "tablet_type": "TABLET_TYPE_DISK", "replica_id": 69431572, "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 }