StartRocks补数据
创建catalog
1 | CREATE EXTERNAL CATALOG hive_catalog0 |
创建parquet文件格式的临时表
1 | create table PAY_TRADECENTER.T_TC_BASE_P |
导入数据
1 | SET query_timeout = 259200; |
删除临时表
1 | drop table PAY_TRADECENTER.T_TC_BASE_P |
PAY_AGGREGATE T_ORDER_EXTERNAL CREATED_AT
PAY_BENEFIT T_BIZ_CMD CREATED_AT
PAY_BENEFIT T_ORDER_BASE CREATED_AT
PAY_BENEFIT T_ORDER_BASE_BENEFIT CREATED_AT
PAY_GATEWAY T_ACQ_AGGREGATE CREATED_AT
PAY_GATEWAY T_ACQ_AGGREGATE_DYNAMIC CREATED_AT
PAY_GATEWAY T_ACQ_NOTIFY CREATED_AT
PAY_GATEWAY T_ACQ_REFUND CREATED_AT
PAY_GATEWAY T_RISK_INFO CREATED_AT
PAY_SETTLE T_SETTLE_ORDER_ACQUIRING TRADE_FINISH_DATE
PAY_SETTLE T_SETTLE_ORDER_RE·FUND TRADE_FINISH_DATE
PAY_TRADECENTER T_BIZ_CMD CREATED_AT
PAY_TRADECENTER T_TC_ACCOUNT_TRANS CREATED_AT
PAY_TRADECENTER T_TC_AGGREGATE_TRANS CREATED_AT
PAY_TRADECENTER T_TC_BASE CREATED_AT
PAY_TRADECENTER T_TC_CHANNEL_MSG CREATED_AT
PAY_TRADECENTER T_TC_CHANNEL_TRANS CREATED_AT
PAY_VERIFY T_VERIFY_BANK_TRANS VERIFY_DATE
PAY_VERIFY T_VERIFY_CHANNEL_COST VERIFY_DATE
PAY_VERIFY T_VERIFY_CHANNEL_TRANS VERIFY_DATE
PAY_VERIFY T_VERIFY_RESULT VERIFY_DATE
– PAY_GATEWAY数据库
PAY_GATEWAY.T_ACQ_AGGREGATE_DYNAMIC 保留一个月
PAY_GATEWAY.T_ACQ_AGGREGATE 保留一个月
PAY_GATEWAY.T_ACQ_NOTIFY 保留一个月
PAY_GATEWAY.T_ACQ_REFUND 保留一个月
PAY_GATEWAY.T_RISK_INFO 保留一个月
PAY_GATEWAY.T_BIZ_CMD 暂不归档
– PAY_TRADECENTER数据库
PAY_TRADECENTER.T_BIZ_CMD 保留一个月
PAY_TRADECENTER.T_TC_ACCOUNT_TRANS 保留一个月
PAY_TRADECENTER.T_TC_AGGREGATE_TRANS 保留一个月
PAY_TRADECENTER.T_TC_BASE 保留一个月
PAY_TRADECENTER.T_TC_CHANNEL_MSG 保留一个月
PAY_TRADECENTER.T_TC_CHANNEL_TRANS 保留一个月
– PAY_AGGREGATE
PAY_AGGREGATE.T_ORDER_EXTERNAL 保留四个月
– PAY_BENEFIT
PAY_BENEFIT.T_ORDER_BASE 保留四个月
PAY_BENEFIT.T_BIZ_CMD 保留四个月
PAY_BENEFIT.T_ORDER_BASE_BENEFIT 保留四个月
---- PAY_VERIFY
PAY_VERIFY.T_VERIFY_RESULT 保留四个月
PAY_VERIFY.T_VERIFY_CHANNEL_TRANS 保留四个月
PAY_VERIFY.T_VERIFY_CHANNEL_COST 保留四个月
PAY_VERIFY.T_VERIFY_BANK_TRANS 保留四个月
– PAY_SETTLE
PAY_SETTLE.T_SETTLE_ORDER_ACQUIRING 保留四个月
PAY_SETTLE.T_SETTLE_ORDER_WITHDRAW 保留四个月
PAY_SETTLE.T_SETTLE_ORDER_REFUND 保留四个月
PAY_SETTLE.T_SETTLE_ORDER_CANCEL 保留四个月