{ "table_id": 1750909331623, "partition_id": 1750909331622, "tablet_id": 1750909331631, "schema_hash": 512135045, "shard_id": 3, "creation_time": 1750917313, "cumulative_layer_point": -1, "tablet_state": "PB_RUNNING", "schema": { "keys_type": "UNIQUE_KEYS", "column": [ { "unique_id": 0, "name": "transaction_no", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 1, "name": "company_id", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 2, "name": "merchant_id", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 3, "name": "merchant_sub_id", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 4, "name": "company_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 302, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 5, "name": "merchant_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 302, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 6, "name": "sub_merchant_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 302, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 7, "name": "merchant_order_no", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 8, "name": "connector_reference_no", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 3002, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 9, "name": "transaction_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, "be_exec_version": -1 }, { "unique_id": 10, "name": "currency", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 11, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 11, "name": "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, "be_exec_version": -1 }, { "unique_id": 12, "name": "amount_usd", "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, "be_exec_version": -1 }, { "unique_id": 13, "name": "amount_connector_currency", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 11, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 14, "name": "amount_connector", "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, "be_exec_version": -1 }, { "unique_id": 15, "name": "payment_method_type", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 16, "name": "card_type", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 17, "name": "card_type_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 18, "name": "payment_method_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 19, "name": "payment_method", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 20, "name": "payment_status", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 21, "name": "transaction_status", "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, "be_exec_version": -1 }, { "unique_id": 22, "name": "connector_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 23, "name": "connector_account_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 24, "name": "domain_url", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 3002, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 25, "name": "request_url", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 302, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 26, "name": "card_no", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 92, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 27, "name": "card_bin", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 32, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 28, "name": "cardholder_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 602, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 29, "name": "risk_company", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 62, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 30, "name": "risk_result", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 62, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 31, "name": "threeds", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 62, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 32, "name": "threeds_type", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 33, "name": "threeds_result", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 34, "name": "eci", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 32, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 35, "name": "is_tokenization", "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, "be_exec_version": -1 }, { "unique_id": 36, "name": "email", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 302, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 37, "name": "shopper_level", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 38, "name": "shopper_id", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 302, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 39, "name": "ip_address", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 40, "name": "ip_country", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 41, "name": "ip_continent", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 42, "name": "card_country", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 43, "name": "card_continent", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 44, "name": "failure_reason", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 602, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 45, "name": "is_retry", "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, "be_exec_version": -1 }, { "unique_id": 46, "name": "is_repay", "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, "be_exec_version": -1 }, { "unique_id": 47, "name": "platform_source", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 48, "name": "shipping_address", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1502, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 49, "name": "shipping_city", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 602, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 50, "name": "shipping_state", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 602, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 51, "name": "shipping_country", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 302, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 52, "name": "shipping_zipcode", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 602, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 53, "name": "shipping_phone", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 302, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 54, "name": "shipping_email", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 302, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 55, "name": "billing_address", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1502, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 56, "name": "billing_city", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 602, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 57, "name": "billing_state", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 602, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 58, "name": "billing_country", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 302, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 59, "name": "billing_zipcode", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 602, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 60, "name": "billing_phone", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 302, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 61, "name": "is_refund", "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, "be_exec_version": -1 }, { "unique_id": 62, "name": "refund_date", "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, "be_exec_version": -1 }, { "unique_id": 63, "name": "refund_days", "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, "be_exec_version": -1 }, { "unique_id": 64, "name": "is_dispute", "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, "be_exec_version": -1 }, { "unique_id": 65, "name": "dispute_type", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 302, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 66, "name": "dispute_reason_code", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 62, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 67, "name": "dispute_reason", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 302, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 68, "name": "dispute_date", "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, "be_exec_version": -1 }, { "unique_id": 69, "name": "dispute_days", "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, "be_exec_version": -1 }, { "unique_id": 70, "name": "is_connector_settlement", "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, "be_exec_version": -1 }, { "unique_id": 71, "name": "is_received", "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, "be_exec_version": -1 }, { "unique_id": 72, "name": "item_quantity", "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, "be_exec_version": -1 }, { "unique_id": 73, "name": "create_at", "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, "be_exec_version": -1 }, { "unique_id": 74, "name": "update_at", "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, "be_exec_version": -1 }, { "unique_id": 75, "name": "__DORIS_DELETE_SIGN__", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 76, "name": "__DORIS_VERSION_COL__", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false, "be_exec_version": -1 } ], "num_short_key_columns": 1, "num_rows_per_row_block": 1024, "compress_kind": "COMPRESS_LZ4", "next_column_unique_id": 77, "is_in_memory": false, "delete_sign_idx": 75, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 1, "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": "V2", "row_store_page_size": 16384, "variant_enable_flatten_nested": false, "storage_page_size": 65536 }, "rs_metas": [ { "rowset_id": 0, "partition_id": 1750909331622, "tablet_id": 1750909331631, "tablet_schema_hash": 512135045, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 0, "end_version": 70, "num_rows": 125088, "total_disk_size": 37524455, "data_disk_size": 37524455, "index_disk_size": 0, "empty": false, "creation_time": 1751442404, "tablet_uid": { "hi": 4345751006721716409, "lo": 4072334287108981399 }, "num_segments": 1, "rowset_id_v2": "0200000000000790ce40eb046d01fa71f45b4010993039a0", "newest_write_timestamp": 1751273983, "segments_key_bounds": [ { "min_key": "\u0002000000807907", "max_key": "\u0002yearst1240426041" } ], "tablet_schema": { "keys_type": "UNIQUE_KEYS", "column": [ { "unique_id": 0, "name": "transaction_no", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 1, "name": "company_id", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 2, "name": "merchant_id", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 3, "name": "merchant_sub_id", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 4, "name": "company_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 302, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 5, "name": "merchant_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 302, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 6, "name": "sub_merchant_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 302, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 7, "name": "merchant_order_no", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 8, "name": "connector_reference_no", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 3002, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 9, "name": "transaction_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, "be_exec_version": -1 }, { "unique_id": 10, "name": "currency", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 11, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 11, "name": "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, "be_exec_version": -1 }, { "unique_id": 12, "name": "amount_usd", "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, "be_exec_version": -1 }, { "unique_id": 13, "name": "amount_connector_currency", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 11, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 14, "name": "amount_connector", "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, "be_exec_version": -1 }, { "unique_id": 15, "name": "payment_method_type", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 16, "name": "card_type", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 17, "name": "card_type_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 18, "name": "payment_method_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 19, "name": "payment_method", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 20, "name": "payment_status", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 21, "name": "transaction_status", "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, "be_exec_version": -1 }, { "unique_id": 22, "name": "connector_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 23, "name": "connector_account_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 24, "name": "domain_url", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 3002, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 25, "name": "request_url", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 302, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 26, "name": "card_no", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 92, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 27, "name": "card_bin", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 32, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 28, "name": "cardholder_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 602, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 29, "name": "risk_company", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 62, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 30, "name": "risk_result", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 62, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 31, "name": "threeds", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 62, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 32, "name": "threeds_type", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 33, "name": "threeds_result", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 34, "name": "eci", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 32, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 35, "name": "is_tokenization", "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, "be_exec_version": -1 }, { "unique_id": 36, "name": "email", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 302, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 37, "name": "shopper_level", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 38, "name": "shopper_id", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 302, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 39, "name": "ip_address", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 40, "name": "ip_country", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 41, "name": "ip_continent", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 42, "name": "card_country", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 43, "name": "card_continent", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 44, "name": "failure_reason", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 602, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 45, "name": "is_retry", "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, "be_exec_version": -1 }, { "unique_id": 46, "name": "is_repay", "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, "be_exec_version": -1 }, { "unique_id": 47, "name": "platform_source", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 48, "name": "shipping_address", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1502, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 49, "name": "shipping_city", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 602, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 50, "name": "shipping_state", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 602, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 51, "name": "shipping_country", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 302, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 52, "name": "shipping_zipcode", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 602, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 53, "name": "shipping_phone", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 302, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 54, "name": "shipping_email", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 302, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 55, "name": "billing_address", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1502, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 56, "name": "billing_city", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 602, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 57, "name": "billing_state", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 602, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 58, "name": "billing_country", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 302, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 59, "name": "billing_zipcode", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 602, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 60, "name": "billing_phone", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 302, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 61, "name": "is_refund", "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, "be_exec_version": -1 }, { "unique_id": 62, "name": "refund_date", "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, "be_exec_version": -1 }, { "unique_id": 63, "name": "refund_days", "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, "be_exec_version": -1 }, { "unique_id": 64, "name": "is_dispute", "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, "be_exec_version": -1 }, { "unique_id": 65, "name": "dispute_type", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 302, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 66, "name": "dispute_reason_code", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 62, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 67, "name": "dispute_reason", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 302, "index_length": 20, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 68, "name": "dispute_date", "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, "be_exec_version": -1 }, { "unique_id": 69, "name": "dispute_days", "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, "be_exec_version": -1 }, { "unique_id": 70, "name": "is_connector_settlement", "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, "be_exec_version": -1 }, { "unique_id": 71, "name": "is_received", "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, "be_exec_version": -1 }, { "unique_id": 72, "name": "item_quantity", "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, "be_exec_version": -1 }, { "unique_id": 73, "name": "create_at", "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, "be_exec_version": -1 }, { "unique_id": 74, "name": "update_at", "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, "be_exec_version": -1 }, { "unique_id": 75, "name": "__DORIS_DELETE_SIGN__", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true, "result_is_nullable": false, "be_exec_version": -1 }, { "unique_id": 76, "name": "__DORIS_VERSION_COL__", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false, "be_exec_version": -1 } ], "num_short_key_columns": 1, "num_rows_per_row_block": 1024, "compress_kind": "COMPRESS_LZ4", "next_column_unique_id": 77, "is_in_memory": false, "delete_sign_idx": 75, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 1, "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": "V2", "row_store_page_size": 16384, "variant_enable_flatten_nested": false, "storage_page_size": 65536 }, "segments_overlap_pb": "NONOVERLAPPING", "schema_version": 0, "has_variant_type_in_schema": false } ], "in_restore_mode": false, "tablet_uid": { "hi": 4345751006721716409, "lo": 4072334287108981399 }, "preferred_rowset_type": "BETA_ROWSET", "tablet_type": "TABLET_TYPE_DISK", "replica_id": 1750909331632, "delete_bitmap": {}, "enable_unique_key_merge_on_write": true, "binlog_config": { "enable": false, "ttl_seconds": 86400, "max_bytes": 9223372036854775807, "max_history_nums": 9223372036854775807 }, "compaction_policy": "size_based", "time_series_compaction_goal_size_mbytes": 1024, "time_series_compaction_file_count_threshold": 2000, "time_series_compaction_time_threshold_seconds": 3600, "time_series_compaction_empty_rowsets_threshold": 5, "time_series_compaction_level_threshold": 1, "index_id": 0, "ttl_seconds": 0 }