Toms1999 commented on issue #57582:
URL: https://github.com/apache/doris/issues/57582#issuecomment-3471828508
CREATE TABLE `myt_offline_zj_raw_20251030_veri_online_lx_pre` (
`customerId` varchar(65533) NULL,
`logOccurTime` varchar(65533) NULL,
`offCustLevelV1` varchar(65533) NULL,
`offCustLevelV2` varchar(65533) NULL,
`offlineB17bdhThickSeg` varchar(65533) NULL,
`offlineB17bdhSubSeg` varchar(65533) NULL,
`offlineJyPotentialLevelDetailed` varchar(65533) NULL,
`offlineJyPotentialLevel` varchar(65533) NULL,
`offlineDemandLevel` varchar(65533) NULL,
`offlineDemandThinLevel` varchar(65533) NULL,
`offlineCjMerchantLevel` varchar(65533) NULL,
`offlineAllCustType` varchar(65533) NULL,
`offlineAllCustTag` varchar(65533) NULL,
`offlineRisklineTop` decimal(38,9) NULL,
`offlineRisklineDown` decimal(38,9) NULL,
`ageUpperLimit` decimal(38,9) NULL,
`offlineLtiCoef` decimal(38,9) NULL,
`offlineDtiCoef` decimal(38,9) NULL,
`offCustLevelV1Coef` decimal(38,9) NULL,
`offlineDemandLevelCoef` decimal(38,9) NULL,
`jyPotentialLevelCoef` decimal(38,9) NULL,
`bdhmacroCoef` decimal(38,9) NULL,
`offlineRiskline` decimal(38,9) NULL,
`offlineBaselineFinal` decimal(38,9) NULL,
`offlineRiskIrrDown` decimal(38,9) NULL,
`offlineRiskIrrTop` decimal(38,9) NULL,
`offlineJpjyIrrTop` decimal(38,9) NULL,
`offlineElastCoef` decimal(38,9) NULL,
`offlineBaseIrrFinal` decimal(38,9) NULL,
`offlineprofitbymob` decimal(38,9) NULL,
`applyCityMaxCnt` varchar(65533) NULL,
`isDxmMainAccount` varchar(65533) NULL,
`xwIndustryLevel` varchar(65533) NULL,
`zx2ReportDate2` varchar(65533) NULL,
`zx2NewCompany` varchar(65533) NULL,
`zx2Education` varchar(65533) NULL,
`combineFirstIndustry` varchar(65533) NULL,
`zx2WorkChangeTimes` decimal(38,9) NULL,
`zx2CreCardNowShouldPayAmt` decimal(38,9) NULL,
`zx2BlanceShouldPayAmt` decimal(38,9) NULL,
`zx2HouseLoan1MAvgPayAmt` decimal(38,9) NULL,
`zx2DxmThisMonRepayAmtSum` decimal(38,9) NULL,
`offlineSenLevel` varchar(65533) NULL,
`min_jp_price` decimal(38,9) NULL,
`min_jp_price_zx` decimal(38,9) NULL,
`JxjRevenue` decimal(38,9) NULL,
`JXJLoanContinueDaysF` decimal(38,9) NULL,
`jxjUserLoseDays` decimal(38,9) NULL,
`DhMaxJpLimit` decimal(38,9) NULL,
`age` decimal(38,9) NULL,
`balancePotentialModelV1Prob` decimal(38,9) NULL,
`offlineOldCustTag` decimal(38,9) NULL,
`primaryAccountDxmWalletPart` decimal(38,9) NULL,
`lastFirstClassName` varchar(65533) NULL,
`lastTransDate` varchar(65533) NULL,
`nowToLstTransBin` varchar(65533) NULL,
`l6mLatestTransAmt` decimal(38,9) NULL,
`l6mTransDays` decimal(38,9) NULL,
`jxjM2Balance` decimal(38,9) NULL,
`offlineAdjPriceNegCust` varchar(65533) NULL,
`CPImidFee1` varchar(65533) NULL,
`CPImidFee3` varchar(65533) NULL,
`preCPIFee` decimal(38,9) NULL,
`pdPriceUpFinalinterest` decimal(38,9) NULL,
`pdPriceUpControlTag` varchar(65533) NULL,
`productType` varchar(65533) NULL,
`pidRepayTypeList` varchar(65533) NULL,
`plmPriceCodeType` varchar(65533) NULL,
`plmPriceReasonCode` varchar(65533) NULL,
`dhAdjustLockTestFlag` varchar(65533) NULL,
`plmPriceReasonDesc` varchar(65533) NULL,
`priceLobType` varchar(65533) NULL,
`repayTypeMode` varchar(65533) NULL,
`repayType` varchar(65533) NULL,
`period` varchar(65533) NULL,
`afterInterest` varchar(65533) NULL,
`CLDmidline1` varchar(65533) NULL,
`CLDmidline3` varchar(65533) NULL,
`preCLDline` varchar(65533) NULL,
`offlineAdjPermittag` varchar(65533) NULL,
`offlineAdjLimitNegCust` varchar(65533) NULL,
`FinalLimitDownJXJ` varchar(65533) NULL,
`limitDownShiyanFlag` varchar(65533) NULL,
`ifPlmRedLimit` varchar(65533) NULL,
`plmCreditLimit` varchar(65533) NULL,
`redLimitType` varchar(65533) NULL,
`dhCldownTestFlag` varchar(65533) NULL,
`lastReduceJXJDate` varchar(65533) NULL,
`lastEnhanceJXJDate` varchar(65533) NULL,
`dhLaBefAdjPriceDir` varchar(65533) NULL,
`dhLaBefAdjPriceTime` varchar(65533) NULL,
`limitDownDate` varchar(65533) NULL,
`lastgrantRiskLineJXJDate` varchar(65533) NULL,
`lastTransReduceLimitDate` varchar(65533) NULL,
`limitUpDate` varchar(65533) NULL,
`oldAdjustTime` varchar(65533) NULL,
`lastEnLimitTime` varchar(65533) NULL,
`lastAdjustPriceSucTime` varchar(65533) NULL,
`priceDownDate` varchar(65533) NULL,
`priceUpDateFinal` varchar(65533) NULL,
`ifPlmAdjustPriceConditions` varchar(65533) NULL,
`pre1mDhSeg` varchar(65533) NULL,
`pre2mDhSeg` varchar(65533) NULL,
`pre3mDhSeg` varchar(65533) NULL,
`dhPriceChangeTestFlag` varchar(65533) NULL,
`finalPriceAction` varchar(65533) NULL,
`interestRange` varchar(65533) NULL,
`tempPriceAdjustRange` varchar(65533) NULL,
`did` varchar(65533) NULL,
`currAccountLimit` decimal(42,13) NULL,
`mid_custstatus` varchar(65533) NULL,
`mob_band` text NULL,
`transactionId` varchar(65533) NULL,
`userHandOutMode` varchar(65533) NULL,
`customerLabels` varchar(65533) NULL,
`ppsCustIsFgMode` varchar(65533) NULL,
`noAdjustCustGroupCodeSvc` varchar(65533) NULL,
`noAdjustTypeSvc` varchar(65533) NULL,
`whiteListType` varchar(65533) NULL,
`relaselfTag` varchar(65533) NULL,
`isBusinessCust` varchar(65533) NULL,
`ifInAutiMoneyBackList` varchar(65533) NULL,
`isSupportDxmQuotaAdjust` varchar(65533) NULL,
`pidLimitUsedRate` decimal(38,9) NULL,
`ifRiskAttent` varchar(65533) NULL,
`cur_postLoanLevelF` varchar(65533) NULL,
`plmTransRiscode` varchar(65533) NULL,
`reLaJXJpoolHlgroup` varchar(65533) NULL,
`avaMaxLimit` varchar(65533) NULL,
`ifCharityUser` varchar(65533) NULL,
`ifPlmUnderpin` varchar(65533) NULL,
`ifPlmReInterest` varchar(65533) NULL,
`userMinFinallyInterestNoTmp` varchar(65533) NULL,
`tempPriceEndDate` varchar(65533) NULL,
`jsJxjPriceCode` varchar(65533) NULL,
`allMaxFinallyInterest` decimal(38,9) NULL,
`offCustTransReasonCodeD` varchar(65533) NULL,
`balancePotentialV4` varchar(65533) NULL,
`clearChurnModelV1Dtd` varchar(65533) NULL,
`cz3IncomeOri` varchar(65533) NULL,
`offlineB13ThinSeg` varchar(65533) NULL,
`offlineB13ThickSeg` varchar(65533) NULL,
`dhCustomerType` varchar(65533) NULL,
`ifPlmAdjustPriceNameList` varchar(65533) NULL,
`priceAdjustType` varchar(65533) NULL,
`plmPriceTemplate` varchar(65533) NULL,
`offlineCombB17Fico` decimal(38,9) NULL,
`inloanLe3ChurnModelV1Dtd` decimal(38,9) NULL,
`maxRemainingPeriod` decimal(38,9) NULL,
`isIPCCustomer` decimal(38,9) NULL,
`jingpinMinPriceTemp` decimal(38,9) NULL,
`lastUserClearTime` varchar(65533) NULL,
`tempPriceStartDate` varchar(65533) NULL,
`lastAdjPriceDirNotContainTemp` varchar(65533) NULL,
`lastAdjPriceTimeNotContainTemp` varchar(65533) NULL,
`latestCouponUseDate` varchar(65533) NULL,
`ifDiffPage` varchar(65533) NULL,
`ifInRefuseList` varchar(65533) NULL,
`lastRejTime` varchar(65533) NULL,
`lastPassTime` varchar(65533) NULL,
`lastReducePriceCallBack` varchar(65533) NULL,
`lastLoanIfEarlyClear` varchar(65533) NULL,
`lastOfflineTempPriceDownDate` varchar(65533) NULL,
`pdPriceDownFinalinterest_exp` decimal(38,9) NULL,
`offlinePriceDownBranch_exp` varchar(65533) NULL,
`offlinePriceDownBranchDetail_exp` varchar(65533) NULL,
`offlineClearReason_exp` varchar(65533) NULL,
`offlineClearType_exp` varchar(65533) NULL,
`offlineAdjLimitPosCust` varchar(65533) NULL,
`offlineAdjPricePosCustst` varchar(65533) NULL,
`preCPDFee_exp` varchar(65533) NULL,
`occurTime` varchar(65533) NULL,
`occurDate` varchar(65533) NULL,
`offlineAdjLimitPosCustSub` varchar(65533) NULL,
`offlineEnLimitBranch` varchar(65533) NULL,
`preCLULine` varchar(65533) NULL,
`FinalLimitUpJXJ` varchar(65533) NULL,
`ifPlmEnhLimit` varchar(65533) NULL,
`limitUpShiyanFlag` varchar(65533) NULL,
`enhanceLimitType` varchar(65533) NULL,
`postloanAmountV3finalAmt` decimal(38,9) NULL,
`pdControlTag` varchar(65533) NULL,
`batchNo` varchar(65533) NULL,
`pre3mZx2ReportDate2` varchar(65533) NULL,
`pre3mDhMaxJpLimit` varchar(65533) NULL,
`offlineB14ThinSeg` varchar(65533) NULL,
`offlineB14ThickSeg` varchar(65533) NULL,
`offlineLast360dBankTrendStrictIdentProAmtRise` decimal(38,9) NULL,
`offlineB15ThinSeg` varchar(65533) NULL,
`offlineB15ThickSeg` varchar(65533) NULL,
`offlineB16ThinSeg` varchar(65533) NULL,
`offlineB16ThickSeg` varchar(65533) NULL,
`offlineB17ThinSeg` varchar(65533) NULL,
`offlineB17ThickSeg` varchar(65533) NULL,
`churnAttrV3DemandScore` varchar(65533) NULL,
`pre3mZxMainJpAmount` varchar(65533) NULL,
`lastOfflineCompeteTempPriceDownDate` varchar(65533) NULL,
`zxMainJpMaxAmount` varchar(65533) NULL,
`jinshiLastestPriceCode` varchar(65533) NULL,
`cz3TaxInvoiceIncome` decimal(38,9) NULL,
`cz3WsSalIncome` decimal(38,9) NULL,
`cz3gsIncome` decimal(38,9) NULL,
`relVerUserIncomeGL` decimal(38,9) NULL,
`verAnnualProfitDH` decimal(38,9) NULL,
`cz3ZsIncome` decimal(38,9) NULL,
`cz3ZxgjjIncome` decimal(38,9) NULL,
`cz3OrIncome` decimal(38,9) NULL,
`cz3WsBusIncome` decimal(38,9) NULL,
`cz3WzIncome` decimal(38,9) NULL,
`cz3WfqIncome` decimal(38,9) NULL,
`cz3HouseIncome` decimal(38,9) NULL,
`cz3YbxcarIncome` decimal(38,9) NULL,
`cz3FczxIncome` decimal(38,9) NULL,
`cz3EduagecitylowerIncome` decimal(38,9) NULL,
`cz3ModelIncome` decimal(38,9) NULL,
`cz3LyIncome` decimal(38,9) NULL,
`cz3BnkIncome` decimal(38,9) NULL,
`cz3AliPayIncome` decimal(38,9) NULL,
`cz3WechatIncome` decimal(38,9) NULL,
`cz3bankSalaryIncome` decimal(38,9) NULL,
`cz3JyIncome` decimal(38,9) NULL,
`zxMainJpMinPrice` decimal(38,9) NULL,
`zsysInvestEntList` varchar(65533) NULL,
`zsysInvestEntCodeList` varchar(65533) NULL,
`cz3IncomeSource` varchar(65533) NULL,
`bw12mInoviceAmt` varchar(65533) NULL,
`bwPlmUpdateTime` varchar(65533) NULL,
`zsysEpRank` varchar(65533) NULL,
`zsysPeRank` varchar(65533) NULL,
`zsysInterestRate` varchar(65533) NULL,
`zsysInvoiceRate` varchar(65533) NULL,
`ifPlmUnderpinAndReInterest` varchar(65533) NULL,
`adBasePassTag` varchar(65533) NULL,
`isYSZS` varchar(65533) NULL,
`relaCurrCity` varchar(65533) NULL,
`zsysGdEntType` varchar(65533) NULL,
`zsysFrEntType` varchar(65533) NULL,
`zsysGgEntType` varchar(65533) NULL,
`zsysGgEntStatus` varchar(65533) NULL,
`zsysFrEntStatus` varchar(65533) NULL,
`jingpinMinPriceZXNew` decimal(38,9) NULL,
`onPostLoanPriceV1At90PayScoreW05` decimal(38,9) NULL,
`onPostLoanPriceV1At90InloanScoreW05` decimal(38,9) NULL,
`cz3BhylIncome` decimal(38,9) NULL,
`relLastwfqInvoicesXx12mValidAmountNew` decimal(38,9) NULL,
`wfqInvoicesXx12mValidAmountNew` decimal(38,9) NULL,
`top1OrgAmt` decimal(38,9) NULL,
`top2OrgAmt` decimal(38,9) NULL,
`bdhAllNetFlow` decimal(38,9) NULL,
`offlinebankStatementLast180DAvgDailyBalance` decimal(38,9) NULL,
`offlineLsValid` decimal(38,9) NULL,
`bankStatementLast180DAvgDailyBalance` decimal(38,9) NULL,
`wechatBusIncomeFinalV2` decimal(38,9) NULL,
`wechatBusExpenseFinalV2` decimal(38,9) NULL,
`bankStatementEndTimeList` varchar(65533) NULL,
`wechatBillEndTime` varchar(65533) NULL,
`last360dBBankTrendStrictIdentProAmtRise` decimal(38,9) NULL,
`bankStatementLast180DBigStrictIdentifiedRevAmt` decimal(38,9) NULL,
`aliPay12MonIdentifyIncomeAvgAmt` decimal(38,9) NULL,
`offlineBankCustSeg` varchar(65533) NULL,
`offlineBankCustThinSeg` varchar(65533) NULL,
`batchDate` varchar(65533) NULL,
`offlineBankStatementEndTimeList` varchar(65533) NULL,
`offlineWechatBillEndTime` varchar(65533) NULL,
`offlinePreSettleNum` decimal(38,9) NULL,
`offlineLoanNum` decimal(38,9) NULL,
`offlineJpKind` varchar(65533) NULL,
`last3mLimitAdvTrans` varchar(65533) NULL,
`expectAdjustLimitExpireTime` varchar(65533) NULL,
`tempExpireTime` varchar(65533) NULL,
`tempLimitDateFinal` varchar(65533) NULL,
`jxjLoanContinueDaysBdh` decimal(38,9) NULL,
`relPreACustSegJXJ` varchar(65533) NULL,
`offlineAllCustChannel` varchar(65533) NULL,
`offlineBigJyCustSegThin` varchar(65533) NULL,
`offlineBankJyCust` varchar(65533) NULL,
`offlineBigJyCustSeg` varchar(65533) NULL,
`offlineBigAdjPermittag` varchar(65533) NULL,
`tagTop1BankAmt` decimal(38,9) NULL,
`tagTop2BankAmt` decimal(38,9) NULL,
`demandBinV1OuterScore` decimal(38,9) NULL,
`demandBinV1InnerScore` decimal(38,9) NULL,
`lobType` varchar(65533) NULL,
`relateLastLoanShopTag` varchar(65533) NULL,
`isBindValid` varchar(65533) NULL,
`violatePrepayTermsFW03` varchar(65533) NULL,
`repayType32Periods` varchar(65533) NULL,
`airFlowType` varchar(65533) NULL,
`offlineCustTagBdh` varchar(65533) NULL,
`tempPriceCodeValid` varchar(65533) NULL,
`offerVersion` varchar(65533) NULL,
`lifeCycleCustomerOwnership` varchar(65533) NULL,
`isSupportDxmPriceAdjust` varchar(65533) NULL,
`xxhbFixedPriceBeforeAdjustPeriodNRT` varchar(65533) NULL,
`relCreditXxhbTime` varchar(65533) NULL,
`lastUserGrantXxhbTime` varchar(65533) NULL,
`userCurPidRepayTypeList` varchar(65533) NULL,
`userCurPeriod` varchar(65533) NULL,
`userCurAfterInterest` varchar(65533) NULL,
`offlineXxhbHsKind` varchar(65533) NULL,
`xxhbOpenControlTag` varchar(65533) NULL,
`xxhbContrastDateFinal` varchar(65533) NULL,
`xxhbContrastDateRealTime` varchar(65533) NULL,
`xxhbContrastDate` varchar(65533) NULL,
`lastPostLoanXxhbDate` varchar(65533) NULL,
`lastestAdjustUpTimeContainTemp` varchar(65533) NULL,
`postloanLTVModelV2LtvScorePostLoan` decimal(38,9) NULL,
`diOccupationLabelRecommendOccupationPostLoan` varchar(65533) NULL,
`offlineJpMinPriceTotal` varchar(65533) NULL,
`offlineJpMaxLimitTotal` varchar(65533) NULL,
`offlineJpMinPriceKind` varchar(65533) NULL,
`currentTPriceEffectiveReduction` varchar(65533) NULL,
`currentTPriceEffectiveDuration` varchar(65533) NULL,
`currentTPriceEffectiveDate` varchar(65533) NULL,
`relLastestApplySuccIsBDH` varchar(65533) NULL,
`relFirstAdjustSuccIsBdh` varchar(65533) NULL,
`offLabelAmodLevel` varchar(65533) NULL,
`offLabelBmodLevel` varchar(65533) NULL,
`offLabelCmodLevel` varchar(65533) NULL,
`offLabelDmodLevel` varchar(65533) NULL,
`offLabelEmodLevel` varchar(65533) NULL,
`offLabelFmodLevel` varchar(65533) NULL,
`zx2Rcy1MLoanQueryCnt` varchar(65533) NULL,
`zx2Loan1MApproved` varchar(65533) NULL,
`offCustTransReasonCodeAll` varchar(65533) NULL,
`currAvailableLimit` varchar(65533) NULL,
`plmLoanLevel` varchar(65533) NULL,
`plmThinLoanLevel` varchar(65533) NULL,
`offlineCustRiskLevel` varchar(65533) NULL,
`offlineCustThinRiskLevel` varchar(65533) NULL,
`postLoanLevelVersion` varchar(65533) NULL,
`forbidDetailReason` varchar(65533) NULL,
`jxjLastClearDate` varchar(65533) NULL,
`isCityCompeteCoreManageCustRisk` varchar(65533) NULL,
`ods_day` date NULL,
`batch_date` varchar(128) NULL,
`if_lx45_08` tinyint NULL,
`if_lx45_09` tinyint NULL
) ENGINE=OLAP
DUPLICATE KEY(`customerId`)
DISTRIBUTED BY RANDOM BUCKETS 100
PROPERTIES (
"replication_allocation" = "tag.location.group_hbb: 2,
tag.location.group_hba: 2",
"min_load_replica_num" = "-1",
"is_being_synced" = "false",
"storage_medium" = "hdd",
"storage_format" = "V2",
"inverted_index_storage_format" = "V1",
"light_schema_change" = "true",
"disable_auto_compaction" = "false",
"enable_single_replica_compaction" = "false",
"group_commit_interval_ms" = "10000",
"group_commit_data_bytes" = "134217728"
);
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
