OBDUMPER如何只导出数据，不导出结构

AntTech_CTIJUU · 2025 年1 月 17 日 09:42

现在没有–columns这个参数了

淇铭 · 2025 年1 月 17 日 10:57

表结构sc_order_ob_test_copy1 提供一下

AntTech_CTIJUU · 2025 年1 月 17 日 13:51

CREATE TABLE sc_order_ob_test_copy1 (
id bigint(20) NOT NULL AUTO_INCREMENT,
authcode bigint(20) DEFAULT NULL,
countprice decimal(19,2) DEFAULT NULL,
createtime datetime NOT NULL,
customertype int(11) DEFAULT NULL,
disable int(11) DEFAULT NULL,
discount decimal(19,2) DEFAULT NULL,
follow_ticket varchar(255) DEFAULT NULL,
follow_ticket_time datetime DEFAULT NULL,
iccard varchar(255) DEFAULT NULL,
invoice_time datetime DEFAULT NULL,
invoice_title varchar(255) DEFAULT NULL,
invoice_type varchar(255) DEFAULT NULL,
is_comment int(11) DEFAULT NULL,
is_invoice int(11) DEFAULT NULL,
isbill int(11) NOT NULL,
mj_coupon_discount decimal(19,2) DEFAULT NULL,
mj_discount decimal(19,2) DEFAULT NULL,
name varchar(255) DEFAULT NULL,
native_orderno varchar(255) DEFAULT NULL,
number decimal(19,2) DEFAULT NULL,
openid varchar(255) DEFAULT NULL,
order_type int(11) DEFAULT NULL,
orderno varchar(255) NOT NULL,
paymoney decimal(19,2) DEFAULT NULL,
payname varchar(255) DEFAULT NULL,
paysource int(11) DEFAULT NULL,
paystatus int(11) DEFAULT NULL,
paystatustime datetime DEFAULT NULL,
paytime datetime DEFAULT NULL,
port varchar(255) DEFAULT NULL,
price decimal(19,2) DEFAULT NULL,
remind varchar(3000) DEFAULT NULL,
sourcetype int(11) DEFAULT NULL,
spid int(11) DEFAULT NULL,
sta_coupon_discount decimal(19,2) DEFAULT NULL,
sta_discount decimal(19,2) DEFAULT NULL,
state int(11) DEFAULT NULL,
taxnumber varchar(255) DEFAULT NULL,
third_content longtext DEFAULT NULL,
third_orderno varchar(255) DEFAULT NULL,
updatetime datetime DEFAULT NULL,
cardid bigint(20) DEFAULT NULL,
class_shift bigint(20) DEFAULT NULL,
gun bigint(20) DEFAULT NULL,
mj_promotionid bigint(20) DEFAULT NULL,
oligasid bigint(20) DEFAULT NULL,
openeruserid bigint(20) DEFAULT NULL,
plateid bigint(20) DEFAULT NULL,
promotionid bigint(20) DEFAULT NULL,
rechargeid bigint(20) DEFAULT NULL,
stationid bigint(20) DEFAULT NULL,
userid bigint(20) DEFAULT NULL,
vcardid bigint(20) DEFAULT NULL,
paylabel varchar(255) DEFAULT NULL,
platform_price decimal(19,2) DEFAULT NULL,
pay_mer_no varchar(255) DEFAULT NULL,
remark text DEFAULT NULL,
univalent decimal(19,2) DEFAULT NULL,
use_balance decimal(19,2) DEFAULT NULL,
use_givebalance decimal(19,2) DEFAULT NULL,
radio_iccard bigint(20) DEFAULT NULL,
finishactivity int(11) DEFAULT NULL,
handle_give int(11) DEFAULT NULL,
pay_promotionid bigint(20) DEFAULT NULL,
pay_pro_discount decimal(19,2) DEFAULT NULL,
handle_share int(11) DEFAULT NULL,
appid bigint(20) DEFAULT NULL,
can_refund_givemoney decimal(19,2) DEFAULT NULL,
can_refund_integral bigint(20) DEFAULT NULL,
can_refund_money decimal(19,2) DEFAULT NULL,
refundmoney decimal(19,2) DEFAULT NULL,
allinpay_orderid bigint(20) DEFAULT NULL,
lasttime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
accountid bigint(20) DEFAULT NULL,
ismessage int(11) DEFAULT NULL,
orderfeesid bigint(20) DEFAULT NULL,
channel int(11) DEFAULT NULL,
pay_mer_appid varchar(255) DEFAULT NULL,
pay_mer_key varchar(3000) DEFAULT NULL,
refundstatus int(11) DEFAULT NULL,
fuelcard varchar(255) DEFAULT NULL,
account varchar(255) DEFAULT NULL,
card varchar(255) DEFAULT NULL,
cardnumber varchar(255) DEFAULT NULL,
classid bigint(20) DEFAULT NULL,
company varchar(255) DEFAULT NULL,
companyid bigint(20) DEFAULT NULL,
csid bigint(20) DEFAULT NULL,
guns int(11) DEFAULT NULL,
icnumber varchar(255) DEFAULT NULL,
integral decimal(19,2) DEFAULT NULL,
iscredit int(11) DEFAULT NULL,
oil varchar(255) DEFAULT NULL,
opener varchar(255) DEFAULT NULL,
platenumber varchar(255) DEFAULT NULL,
station varchar(255) DEFAULT NULL,
user varchar(255) DEFAULT NULL,
ictype int(11) DEFAULT NULL,
fuelid bigint(20) DEFAULT NULL,
linkid bigint(20) DEFAULT NULL,
goods_orderno varchar(255) DEFAULT NULL,
recharge_grouprule bigint(20) DEFAULT NULL,
phonei bigint(20) DEFAULT NULL,
recharge_stationid bigint(20) DEFAULT NULL,
is_sale varchar(255) DEFAULT NULL,
begintime datetime DEFAULT NULL COMMENT ‘提枪时间’,
start_pressure decimal(9,0) DEFAULT NULL,
end_pressure decimal(9,0) DEFAULT NULL,
PRIMARY KEY (id, createtime),
UNIQUE KEY UK_af4dnlqcgv1ruqqmwb7th6n7u (orderno, createtime) BLOCK_SIZE 16384 LOCAL,
KEY lasttime_paystatus (lasttime, paystatus, stationid) BLOCK_SIZE 16384 LOCAL,
KEY order_paytime (paytime, vcardid, paystatus, order_type, stationid) BLOCK_SIZE 16384 LOCAL,
KEY fuelcard (fuelcard) BLOCK_SIZE 16384 LOCAL,
KEY idx_vcardid_ordertype_createtime_number (vcardid, order_type, createtime, number) BLOCK_SIZE 16384 LOCAL,
KEY idx_gun_stationid_paystatus_sourcetype_createtime (gun, stationid, paystatus, sourcetype, createtime) BLOCK_SIZE 16384 LOCAL,
KEY order_create_station (createtime, stationid) BLOCK_SIZE 16384 LOCAL,
KEY sfc (stationid, fuelid, classid) BLOCK_SIZE 16384 LOCAL,
KEY plateid (plateid) BLOCK_SIZE 16384 LOCAL,
KEY idx_stationid_ordertype_paystatus_state_createtime_paymoney (stationid, order_type, paystatus, state, createtime, paymoney) BLOCK_SIZE 16384 LOCAL,
KEY FK5w74p9tsat109r3q5c9xth7ln (appid) BLOCK_SIZE 16384 LOCAL,
KEY FKjufoy2gme1u80mb62q31ecb61 (userid, plateid) BLOCK_SIZE 16384 LOCAL,
KEY idx_gun_stationid_paystatus_state_createtime_orderno (gun, stationid, paystatus, state, createtime, orderno) BLOCK_SIZE 16384 LOCAL,
KEY FKrfhtj7ugwwmteesgcik7tauku (cardid) BLOCK_SIZE 16384 LOCAL,
KEY idx_vcardid_customertype_paystatus_state_createtime_paymoney (vcardid, customertype, paystatus, state, createtime, paymoney) BLOCK_SIZE 16384 LOCAL,
KEY FKm3unsqwq81wq9rneeam63097e (class_shift) BLOCK_SIZE 16384 LOCAL,
KEY idx_vcardid_paystatus_ordertype (vcardid, paystatus, order_type) BLOCK_SIZE 16384 LOCAL
) AUTO_INCREMENT = 116882590 AUTO_INCREMENT_MODE = ‘ORDER’ DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMPRESSION = ‘zstd_1.3.8’ REPLICA_NUM = 1 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0
partition by range columns(createtime)
(partition p2018_q1 values less than (‘2018-04-01 00:00:00’),
partition p2018_q2 values less than (‘2018-07-01 00:00:00’),
partition p2018_q3 values less than (‘2018-10-01 00:00:00’),
partition p2018_q4 values less than (‘2019-01-01 00:00:00’),
partition p2019_q1 values less than (‘2019-04-01 00:00:00’),
partition p2019_q2 values less than (‘2019-07-01 00:00:00’),
partition p2019_q3 values less than (‘2019-10-01 00:00:00’),
partition p2019_q4 values less than (‘2020-01-01 00:00:00’),
partition p2020_q1 values less than (‘2020-04-01 00:00:00’),
partition p2020_q2 values less than (‘2020-07-01 00:00:00’),
partition p2020_q3 values less than (‘2020-10-01 00:00:00’),
partition p2020_q4 values less than (‘2021-01-01 00:00:00’),
partition p2021_q1 values less than (‘2021-04-01 00:00:00’),
partition p2021_q2 values less than (‘2021-07-01 00:00:00’),
partition p2021_q3 values less than (‘2021-10-01 00:00:00’),
partition p2021_q4 values less than (‘2022-01-01 00:00:00’),
partition p2022_q1 values less than (‘2022-04-01 00:00:00’),
partition p2022_q2 values less than (‘2022-07-01 00:00:00’),
partition p2022_q3 values less than (‘2022-10-01 00:00:00’),
partition p2022_q4 values less than (‘2023-01-01 00:00:00’),
partition p2023_q1 values less than (‘2023-04-01 00:00:00’),
partition p2023_q2 values less than (‘2023-07-01 00:00:00’),
partition p2023_q3 values less than (‘2023-10-01 00:00:00’),
partition p2023_q4 values less than (‘2024-01-01 00:00:00’),
partition p2024_q1 values less than (‘2024-04-01 00:00:00’),
partition p2024_q2 values less than (‘2024-07-01 00:00:00’),
partition p2024_q3 values less than (‘2024-10-01 00:00:00’),
partition p2024_q4 values less than (‘2025-01-01 00:00:00’),
partition p2025_q1 values less than (‘2025-04-01 00:00:00’),
partition p2025_q2 values less than (‘2025-07-01 00:00:00’),
partition p2025_q3 values less than (‘2025-10-01 00:00:00’),
partition p2025_q4 values less than (‘2026-01-01 00:00:00’));

淇铭 · 2025 年1 月 17 日 15:03

你好 csv文件数据提供一下我们内部测试一下

AntTech_CTIJUU · 2025 年1 月 17 日 17:44

我是用–auto-column-mapping基本都能导入，只有两条记录好像有问题，加不进去，但是我不知道是那两条，ob-loader-dumper.bad日志里也没找到，csv文件也很大，1个G呢

AntTech_CTIJUU · 2025 年1 月 17 日 18:04

解决了，看到有问题的两条数据了，是因为插入的时间不在某个分区里

淇铭 · 2025 年1 月 20 日 09:16

好的在有问题问答区发帖交流