This is an automated email from the ASF dual-hosted git repository.
huajianlan pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 1ce7bf0d46f [fix](coordinator) Fix wrong bucket assignments by nereids
coordinator (#56201)
1ce7bf0d46f is described below
commit 1ce7bf0d46f1815f34dd2183a6dc3e067b7e9fee
Author: 924060929 <[email protected]>
AuthorDate: Fri Sep 19 12:09:42 2025 +0800
[fix](coordinator) Fix wrong bucket assignments by nereids coordinator
(#56201)
fix the bug in nereids coordinator which already fixed in legacy
coordinator by #45365
---
.../distribute/worker/job/BucketScanSource.java | 24 +
.../job/UnassignedScanBucketOlapTableJob.java | 101 +-
...est_colocate_join_with_different_tablets.groovy | 3479 ++++++++++++++++++++
3 files changed, 3588 insertions(+), 16 deletions(-)
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/distribute/worker/job/BucketScanSource.java
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/distribute/worker/job/BucketScanSource.java
index c9fb78db825..5b537a1991f 100644
---
a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/distribute/worker/job/BucketScanSource.java
+++
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/distribute/worker/job/BucketScanSource.java
@@ -24,6 +24,7 @@ import com.google.common.collect.ImmutableList;
import com.google.common.collect.Lists;
import com.google.common.collect.Maps;
+import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;
import java.util.Map.Entry;
@@ -124,6 +125,29 @@ public class BucketScanSource extends ScanSource {
return bucketIndexToScanRanges;
}
+ public BucketScanSource newMergeBucketScanSource(BucketScanSource
bucketScanSource) {
+ BucketScanSource merged = new BucketScanSource(new LinkedHashMap<>());
+ Map<Integer, Map<ScanNode, ScanRanges>> mergeMap =
merged.bucketIndexToScanNodeToTablets;
+ mergeBucketScanSource(mergeMap, this);
+ mergeBucketScanSource(mergeMap, bucketScanSource);
+ return merged;
+ }
+
+ private static void mergeBucketScanSource(
+ Map<Integer, Map<ScanNode, ScanRanges>> mergeMap, BucketScanSource
bucketScanSource) {
+ for (Entry<Integer, Map<ScanNode, ScanRanges>> kv
+ : bucketScanSource.bucketIndexToScanNodeToTablets.entrySet()) {
+ Integer bucketIndex = kv.getKey();
+ Map<ScanNode, ScanRanges> oldScanNodeToRanges = kv.getValue();
+ Map<ScanNode, ScanRanges> newScanNodeToRanges
+ = mergeMap.computeIfAbsent(bucketIndex, k -> new
LinkedHashMap<>());
+ for (Entry<ScanNode, ScanRanges> kv2 :
oldScanNodeToRanges.entrySet()) {
+ ScanRanges scanRanges =
newScanNodeToRanges.computeIfAbsent(kv2.getKey(), k -> new ScanRanges());
+ scanRanges.addScanRanges(kv2.getValue());
+ }
+ }
+ }
+
/** toString */
public void toString(StringBuilder str, String prefix) {
int i = 0;
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/distribute/worker/job/UnassignedScanBucketOlapTableJob.java
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/distribute/worker/job/UnassignedScanBucketOlapTableJob.java
index 8a71e739a71..8c8c46ede41 100644
---
a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/distribute/worker/job/UnassignedScanBucketOlapTableJob.java
+++
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/distribute/worker/job/UnassignedScanBucketOlapTableJob.java
@@ -22,6 +22,7 @@ import org.apache.doris.catalog.MaterializedIndex;
import org.apache.doris.catalog.Partition;
import org.apache.doris.catalog.Replica;
import org.apache.doris.catalog.Tablet;
+import org.apache.doris.common.Pair;
import org.apache.doris.nereids.StatementContext;
import org.apache.doris.nereids.trees.plans.distribute.DistributeContext;
import
org.apache.doris.nereids.trees.plans.distribute.worker.DistributedPlanWorker;
@@ -47,6 +48,7 @@ import com.google.common.collect.Multimap;
import java.util.ArrayList;
import java.util.Collection;
import java.util.Iterator;
+import java.util.LinkedHashMap;
import java.util.LinkedHashSet;
import java.util.List;
import java.util.Map;
@@ -172,31 +174,64 @@ public class UnassignedScanBucketOlapTableJob extends
AbstractUnassignedScanJob
@Override
protected void assignLocalShuffleJobs(ScanSource scanSource, int
instanceNum, List<AssignedJob> instances,
ConnectContext context, DistributedPlanWorker worker) {
- // only generate one instance to scan all data, in this step
- List<ScanSource> assignJoinBuckets = scanSource.parallelize(
- scanNodes, instanceNum
- );
-
- // one scan range generate multiple instances,
- // different instances reference the same scan source
+ /*
+ * Split scan ranges evenly into `parallelExecInstanceNum` instances.
+ *
+ * For a fragment contains co-located join,
+ *
+ * scan (id = 0) -> join build (id = 2)
+ * |
+ * scan (id = 1) -> join probe (id = 2)
+ *
+ * If both of `scan (id = 0)` and `scan (id = 1)` are serial
operators, we will plan local exchanger
+ * after them:
+ *
+ * scan (id = 0) -> local exchange -> join build (id = 2)
+ * |
+ * scan (id = 1) -> local exchange -> join probe (id = 2)
+ *
+ *
+ * And there is another more complicated scenario, for example, `scan
(id = 0)` has 10 partitions and
+ * 3 buckets which means 3 * 10 tablets and `scan (id = 1)` has 3
buckets and no partition which means
+ * 3 tablets totally. If expected parallelism is 8, we will get a
serial scan (id = 0) and a
+ * non-serial scan (id = 1). For this case, we will plan another plan
with local exchange:
+ *
+ * scan (id = 0) -> local exchange -> join build (id = 2)
+ * |
+ * scan (id = 1) -> join probe (id = 2)
+ */
+ Pair<BucketScanSource, BucketScanSource> split =
splitSerialScanSource((BucketScanSource) scanSource);
+ BucketScanSource serialScanSource = split.key();
+ BucketScanSource nonSerialScanSource = split.value();
+
+ List<BucketScanSource> parallelizedSources = (List)
nonSerialScanSource.parallelize(scanNodes, instanceNum);
+ BucketScanSource firstInstanceScanSource = serialScanSource;
+ if (!parallelizedSources.isEmpty()) {
+ firstInstanceScanSource =
serialScanSource.newMergeBucketScanSource(parallelizedSources.get(0));
+ }
int shareScanId = shareScanIdGenerator.getAndIncrement();
+ LocalShuffleBucketJoinAssignedJob firstInstance = new
LocalShuffleBucketJoinAssignedJob(
+ instances.size(), shareScanId, context.nextInstanceId(),
+ this, worker,
+ firstInstanceScanSource,
+
Utils.fastToImmutableSet(firstInstanceScanSource.bucketIndexToScanNodeToTablets.keySet())
+ );
+ instances.add(firstInstance);
- BucketScanSource shareScanSource = (BucketScanSource) scanSource;
- ScanSource emptyShareScanSource = shareScanSource.newEmpty();
-
- for (int i = 0; i < assignJoinBuckets.size(); i++) {
- Set<Integer> assignedJoinBuckets
- = ((BucketScanSource)
assignJoinBuckets.get(i)).bucketIndexToScanNodeToTablets.keySet();
+ for (int i = 1; i < parallelizedSources.size(); i++) {
+ BucketScanSource nonFirstInstanceScanSource =
parallelizedSources.get(i);
LocalShuffleBucketJoinAssignedJob instance = new
LocalShuffleBucketJoinAssignedJob(
instances.size(), shareScanId, context.nextInstanceId(),
this, worker,
- i == 0 ? shareScanSource : emptyShareScanSource,
- Utils.fastToImmutableSet(assignedJoinBuckets)
+ nonFirstInstanceScanSource,
+
Utils.fastToImmutableSet(nonFirstInstanceScanSource.bucketIndexToScanNodeToTablets.keySet())
);
instances.add(instance);
}
- for (int i = assignJoinBuckets.size(); i < instanceNum; ++i) {
+ BucketScanSource shareScanSource = (BucketScanSource) scanSource;
+ ScanSource emptyShareScanSource = shareScanSource.newEmpty();
+ for (int i = instances.size(); i < instanceNum; ++i) {
LocalShuffleBucketJoinAssignedJob instance = new
LocalShuffleBucketJoinAssignedJob(
instances.size(), shareScanId, context.nextInstanceId(),
this, worker, emptyShareScanSource,
@@ -207,6 +242,40 @@ public class UnassignedScanBucketOlapTableJob extends
AbstractUnassignedScanJob
}
}
+ private Pair<BucketScanSource, BucketScanSource>
splitSerialScanSource(BucketScanSource totalScanSource) {
+ Map<Integer, Map<ScanNode, ScanRanges>> serialScanRanges =
Maps.newLinkedHashMap();
+ Map<Integer, Map<ScanNode, ScanRanges>> nonSerialScanRanges =
Maps.newLinkedHashMap();
+ for (ScanNode scanNode : scanNodes) {
+ if (scanNode.isSerialOperator()) {
+ collectScanRanges(totalScanSource, scanNode, serialScanRanges);
+ } else {
+ collectScanRanges(totalScanSource, scanNode,
nonSerialScanRanges);
+ }
+ }
+ return Pair.of(new BucketScanSource(serialScanRanges), new
BucketScanSource(nonSerialScanRanges));
+ }
+
+ private void collectScanRanges(
+ BucketScanSource totalScanSource, ScanNode findScanNode,
Map<Integer, Map<ScanNode, ScanRanges>> result) {
+ Map<Integer, Map<ScanNode, ScanRanges>> bucketIndexToScanNodeToTablets
+ = totalScanSource.bucketIndexToScanNodeToTablets;
+ for (Entry<Integer, Map<ScanNode, ScanRanges>> kv :
bucketIndexToScanNodeToTablets.entrySet()) {
+ Integer bucketIndex = kv.getKey();
+ Map<ScanNode, ScanRanges> scanNodeToRanges = kv.getValue();
+ ScanRanges scanRanges = scanNodeToRanges.get(findScanNode);
+ if (scanRanges != null) {
+ Map<ScanNode, ScanRanges> newScanNodeToRanges
+ = result.computeIfAbsent(bucketIndex, k -> {
+ LinkedHashMap<ScanNode, ScanRanges> mergedRanges =
new LinkedHashMap<>();
+ mergedRanges.put(findScanNode, new ScanRanges());
+ return mergedRanges;
+ });
+ newScanNodeToRanges.computeIfAbsent(findScanNode, scanNode ->
new ScanRanges())
+ .addScanRanges(scanRanges);
+ }
+ }
+ }
+
private boolean shouldFillUpInstances(List<HashJoinNode> hashJoinNodes) {
for (HashJoinNode hashJoinNode : hashJoinNodes) {
if (!hashJoinNode.isBucketShuffle()) {
diff --git
a/regression-test/suites/correctness_p0/test_colocate_join_with_different_tablets.groovy
b/regression-test/suites/correctness_p0/test_colocate_join_with_different_tablets.groovy
index 66183591686..f6914eeb7b4 100644
---
a/regression-test/suites/correctness_p0/test_colocate_join_with_different_tablets.groovy
+++
b/regression-test/suites/correctness_p0/test_colocate_join_with_different_tablets.groovy
@@ -106,4 +106,3483 @@ suite("test_colocate_join_with_different_tablets") {
insert into USR_TLBL_VAL_R1 values(60426, 10000007);
"""
qt_sql """ select * from USR_V_KHZHSJ_ES_POC1 A,USR_TLBL_VAL_R1 B
WHERE A.khid = B.khh order by lbl_id; """
+
+ multi_sql """
+ drop table if exists USR_TLBL_VAL_R;
+
+ drop table if exists USR_V_KHZHSJ_ES_POC;
+
+ CREATE TABLE `USR_TLBL_VAL_R` (
+ `lbl_id` bigint NOT NULL,
+ `khh` bigint NULL,
+ `lbl_clss_id` bigint NULL,
+ `lbl_clss_nm` text NULL,
+ `lbl_type_id` bigint NULL,
+ `lbl_type_name` text NULL,
+ `lbl_nm` text NULL,
+ `lbl_val_id` bigint NULL,
+ `lbl_val_code` text NULL,
+ `lbl_val_name` text NULL,
+ `lbl_val_dsc` text NULL,
+ `jsrq` int NULL
+ ) ENGINE = OLAP DUPLICATE KEY(`lbl_id`, `khh`, `lbl_clss_id`) PARTITION BY
LIST (`lbl_id`) (
+ PARTITION p0
+ VALUES
+ IN ("0"),
+ PARTITION p1
+ VALUES
+ IN ("1"),
+ PARTITION p29
+ VALUES
+ IN ("29"),
+ PARTITION p35
+ VALUES
+ IN ("35"),
+ PARTITION p57
+ VALUES
+ IN ("57"),
+ PARTITION p352
+ VALUES
+ IN ("352"),
+ PARTITION p402
+ VALUES
+ IN ("402"),
+ PARTITION p523
+ VALUES
+ IN ("523"),
+ PARTITION p2347
+ VALUES
+ IN ("2347"),
+ PARTITION p10376
+ VALUES
+ IN ("10376"),
+ PARTITION p42408
+ VALUES
+ IN ("42408"),
+ PARTITION p44410
+ VALUES
+ IN ("44410"),
+ PARTITION p48414
+ VALUES
+ IN ("48414"),
+ PARTITION p50416
+ VALUES
+ IN ("50416"),
+ PARTITION p52418
+ VALUES
+ IN ("52418"),
+ PARTITION p56422
+ VALUES
+ IN ("56422"),
+ PARTITION p60426
+ VALUES
+ IN ("60426"),
+ PARTITION p64430
+ VALUES
+ IN ("64430"),
+ PARTITION p66432
+ VALUES
+ IN ("66432"),
+ PARTITION p70436
+ VALUES
+ IN ("70436"),
+ PARTITION p72438
+ VALUES
+ IN ("72438"),
+ PARTITION p74440
+ VALUES
+ IN ("74440"),
+ PARTITION p78444
+ VALUES
+ IN ("78444"),
+ PARTITION p84450
+ VALUES
+ IN ("84450"),
+ PARTITION p86452
+ VALUES
+ IN ("86452"),
+ PARTITION p88454
+ VALUES
+ IN ("88454"),
+ PARTITION p90456
+ VALUES
+ IN ("90456"),
+ PARTITION p92458
+ VALUES
+ IN ("92458"),
+ PARTITION p94460
+ VALUES
+ IN ("94460"),
+ PARTITION p96462
+ VALUES
+ IN ("96462"),
+ PARTITION p98464
+ VALUES
+ IN ("98464"),
+ PARTITION p100466
+ VALUES
+ IN ("100466"),
+ PARTITION p102468
+ VALUES
+ IN ("102468"),
+ PARTITION p104470
+ VALUES
+ IN ("104470"),
+ PARTITION p106472
+ VALUES
+ IN ("106472"),
+ PARTITION p108474
+ VALUES
+ IN ("108474"),
+ PARTITION p110476
+ VALUES
+ IN ("110476"),
+ PARTITION p112478
+ VALUES
+ IN ("112478"),
+ PARTITION p114480
+ VALUES
+ IN ("114480"),
+ PARTITION p122488
+ VALUES
+ IN ("122488"),
+ PARTITION p124490
+ VALUES
+ IN ("124490"),
+ PARTITION p126492
+ VALUES
+ IN ("126492"),
+ PARTITION p130496
+ VALUES
+ IN ("130496"),
+ PARTITION p134500
+ VALUES
+ IN ("134500"),
+ PARTITION p150516
+ VALUES
+ IN ("150516"),
+ PARTITION p154520
+ VALUES
+ IN ("154520"),
+ PARTITION p158524
+ VALUES
+ IN ("158524"),
+ PARTITION p158525
+ VALUES
+ IN ("158525"),
+ PARTITION p1848141
+ VALUES
+ IN ("1848141"),
+ PARTITION p1848161
+ VALUES
+ IN ("1848161"),
+ PARTITION p1848177
+ VALUES
+ IN ("1848177"),
+ PARTITION p1848197
+ VALUES
+ IN ("1848197"),
+ PARTITION p1848218
+ VALUES
+ IN ("1848218")
+ ) DISTRIBUTED BY HASH(`khh`) BUCKETS 16 PROPERTIES (
+ "replication_allocation" = "tag.location.default: 1",
+ "min_load_replica_num" = "-1",
+ "is_being_synced" = "false",
+ "colocate_with" = "USR_TLBL_VAL_R_group1",
+ "storage_medium" = "hdd",
+ "storage_format" = "V2",
+ "inverted_index_storage_format" = "V2",
+ "light_schema_change" = "true",
+ "disable_auto_compaction" = "false",
+ "binlog.enable" = "false",
+ "binlog.ttl_seconds" = "86400",
+ "binlog.max_bytes" = "9223372036854775807",
+ "binlog.max_history_nums" = "9223372036854775807",
+ "enable_single_replica_compaction" = "false",
+ "group_commit_interval_ms" = "10000",
+ "group_commit_data_bytes" = "134217728"
+ );
+
+ CREATE TABLE `USR_V_KHZHSJ_ES_POC` (
+ `khid` bigint NULL,
+ `khh` bigint NULL,
+ `khxm` text NULL,
+ `zjzh` text NULL,
+ `xyzjzh` text NULL,
+ `yhdm` text NULL,
+ `yhmc` text NULL,
+ `sj` text NULL,
+ `fwsj` text NULL,
+ `dh` text NULL,
+ `email` text NULL,
+ `hundsun` text NULL,
+ `ths` text NULL,
+ `wx` text NULL,
+ `vld_sj` smallint NULL,
+ `vld_email` smallint NULL,
+ `vld_hundsun` smallint NULL,
+ `vld_ths` smallint NULL,
+ `vld_wx` smallint NULL,
+ `yyb` smallint NULL,
+ `yybmc` text NULL,
+ `khyyb` bigint NULL,
+ `khyybmc` text NULL,
+ `khlx` bigint NULL,
+ `khlxmc` text NULL,
+ `ptzh_khrq` int NULL,
+ `rzrq_khrq` int NULL,
+ `ggqq_khrq` int NULL,
+ `jrcp_khrq` int NULL,
+ `khzt` smallint NULL,
+ `khztmc` text NULL,
+ `khfs` bigint NULL,
+ `khfsmc` text NULL,
+ `xhrq` int NULL,
+ `fxcsnl` bigint NULL,
+ `fxcsnlmc` text NULL,
+ `fxph` bigint NULL,
+ `fxphmc` text NULL,
+ `zhfxtz` bigint NULL,
+ `zhfxtzmc` text NULL,
+ `fxdjpcyxq` int NULL,
+ `tzzjb` int NULL,
+ `tzzjbmc` text NULL,
+ `tzzfl` bigint NULL,
+ `tzzflmc` text NULL,
+ `tzzflyxq` int NULL,
+ `tzpz` bigint NULL,
+ `tzpzmc` text NULL,
+ `csrq` int NULL,
+ `csyr` text NULL,
+ `mdrxm` text NULL,
+ `mdrxmmc` text NULL,
+ `phlxfs` text NULL,
+ `phlxfsmc` text NULL,
+ `phlxsj` text NULL,
+ `phlxsjmc` text NULL,
+ `sfktlczh` text NULL,
+ `ktywqx` text NULL,
+ `ktywqxmc` text NULL,
+ `ktywpz` text NULL,
+ `ktywpzmc` text NULL,
+ `yqxkt` text NULL,
+ `yqxktmc` text NULL,
+ `zjlb` bigint NULL,
+ `zjlbmc` text NULL,
+ `zjbh` text NULL,
+ `zjyxq` text NULL,
+ `xb` bigint NULL,
+ `xbmc` text NULL,
+ `rzrq_xypf` decimal(16, 2) NULL,
+ `rzrq_xydj` int NULL,
+ `xydjmc` text NULL,
+ `rzrq_rzsxed` decimal(16, 2) NULL,
+ `rzrq_rqsxed` decimal(16, 2) NULL,
+ `sxzed` decimal(16, 2) NULL,
+ `kyed` decimal(16, 2) NULL,
+ `tzgwmc` text NULL,
+ `khjlmc` text NULL,
+ `fwrymc` text NULL,
+ `zsz` decimal(16, 2) NULL,
+ `ptzh_sz` decimal(16, 2) NULL,
+ `rzrq_sz` decimal(16, 2) NULL,
+ `jrcp_sz` decimal(16, 2) NULL,
+ `ggqq_sz` decimal(16, 2) NULL,
+ `zzjye` decimal(16, 2) NULL,
+ `ptzh_zjye` decimal(16, 2) NULL,
+ `rzrq_zjye` decimal(16, 2) NULL,
+ `ggqq_zjye` decimal(16, 2) NULL,
+ `zzc` decimal(16, 2) NULL,
+ `jzc` decimal(16, 2) NULL,
+ `ptzh_zc` decimal(16, 2) NULL,
+ `ptzh_jzc` decimal(16, 2) NULL,
+ `rzrq_zc` decimal(16, 2) NULL,
+ `rzrq_jzc` decimal(16, 2) NULL,
+ `kybzj` decimal(16, 2) NULL,
+ `rzrq_zfz` decimal(16, 2) NULL,
+ `dbbl` decimal(19, 6) NULL,
+ `ptyjl` decimal(12, 5) NULL,
+ `xyyjl_pt` decimal(12, 5) NULL,
+ `xyyjl_xy` decimal(12, 5) NULL,
+ `ggqq_zc` decimal(16, 2) NULL,
+ `jyy_fzzc` decimal(16, 2) NULL,
+ `jsy_fzzc` decimal(16, 2) NULL,
+ `jbn_fzzc` decimal(16, 2) NULL,
+ `jyn_fzzc` decimal(16, 2) NULL,
+ `ls_fzzc` decimal(16, 2) NULL,
+ `ptzh_jyy_fzzc` decimal(16, 2) NULL,
+ `ptzh_jsy_fzzc` decimal(16, 2) NULL,
+ `ptzh_jbn_fzzc` decimal(16, 2) NULL,
+ `ptzh_jyn_fzzc` decimal(16, 2) NULL,
+ `ptzh_ls_fzzc` decimal(16, 2) NULL,
+ `rzrq_jyy_fzzc` decimal(16, 2) NULL,
+ `rzrq_jsy_fzzc` decimal(16, 2) NULL,
+ `rzrq_jbn_fzzc` decimal(16, 2) NULL,
+ `rzrq_jyn_fzzc` decimal(16, 2) NULL,
+ `rzrq_ls_fzzc` decimal(16, 2) NULL,
+ `jyy_fzzc_rq` int NULL,
+ `jsy_fzzc_rq` int NULL,
+ `jbn_fzzc_rq` int NULL,
+ `jyn_fzzc_rq` int NULL,
+ `ls_fzzc_rq` int NULL,
+ `ptzh_jyy_fzzc_rq` int NULL,
+ `ptzh_jsy_fzzc_rq` int NULL,
+ `ptzh_jbn_fzzc_rq` int NULL,
+ `ptzh_jyn_fzzc_rq` int NULL,
+ `ptzh_ls_fzzc_rq` int NULL,
+ `rzrq_jyy_fzzc_rq` int NULL,
+ `rzrq_jsy_fzzc_rq` int NULL,
+ `rzrq_jbn_fzzc_rq` int NULL,
+ `rzrq_jyn_fzzc_rq` int NULL,
+ `rzrq_ls_fzzc_rq` int NULL,
+ `jyy_fzjzc` decimal(16, 2) NULL,
+ `jsy_fzjzc` decimal(16, 2) NULL,
+ `jbn_fzjzc` decimal(16, 2) NULL,
+ `jyn_fzjzc` decimal(16, 2) NULL,
+ `ls_fzjzc` decimal(16, 2) NULL,
+ `ptzh_jyy_fzjzc` decimal(16, 2) NULL,
+ `ptzh_jsy_fzjzc` decimal(16, 2) NULL,
+ `ptzh_jbn_fzjzc` decimal(16, 2) NULL,
+ `ptzh_jyn_fzjzc` decimal(16, 2) NULL,
+ `ptzh_ls_fzjzc` decimal(16, 2) NULL,
+ `rzrq_jyy_fzjzc` decimal(16, 2) NULL,
+ `rzrq_jsy_fzjzc` decimal(16, 2) NULL,
+ `rzrq_jbn_fzjzc` decimal(16, 2) NULL,
+ `rzrq_jyn_fzjzc` decimal(16, 2) NULL,
+ `rzrq_ls_fzjzc` decimal(16, 2) NULL,
+ `jyy_fzjzc_rq` decimal(16, 2) NULL,
+ `jsy_fzjzc_rq` decimal(16, 2) NULL,
+ `jbn_fzjzc_rq` decimal(16, 2) NULL,
+ `jyn_fzjzc_rq` decimal(16, 2) NULL,
+ `ls_fzjzc_rq` decimal(16, 2) NULL,
+ `ptzh_jyy_fzjzc_rq` decimal(16, 2) NULL,
+ `ptzh_jsy_fzjzc_rq` decimal(16, 2) NULL,
+ `ptzh_jbn_fzjzc_rq` decimal(16, 2) NULL,
+ `ptzh_jyn_fzjzc_rq` decimal(16, 2) NULL,
+ `ptzh_ls_fzjzc_rq` decimal(16, 2) NULL,
+ `rzrq_jyy_fzjzc_rq` decimal(16, 2) NULL,
+ `rzrq_jsy_fzjzc_rq` decimal(16, 2) NULL,
+ `rzrq_jbn_fzjzc_rq` decimal(16, 2) NULL,
+ `rzrq_jyn_fzjzc_rq` decimal(16, 2) NULL,
+ `rzrq_ls_fzjzc_rq` decimal(16, 2) NULL,
+ `jyy_bgzc` decimal(16, 2) NULL,
+ `jsy_bgzc` decimal(16, 2) NULL,
+ `jbn_bgzc` decimal(16, 2) NULL,
+ `jyn_bgzc` decimal(16, 2) NULL,
+ `ls_bgzc` decimal(16, 2) NULL,
+ `ptzh_jyy_bgzc` decimal(16, 2) NULL,
+ `ptzh_jsy_bgzc` decimal(16, 2) NULL,
+ `ptzh_jbn_bgzc` decimal(16, 2) NULL,
+ `ptzh_jyn_bgzc` decimal(16, 2) NULL,
+ `ptzh_ls_bgzc` decimal(16, 2) NULL,
+ `rzrq_jyy_bgzc` decimal(16, 2) NULL,
+ `rzrq_jsy_bgzc` decimal(16, 2) NULL,
+ `rzrq_jbn_bgzc` decimal(16, 2) NULL,
+ `rzrq_jyn_bgzc` decimal(16, 2) NULL,
+ `rzrq_ls_bgzc` decimal(16, 2) NULL,
+ `jyy_bgzc_rq` decimal(16, 2) NULL,
+ `jsy_bgzc_rq` decimal(16, 2) NULL,
+ `jbn_bgzc_rq` decimal(16, 2) NULL,
+ `jyn_bgzc_rq` decimal(16, 2) NULL,
+ `ls_bgzc_rq` decimal(16, 2) NULL,
+ `ptzh_jyy_bgzc_rq` decimal(16, 2) NULL,
+ `ptzh_jsy_bgzc_rq` decimal(16, 2) NULL,
+ `ptzh_jbn_bgzc_rq` decimal(16, 2) NULL,
+ `ptzh_jyn_bgzc_rq` decimal(16, 2) NULL,
+ `ptzh_ls_bgzc_rq` decimal(16, 2) NULL,
+ `rzrq_jyy_bgzc_rq` decimal(16, 2) NULL,
+ `rzrq_jsy_bgzc_rq` decimal(16, 2) NULL,
+ `rzrq_jbn_bgzc_rq` decimal(16, 2) NULL,
+ `rzrq_jyn_bgzc_rq` decimal(16, 2) NULL,
+ `rzrq_ls_bgzc_rq` decimal(16, 2) NULL,
+ `by_rjzc` decimal(16, 2) NULL,
+ `bn_rjzc` decimal(16, 2) NULL,
+ `jyn_rjzc` decimal(16, 2) NULL,
+ `ptzh_by_rjzc` decimal(16, 2) NULL,
+ `ptzh_bn_rjzc` decimal(16, 2) NULL,
+ `ptzh_jyn_rjzc` decimal(16, 2) NULL,
+ `rzrq_by_rjzc` decimal(16, 2) NULL,
+ `rzrq_bn_rjzc` decimal(16, 2) NULL,
+ `rzrq_jyn_rjzc` decimal(16, 2) NULL,
+ `jrcp_by_rjzc` decimal(16, 2) NULL,
+ `jrcp_bn_rjzc` decimal(16, 2) NULL,
+ `jrcp_jyn_rjzc` decimal(16, 2) NULL,
+ `ggqq_by_rjzc` decimal(16, 2) NULL,
+ `ggqq_bn_rjzc` decimal(16, 2) NULL,
+ `ggqq_jyn_rjzc` decimal(16, 2) NULL,
+ `sz_zcjlr` decimal(16, 2) NULL,
+ `bz_zcjlr` decimal(16, 2) NULL,
+ `sy_zcjlr` decimal(16, 2) NULL,
+ `by_zcjlr` decimal(16, 2) NULL,
+ `jyn_zcjlr` decimal(16, 2) NULL,
+ `jyy_zcjlr` decimal(16, 2) NULL,
+ `sn_zcjlr` decimal(16, 2) NULL,
+ `bn_zcjlr` decimal(16, 2) NULL,
+ `ptzh_sz_zcjlr` decimal(16, 2) NULL,
+ `ptzh_bz_zcjlr` decimal(16, 2) NULL,
+ `ptzh_sy_zcjlr` decimal(16, 2) NULL,
+ `ptzh_by_zcjlr` decimal(16, 2) NULL,
+ `ptzh_jyn_zcjlr` decimal(16, 2) NULL,
+ `ptzh_jyy_zcjlr` decimal(16, 2) NULL,
+ `ptzh_sn_zcjlr` decimal(16, 2) NULL,
+ `ptzh_bn_zcjlr` decimal(16, 2) NULL,
+ `rzrq_sz_zcjlr` decimal(16, 2) NULL,
+ `rzrq_bz_zcjlr` decimal(16, 2) NULL,
+ `rzrq_sy_zcjlr` decimal(16, 2) NULL,
+ `rzrq_by_zcjlr` decimal(16, 2) NULL,
+ `rzrq_jyn_zcjlr` decimal(16, 2) NULL,
+ `rzrq_jyy_zcjlr` decimal(16, 2) NULL,
+ `rzrq_sn_zcjlr` decimal(16, 2) NULL,
+ `rzrq_bn_zcjlr` decimal(16, 2) NULL,
+ `sz_ykl` decimal(22, 6) NULL,
+ `bz_ykl` decimal(22, 6) NULL,
+ `sy_ykl` decimal(22, 6) NULL,
+ `by_ykl` decimal(22, 6) NULL,
+ `jyn_ykl` decimal(22, 6) NULL,
+ `sn_ykl` decimal(22, 6) NULL,
+ `bn_ykl` decimal(22, 6) NULL,
+ `ptzh_sz_ykl` decimal(22, 6) NULL,
+ `ptzh_bz_ykl` decimal(22, 6) NULL,
+ `ptzh_sy_ykl` decimal(22, 6) NULL,
+ `ptzh_by_ykl` decimal(22, 6) NULL,
+ `ptzh_jyn_ykl` decimal(22, 6) NULL,
+ `ptzh_sn_ykl` decimal(22, 6) NULL,
+ `ptzh_bn_ykl` decimal(22, 6) NULL,
+ `rzrq_sz_ykl` decimal(22, 6) NULL,
+ `rzrq_bz_ykl` decimal(22, 6) NULL,
+ `rzrq_sy_ykl` decimal(22, 6) NULL,
+ `rzrq_by_ykl` decimal(22, 6) NULL,
+ `rzrq_jyn_ykl` decimal(22, 6) NULL,
+ `rzrq_sn_ykl` decimal(22, 6) NULL,
+ `rzrq_bn_ykl` decimal(22, 6) NULL,
+ `cw` decimal(16, 2) NULL,
+ `ptzh_cw` decimal(16, 2) NULL,
+ `rzrq_cw` decimal(16, 2) NULL,
+ `sz_jyl` decimal(16, 2) NULL,
+ `bz_jyl` decimal(16, 2) NULL,
+ `sy_jyl` decimal(16, 2) NULL,
+ `by_jyl` decimal(16, 2) NULL,
+ `jyn_jyl` decimal(16, 2) NULL,
+ `sn_jyl` decimal(16, 2) NULL,
+ `bn_jyl` decimal(16, 2) NULL,
+ `ptzh_sz_jyl` decimal(16, 2) NULL,
+ `ptzh_bz_jyl` decimal(16, 2) NULL,
+ `ptzh_sy_jyl` decimal(16, 2) NULL,
+ `ptzh_by_jyl` decimal(16, 2) NULL,
+ `ptzh_jyn_jyl` decimal(16, 2) NULL,
+ `ptzh_sn_jyl` decimal(16, 2) NULL,
+ `ptzh_bn_jyl` decimal(16, 2) NULL,
+ `rzrq_sz_jyl` decimal(16, 2) NULL,
+ `rzrq_bz_jyl` decimal(16, 2) NULL,
+ `rzrq_sy_jyl` decimal(16, 2) NULL,
+ `rzrq_by_jyl` decimal(16, 2) NULL,
+ `rzrq_jyn_jyl` decimal(16, 2) NULL,
+ `rzrq_sn_jyl` decimal(16, 2) NULL,
+ `rzrq_bn_jyl` decimal(16, 2) NULL,
+ `sz_jyl_mr` decimal(16, 2) NULL,
+ `bz_jyl_mr` decimal(16, 2) NULL,
+ `sy_jyl_mr` decimal(16, 2) NULL,
+ `by_jyl_mr` decimal(16, 2) NULL,
+ `jyn_jyl_mr` decimal(16, 2) NULL,
+ `sn_jyl_mr` decimal(16, 2) NULL,
+ `bn_jyl_mr` decimal(16, 2) NULL,
+ `ptzh_sz_jyl_mr` decimal(16, 2) NULL,
+ `ptzh_bz_jyl_mr` decimal(16, 2) NULL,
+ `ptzh_sy_jyl_mr` decimal(16, 2) NULL,
+ `ptzh_by_jyl_mr` decimal(16, 2) NULL,
+ `ptzh_jyn_jyl_mr` decimal(16, 2) NULL,
+ `ptzh_sn_jyl_mr` decimal(16, 2) NULL,
+ `ptzh_bn_jyl_mr` decimal(16, 2) NULL,
+ `rzrq_sz_jyl_mr` decimal(16, 2) NULL,
+ `rzrq_bz_jyl_mr` decimal(16, 2) NULL,
+ `rzrq_sy_jyl_mr` decimal(16, 2) NULL,
+ `rzrq_by_jyl_mr` decimal(16, 2) NULL,
+ `rzrq_jyn_jyl_mr` decimal(16, 2) NULL,
+ `rzrq_sn_jyl_mr` decimal(16, 2) NULL,
+ `rzrq_bn_jyl_mr` decimal(16, 2) NULL,
+ `sz_jyl_mc` decimal(16, 2) NULL,
+ `bz_jyl_mc` decimal(16, 2) NULL,
+ `sy_jyl_mc` decimal(16, 2) NULL,
+ `by_jyl_mc` decimal(16, 2) NULL,
+ `jyn_jyl_mc` decimal(16, 2) NULL,
+ `sn_jyl_mc` decimal(16, 2) NULL,
+ `bn_jyl_mc` decimal(16, 2) NULL,
+ `ptzh_sz_jyl_mc` decimal(16, 2) NULL,
+ `ptzh_bz_jyl_mc` decimal(16, 2) NULL,
+ `ptzh_sy_jyl_mc` decimal(16, 2) NULL,
+ `ptzh_by_jyl_mc` decimal(16, 2) NULL,
+ `ptzh_jyn_jyl_mc` decimal(16, 2) NULL,
+ `ptzh_sn_jyl_mc` decimal(16, 2) NULL,
+ `ptzh_bn_jyl_mc` decimal(16, 2) NULL,
+ `rzrq_sz_jyl_mc` decimal(16, 2) NULL,
+ `rzrq_bz_jyl_mc` decimal(16, 2) NULL,
+ `rzrq_sy_jyl_mc` decimal(16, 2) NULL,
+ `rzrq_by_jyl_mc` decimal(16, 2) NULL,
+ `rzrq_jyn_jyl_mc` decimal(16, 2) NULL,
+ `rzrq_sn_jyl_mc` decimal(16, 2) NULL,
+ `rzrq_bn_jyl_mc` decimal(16, 2) NULL,
+ `sz_yj` decimal(16, 2) NULL,
+ `bz_yj` decimal(16, 2) NULL,
+ `sy_yj` decimal(16, 2) NULL,
+ `by_yj` decimal(16, 2) NULL,
+ `jyn_yj` decimal(16, 2) NULL,
+ `sn_yj` decimal(16, 2) NULL,
+ `bn_yj` decimal(16, 2) NULL,
+ `ptzh_sz_yj` decimal(16, 2) NULL,
+ `ptzh_bz_yj` decimal(16, 2) NULL,
+ `ptzh_sy_yj` decimal(16, 2) NULL,
+ `ptzh_by_yj` decimal(16, 2) NULL,
+ `ptzh_jyn_yj` decimal(16, 2) NULL,
+ `ptzh_sn_yj` decimal(16, 2) NULL,
+ `ptzh_bn_yj` decimal(16, 2) NULL,
+ `rzrq_sz_yj` decimal(16, 2) NULL,
+ `rzrq_bz_yj` decimal(16, 2) NULL,
+ `rzrq_sy_yj` decimal(16, 2) NULL,
+ `rzrq_by_yj` decimal(16, 2) NULL,
+ `rzrq_jyn_yj` decimal(16, 2) NULL,
+ `rzrq_sn_yj` decimal(16, 2) NULL,
+ `rzrq_bn_yj` decimal(16, 2) NULL,
+ `sz_yjl` decimal(22, 6) NULL,
+ `bz_yjl` decimal(22, 6) NULL,
+ `sy_yjl` decimal(22, 6) NULL,
+ `by_yjl` decimal(22, 6) NULL,
+ `ptzh_sz_yjl` decimal(22, 6) NULL,
+ `ptzh_bz_yjl` decimal(22, 6) NULL,
+ `ptzh_sy_yjl` decimal(22, 6) NULL,
+ `ptzh_by_yjl` decimal(22, 6) NULL,
+ `ptzh_jyn_yjl` decimal(22, 6) NULL,
+ `rzrq_sz_yjl` decimal(22, 6) NULL,
+ `rzrq_bz_yjl` decimal(22, 6) NULL,
+ `rzrq_sy_yjl` decimal(22, 6) NULL,
+ `rzrq_by_yjl` decimal(22, 6) NULL,
+ `rzrq_jyn_yjl` decimal(22, 6) NULL,
+ `sz_zzl` decimal(16, 2) NULL,
+ `bz_zzl` decimal(16, 2) NULL,
+ `sy_zzl` decimal(16, 2) NULL,
+ `by_zzl` decimal(16, 2) NULL,
+ `jyn_zzl` decimal(16, 2) NULL,
+ `sn_zzl` decimal(16, 2) NULL,
+ `bn_zzl` decimal(16, 2) NULL,
+ `ptzh_sz_zzl` decimal(16, 2) NULL,
+ `ptzh_bz_zzl` decimal(16, 2) NULL,
+ `ptzh_sy_zzl` decimal(16, 2) NULL,
+ `ptzh_by_zzl` decimal(16, 2) NULL,
+ `ptzh_jyn_zzl` decimal(16, 2) NULL,
+ `ptzh_sn_zzl` decimal(16, 2) NULL,
+ `ptzh_bn_zzl` decimal(16, 2) NULL,
+ `rzrq_sz_zzl` decimal(16, 2) NULL,
+ `rzrq_bz_zzl` decimal(16, 2) NULL,
+ `rzrq_sy_zzl` decimal(16, 2) NULL,
+ `rzrq_by_zzl` decimal(16, 2) NULL,
+ `rzrq_jyn_zzl` decimal(16, 2) NULL,
+ `rzrq_sn_zzl` decimal(16, 2) NULL,
+ `rzrq_bn_zzl` decimal(16, 2) NULL,
+ `sz_jycs` decimal(16, 2) NULL,
+ `bz_jycs` decimal(16, 2) NULL,
+ `sy_jycs` decimal(16, 2) NULL,
+ `by_jycs` decimal(16, 2) NULL,
+ `jyn_jycs` decimal(16, 2) NULL,
+ `sn_jycs` decimal(16, 2) NULL,
+ `bn_jycs` decimal(16, 2) NULL,
+ `ptzh_sz_jycs` decimal(16, 2) NULL,
+ `ptzh_bz_jycs` decimal(16, 2) NULL,
+ `ptzh_sy_jycs` decimal(16, 2) NULL,
+ `ptzh_by_jycs` decimal(16, 2) NULL,
+ `ptzh_jyn_jycs` decimal(16, 2) NULL,
+ `ptzh_sn_jycs` decimal(16, 2) NULL,
+ `ptzh_bn_jycs` decimal(16, 2) NULL,
+ `rzrq_sz_jycs` decimal(16, 2) NULL,
+ `rzrq_bz_jycs` decimal(16, 2) NULL,
+ `rzrq_sy_jycs` decimal(16, 2) NULL,
+ `rzrq_by_jycs` decimal(16, 2) NULL,
+ `rzrq_jyn_jycs` decimal(16, 2) NULL,
+ `rzrq_sn_jycs` decimal(16, 2) NULL,
+ `rzrq_bn_jycs` decimal(16, 2) NULL,
+ `ptzh_zjjyrq` int NULL,
+ `rzrq_zjjyrq` int NULL,
+ `khq` text NULL,
+ `khqmc` text NULL,
+ `jyy_qczc` decimal(16, 2) NULL,
+ `ptzh_jyy_qczc` decimal(16, 2) NULL,
+ `rzrq_jyy_qczc` decimal(16, 2) NULL,
+ `jyy_jyl` decimal(16, 2) NULL,
+ `ptzh_jyy_jyl` decimal(16, 2) NULL,
+ `rzrq_jyy_jyl` decimal(16, 2) NULL,
+ `jyy_jyl_mr` decimal(16, 2) NULL,
+ `ptzh_jyy_jyl_mr` decimal(16, 2) NULL,
+ `rzrq_jyy_jyl_mr` decimal(16, 2) NULL,
+ `jyy_jyl_mc` decimal(16, 2) NULL,
+ `ptzh_jyy_jyl_mc` decimal(16, 2) NULL,
+ `rzrq_jyy_jyl_mc` decimal(16, 2) NULL,
+ `jyy_yj` decimal(16, 2) NULL,
+ `ptzh_jyy_yj` decimal(16, 2) NULL,
+ `rzrq_jyy_yj` decimal(16, 2) NULL,
+ `jyy_zzl` decimal(16, 2) NULL,
+ `ptzh_jyy_zzl` decimal(16, 2) NULL,
+ `rzrq_jyy_zzl` decimal(16, 2) NULL,
+ `jyy_jycs` decimal(16, 2) NULL,
+ `ptzh_jyy_jycs` decimal(16, 2) NULL,
+ `rzrq_jyy_jycs` decimal(16, 2) NULL,
+ `jbn_jycs` int NULL,
+ `ptzh_jbn_jycs` int NULL,
+ `rzrq_jbn_jycs` int NULL,
+ `jbn_zcjlr` decimal(16, 2) NULL,
+ `ptzh_jbn_zcjlr` decimal(16, 2) NULL,
+ `rzrq_jbn_zcjlr` decimal(16, 2) NULL,
+ `jbn_qczc` decimal(16, 2) NULL,
+ `ptzh_jbn_qczc` decimal(16, 2) NULL,
+ `rzrq_jbn_qczc` decimal(16, 2) NULL,
+ `khjl` text NULL,
+ `tzgw` text NULL,
+ `fwry` text NULL,
+ `ggqq_sz_qlc` decimal(16, 2) NULL,
+ `ggqq_sz_ywc` decimal(16, 2) NULL,
+ `rzrq_rzfz` decimal(16, 2) NULL,
+ `rzrq_rqfz` decimal(16, 2) NULL,
+ `rzrq_lxfz` decimal(16, 2) NULL,
+ `ptzh_djje` decimal(16, 2) NULL,
+ `rzrq_djje` decimal(16, 2) NULL,
+ `ggqq_djje` decimal(16, 2) NULL,
+ `jbn_ykl` decimal(22, 6) NULL,
+ `ptzh_jbn_ykl` decimal(22, 6) NULL,
+ `zzchb` decimal(16, 3) NULL,
+ `jylhb` decimal(16, 3) NULL,
+ `jyjhb` decimal(16, 3) NULL,
+ `bn_jyj` decimal(16, 2) NULL,
+ `by_jyj` decimal(16, 2) NULL,
+ `rzll` decimal(9, 6) NULL,
+ `rqll` decimal(9, 6) NULL,
+ `rzlx` decimal(16, 2) NULL,
+ `rzfx` decimal(16, 2) NULL,
+ `rqfysr` decimal(16, 2) NULL,
+ `rqfx` decimal(16, 2) NULL,
+ `yybzj` decimal(16, 2) NULL,
+ `ljqpcs_jyn` int NULL,
+ `jyn_qczc` decimal(16, 2) NULL,
+ `ptzh_jyn_qczc` decimal(16, 2) NULL,
+ `rzrq_jyn_qczc` decimal(16, 2) NULL,
+ `ztzc` decimal(16, 2) NULL,
+ `zqzc` decimal(16, 2) NULL,
+ `sy_rjzc` decimal(16, 2) NULL,
+ `ptzh_sy_rjzc` decimal(16, 2) NULL,
+ `rzrq_sy_rjzc` decimal(16, 2) NULL,
+ `ggqq_sz_ykl` decimal(22, 6) NULL,
+ `ggqq_bz_ykl` decimal(22, 6) NULL,
+ `ggqq_sy_ykl` decimal(22, 6) NULL,
+ `ggqq_by_ykl` decimal(22, 6) NULL,
+ `ggqq_jyy_ykl` decimal(22, 6) NULL,
+ `ggqq_jyn_ykl` decimal(22, 6) NULL,
+ `ggqq_bn_ykl` decimal(22, 6) NULL,
+ `ggqq_sn_ykl` decimal(22, 6) NULL,
+ `jrcp_sz_jyl` decimal(16, 2) NULL,
+ `jrcp_bz_jyl` decimal(16, 2) NULL,
+ `jrcp_sy_jyl` decimal(16, 2) NULL,
+ `jrcp_by_jyl` decimal(16, 2) NULL,
+ `jrcp_jyy_jyl` decimal(16, 2) NULL,
+ `jrcp_jyn_jyl` decimal(16, 2) NULL,
+ `jrcp_sn_jyl` decimal(16, 2) NULL,
+ `jrcp_bn_jyl` decimal(16, 2) NULL,
+ `ggqq_sz_jyl` decimal(16, 2) NULL,
+ `ggqq_bz_jyl` decimal(16, 2) NULL,
+ `ggqq_sy_jyl` decimal(16, 2) NULL,
+ `ggqq_by_jyl` decimal(16, 2) NULL,
+ `ggqq_jyy_jyl` decimal(16, 2) NULL,
+ `ggqq_jyn_jyl` decimal(16, 2) NULL,
+ `ggqq_sn_jyl` decimal(16, 2) NULL,
+ `ggqq_bn_jyl` decimal(16, 2) NULL,
+ `ggqq_bn_jyl_mrkc` decimal(16, 2) NULL,
+ `ggqq_bn_jyl_mrpc` decimal(16, 2) NULL,
+ `ggqq_bn_jyl_mckc` decimal(16, 2) NULL,
+ `ggqq_bn_jyl_mcpc` decimal(16, 2) NULL,
+ `ggqq_sz_yj` decimal(16, 2) NULL,
+ `ggqq_bz_yj` decimal(16, 2) NULL,
+ `ggqq_sy_yj` decimal(16, 2) NULL,
+ `ggqq_by_yj` decimal(16, 2) NULL,
+ `ggqq_jyy_yj` decimal(16, 2) NULL,
+ `ggqq_jyn_yj` decimal(16, 2) NULL,
+ `ggqq_sn_yj` decimal(16, 2) NULL,
+ `ggqq_bn_yj` decimal(16, 2) NULL,
+ `ggqq_bn_jyj` decimal(16, 2) NULL,
+ `ggqq_sz_cjsl` decimal(16, 2) NULL,
+ `ggqq_bz_cjsl` decimal(16, 2) NULL,
+ `ggqq_sy_cjsl` decimal(16, 2) NULL,
+ `ggqq_by_cjsl` decimal(16, 2) NULL,
+ `ggqq_jyy_cjsl` decimal(16, 2) NULL,
+ `ggqq_jyn_cjsl` decimal(16, 2) NULL,
+ `ggqq_bn_cjsl` decimal(16, 2) NULL,
+ `ggqq_sn_cjsl` decimal(16, 2) NULL,
+ `cl1` int NULL,
+ `cl2` int NULL,
+ `cl3` int NULL,
+ `cl4` int NULL,
+ `cl5` int NULL,
+ `cl6` int NULL,
+ `cl7` int NULL,
+ `cl8` int NULL,
+ `cl9` int NULL,
+ `cl10` int NULL,
+ `cl11` int NULL,
+ `cl12` int NULL,
+ `cl13` int NULL,
+ `cl14` int NULL,
+ `cl15` int NULL,
+ `cl16` int NULL,
+ `cl17` int NULL,
+ `cl18` int NULL,
+ `cl19` int NULL,
+ `cl20` int NULL,
+ `cl21` int NULL,
+ `cl22` int NULL,
+ `bn_zjjlr` decimal(16, 2) NULL,
+ `ptzh_bn_zjjlr` decimal(16, 2) NULL,
+ `rzrq_bn_zjjlr` decimal(16, 2) NULL,
+ `rjzzc_20r` decimal(16, 2) NULL,
+ `jyn_yjl` decimal(22, 6) NULL,
+ `bn_zgx` decimal(16, 2) NULL,
+ `bn_xc` decimal(16, 2) NULL,
+ `bn_xf` decimal(16, 2) NULL,
+ `otc_bn_yj` decimal(16, 2) NULL,
+ `bn_yjl` decimal(22, 6) NULL,
+ `ptzh_bn_yjl` decimal(22, 6) NULL,
+ `rzrq_bn_yjl` decimal(22, 6) NULL,
+ `sfktlr` text NULL,
+ `rqlx` decimal(16, 2) NULL,
+ `by_xc` decimal(16, 2) NULL,
+ `by_xf` decimal(16, 2) NULL,
+ `bn_zczzl` decimal(16, 2) NULL,
+ `ptzh_bn_zczzl` decimal(16, 2) NULL,
+ `rzrq_bn_zczzl` decimal(16, 2) NULL,
+ `jyy_zczzl` decimal(16, 2) NULL,
+ `ptzh_jyy_zczzl` decimal(16, 2) NULL,
+ `rzrq_jyy_zczzl` decimal(16, 2) NULL,
+ `jyy_rjzc` decimal(16, 2) NULL,
+ `ptzh_jyy_rjzc` decimal(16, 2) NULL,
+ `rzrq_jyy_rjzc` decimal(16, 2) NULL,
+ `jrcp_jyy_rjzc` decimal(16, 2) NULL,
+ `ggqq_jyy_rjzc` decimal(16, 2) NULL,
+ `gxlx` text NULL,
+ `gxlxmc` text NULL,
+ `dqcycpfl` text NULL,
+ `cjcycpfl` text NULL,
+ `jyy_cjcycpfl` text NULL,
+ `jsy_cjcycpfl` text NULL,
+ `jbn_cjcycpfl` text NULL,
+ `jyn_cjcycpfl` text NULL,
+ `fltzc` decimal(16, 2) NULL,
+ `sn_yjl` decimal(22, 6) NULL,
+ `ptzh_sn_yjl` decimal(22, 6) NULL,
+ `rzrq_sn_yjl` decimal(22, 6) NULL,
+ `xldm` text NULL,
+ `zydm` text NULL,
+ `djje` decimal(16, 2) NULL,
+ `khjb` bigint NULL,
+ `khjbmc` text NULL,
+ `xtbq` text NULL,
+ `jyy_ykl` decimal(22, 6) NULL,
+ `ptzh_jyy_ykl` decimal(22, 6) NULL,
+ `rzrq_jyy_ykl` decimal(22, 6) NULL,
+ `zfz` decimal(16, 2) NULL,
+ `gmbyl` decimal(22, 2) NULL,
+ `smbyl` decimal(22, 2) NULL,
+ `lcbyl` decimal(22, 2) NULL,
+ `bn_rjjzc` decimal(16, 2) NULL,
+ `ptzh_bn_rjjzc` decimal(16, 2) NULL,
+ `rzrq_bn_rjjzc` decimal(16, 2) NULL,
+ `by_rjjzc` decimal(16, 2) NULL,
+ `ptzh_by_rjjzc` decimal(16, 2) NULL,
+ `rzrq_by_rjjzc` decimal(16, 2) NULL,
+ `jyn_rjjzc` decimal(16, 2) NULL,
+ `ptzh_jyn_rjjzc` decimal(16, 2) NULL,
+ `rzrq_jyn_rjjzc` decimal(16, 2) NULL,
+ `jyy_rjjzc` decimal(16, 2) NULL,
+ `ptzh_jyy_rjjzc` decimal(16, 2) NULL,
+ `rzrq_jyy_rjjzc` decimal(16, 2) NULL,
+ `jsy_zcjlr` decimal(16, 2) NULL,
+ `ptzh_jsy_zcjlr` decimal(16, 2) NULL,
+ `rzrq_jsy_zcjlr` decimal(16, 2) NULL,
+ `ry` text NULL,
+ `rymc` text NULL,
+ `sz_zgx` decimal(16, 2) NULL,
+ `sy_zgx` decimal(16, 2) NULL,
+ `sn_zgx` decimal(16, 2) NULL,
+ `bz_zgx` decimal(16, 2) NULL,
+ `by_zgx` decimal(16, 2) NULL,
+ `jyy_zgx` decimal(16, 2) NULL,
+ `jbn_zgx` decimal(16, 2) NULL,
+ `jyn_zgx` decimal(16, 2) NULL,
+ `nl` int NULL,
+ `xlmc` text NULL,
+ `ylqd_short_code` text NULL,
+ `ylqd_name` text NULL,
+ `bn_fzzc` decimal(22, 2) NULL,
+ `sfktptzh` text NULL,
+ `sfktxyzh` text NULL,
+ `sfktqqzh` text NULL,
+ `zjjyrq` text NULL,
+ `tznx` text NULL,
+ `level_one` text NULL,
+ `level_name_tw` text NULL,
+ `level_name_five` text NULL,
+ `level_tw` text NULL,
+ `level_thr` text NULL,
+ `level_four` text NULL,
+ `level_five` text NULL,
+ `level_name_one` text NULL,
+ `level_name_thr` text NULL,
+ `level_name_four` text NULL,
+ `get_customer_source` text NULL,
+ `get_customer_source_name` text NULL,
+ `jjtg` decimal(16, 2) NULL,
+ `wbzcgs` decimal(16, 2) NULL,
+ `jszh` text NULL,
+ `ptzjzh` text NULL,
+ `bmlb` text NULL,
+ `bmmc` text NULL,
+ `zq` text NULL,
+ `zqname` text NULL,
+ `xsg` decimal(16, 2) NULL
+ ) ENGINE = OLAP DUPLICATE KEY(`khid`, `khh`) DISTRIBUTED BY HASH(`khid`)
BUCKETS 16 PROPERTIES (
+ "replication_allocation" = "tag.location.default: 1",
+ "min_load_replica_num" = "-1",
+ "bloom_filter_columns" = "khh",
+ "is_being_synced" = "false",
+ "colocate_with" = "USR_TLBL_VAL_R_group1",
+ "storage_medium" = "hdd",
+ "storage_format" = "V2",
+ "inverted_index_storage_format" = "V2",
+ "light_schema_change" = "true",
+ "disable_auto_compaction" = "false",
+ "binlog.enable" = "false",
+ "enable_single_replica_compaction" = "false"
+ )
+ """
+
+ multi_sql """
+ INSERT INTO
+ USR_V_KHZHSJ_ES_POC (
+ khid,
+ khh,
+ khxm,
+ zjzh,
+ xyzjzh,
+ yhdm,
+ yhmc,
+ sj,
+ fwsj,
+ dh,
+ email,
+ hundsun,
+ ths,
+ wx,
+ vld_sj,
+ vld_email,
+ vld_hundsun,
+ vld_ths,
+ vld_wx,
+ yyb,
+ yybmc,
+ khyyb,
+ khyybmc,
+ khlx,
+ khlxmc,
+ ptzh_khrq,
+ rzrq_khrq,
+ ggqq_khrq,
+ jrcp_khrq,
+ khzt,
+ khztmc,
+ khfs,
+ khfsmc,
+ xhrq,
+ fxcsnl,
+ fxcsnlmc,
+ fxph,
+ fxphmc,
+ zhfxtz,
+ zhfxtzmc,
+ fxdjpcyxq,
+ tzzjb,
+ tzzjbmc,
+ tzzfl,
+ tzzflmc,
+ tzzflyxq,
+ tzpz,
+ tzpzmc,
+ csrq,
+ csyr,
+ mdrxm,
+ mdrxmmc,
+ phlxfs,
+ phlxfsmc,
+ phlxsj,
+ phlxsjmc,
+ sfktlczh,
+ ktywqx,
+ ktywqxmc,
+ ktywpz,
+ ktywpzmc,
+ yqxkt,
+ yqxktmc,
+ zjlb,
+ zjlbmc,
+ zjbh,
+ zjyxq,
+ xb,
+ xbmc,
+ rzrq_xypf,
+ rzrq_xydj,
+ xydjmc,
+ rzrq_rzsxed,
+ rzrq_rqsxed,
+ sxzed,
+ kyed,
+ tzgwmc,
+ khjlmc,
+ fwrymc,
+ zsz,
+ ptzh_sz,
+ rzrq_sz,
+ jrcp_sz,
+ ggqq_sz,
+ zzjye,
+ ptzh_zjye,
+ rzrq_zjye,
+ ggqq_zjye,
+ zzc,
+ jzc,
+ ptzh_zc,
+ ptzh_jzc,
+ rzrq_zc,
+ rzrq_jzc,
+ kybzj,
+ rzrq_zfz,
+ dbbl,
+ ptyjl,
+ xyyjl_pt,
+ xyyjl_xy,
+ ggqq_zc,
+ jyy_fzzc,
+ jsy_fzzc,
+ jbn_fzzc,
+ jyn_fzzc,
+ ls_fzzc,
+ ptzh_jyy_fzzc,
+ ptzh_jsy_fzzc,
+ ptzh_jbn_fzzc,
+ ptzh_jyn_fzzc,
+ ptzh_ls_fzzc,
+ rzrq_jyy_fzzc,
+ rzrq_jsy_fzzc,
+ rzrq_jbn_fzzc,
+ rzrq_jyn_fzzc,
+ rzrq_ls_fzzc,
+ jyy_fzzc_rq,
+ jsy_fzzc_rq,
+ jbn_fzzc_rq,
+ jyn_fzzc_rq,
+ ls_fzzc_rq,
+ ptzh_jyy_fzzc_rq,
+ ptzh_jsy_fzzc_rq,
+ ptzh_jbn_fzzc_rq,
+ ptzh_jyn_fzzc_rq,
+ ptzh_ls_fzzc_rq,
+ rzrq_jyy_fzzc_rq,
+ rzrq_jsy_fzzc_rq,
+ rzrq_jbn_fzzc_rq,
+ rzrq_jyn_fzzc_rq,
+ rzrq_ls_fzzc_rq,
+ jyy_fzjzc,
+ jsy_fzjzc,
+ jbn_fzjzc,
+ jyn_fzjzc,
+ ls_fzjzc,
+ ptzh_jyy_fzjzc,
+ ptzh_jsy_fzjzc,
+ ptzh_jbn_fzjzc,
+ ptzh_jyn_fzjzc,
+ ptzh_ls_fzjzc,
+ rzrq_jyy_fzjzc,
+ rzrq_jsy_fzjzc,
+ rzrq_jbn_fzjzc,
+ rzrq_jyn_fzjzc,
+ rzrq_ls_fzjzc,
+ jyy_fzjzc_rq,
+ jsy_fzjzc_rq,
+ jbn_fzjzc_rq,
+ jyn_fzjzc_rq,
+ ls_fzjzc_rq,
+ ptzh_jyy_fzjzc_rq,
+ ptzh_jsy_fzjzc_rq,
+ ptzh_jbn_fzjzc_rq,
+ ptzh_jyn_fzjzc_rq,
+ ptzh_ls_fzjzc_rq,
+ rzrq_jyy_fzjzc_rq,
+ rzrq_jsy_fzjzc_rq,
+ rzrq_jbn_fzjzc_rq,
+ rzrq_jyn_fzjzc_rq,
+ rzrq_ls_fzjzc_rq,
+ jyy_bgzc,
+ jsy_bgzc,
+ jbn_bgzc,
+ jyn_bgzc,
+ ls_bgzc,
+ ptzh_jyy_bgzc,
+ ptzh_jsy_bgzc,
+ ptzh_jbn_bgzc,
+ ptzh_jyn_bgzc,
+ ptzh_ls_bgzc,
+ rzrq_jyy_bgzc,
+ rzrq_jsy_bgzc,
+ rzrq_jbn_bgzc,
+ rzrq_jyn_bgzc,
+ rzrq_ls_bgzc,
+ jyy_bgzc_rq,
+ jsy_bgzc_rq,
+ jbn_bgzc_rq,
+ jyn_bgzc_rq,
+ ls_bgzc_rq,
+ ptzh_jyy_bgzc_rq,
+ ptzh_jsy_bgzc_rq,
+ ptzh_jbn_bgzc_rq,
+ ptzh_jyn_bgzc_rq,
+ ptzh_ls_bgzc_rq,
+ rzrq_jyy_bgzc_rq,
+ rzrq_jsy_bgzc_rq,
+ rzrq_jbn_bgzc_rq,
+ rzrq_jyn_bgzc_rq,
+ rzrq_ls_bgzc_rq,
+ by_rjzc,
+ bn_rjzc,
+ jyn_rjzc,
+ ptzh_by_rjzc,
+ ptzh_bn_rjzc,
+ ptzh_jyn_rjzc,
+ rzrq_by_rjzc,
+ rzrq_bn_rjzc,
+ rzrq_jyn_rjzc,
+ jrcp_by_rjzc,
+ jrcp_bn_rjzc,
+ jrcp_jyn_rjzc,
+ ggqq_by_rjzc,
+ ggqq_bn_rjzc,
+ ggqq_jyn_rjzc,
+ sz_zcjlr,
+ bz_zcjlr,
+ sy_zcjlr,
+ by_zcjlr,
+ jyn_zcjlr,
+ jyy_zcjlr,
+ sn_zcjlr,
+ bn_zcjlr,
+ ptzh_sz_zcjlr,
+ ptzh_bz_zcjlr,
+ ptzh_sy_zcjlr,
+ ptzh_by_zcjlr,
+ ptzh_jyn_zcjlr,
+ ptzh_jyy_zcjlr,
+ ptzh_sn_zcjlr,
+ ptzh_bn_zcjlr,
+ rzrq_sz_zcjlr,
+ rzrq_bz_zcjlr,
+ rzrq_sy_zcjlr,
+ rzrq_by_zcjlr,
+ rzrq_jyn_zcjlr,
+ rzrq_jyy_zcjlr,
+ rzrq_sn_zcjlr,
+ rzrq_bn_zcjlr,
+ sz_ykl,
+ bz_ykl,
+ sy_ykl,
+ by_ykl,
+ jyn_ykl,
+ sn_ykl,
+ bn_ykl,
+ ptzh_sz_ykl,
+ ptzh_bz_ykl,
+ ptzh_sy_ykl,
+ ptzh_by_ykl,
+ ptzh_jyn_ykl,
+ ptzh_sn_ykl,
+ ptzh_bn_ykl,
+ rzrq_sz_ykl,
+ rzrq_bz_ykl,
+ rzrq_sy_ykl,
+ rzrq_by_ykl,
+ rzrq_jyn_ykl,
+ rzrq_sn_ykl,
+ rzrq_bn_ykl,
+ cw,
+ ptzh_cw,
+ rzrq_cw,
+ sz_jyl,
+ bz_jyl,
+ sy_jyl,
+ by_jyl,
+ jyn_jyl,
+ sn_jyl,
+ bn_jyl,
+ ptzh_sz_jyl,
+ ptzh_bz_jyl,
+ ptzh_sy_jyl,
+ ptzh_by_jyl,
+ ptzh_jyn_jyl,
+ ptzh_sn_jyl,
+ ptzh_bn_jyl,
+ rzrq_sz_jyl,
+ rzrq_bz_jyl,
+ rzrq_sy_jyl,
+ rzrq_by_jyl,
+ rzrq_jyn_jyl,
+ rzrq_sn_jyl,
+ rzrq_bn_jyl,
+ sz_jyl_mr,
+ bz_jyl_mr,
+ sy_jyl_mr,
+ by_jyl_mr,
+ jyn_jyl_mr,
+ sn_jyl_mr,
+ bn_jyl_mr,
+ ptzh_sz_jyl_mr,
+ ptzh_bz_jyl_mr,
+ ptzh_sy_jyl_mr,
+ ptzh_by_jyl_mr,
+ ptzh_jyn_jyl_mr,
+ ptzh_sn_jyl_mr,
+ ptzh_bn_jyl_mr,
+ rzrq_sz_jyl_mr,
+ rzrq_bz_jyl_mr,
+ rzrq_sy_jyl_mr,
+ rzrq_by_jyl_mr,
+ rzrq_jyn_jyl_mr,
+ rzrq_sn_jyl_mr,
+ rzrq_bn_jyl_mr,
+ sz_jyl_mc,
+ bz_jyl_mc,
+ sy_jyl_mc,
+ by_jyl_mc,
+ jyn_jyl_mc,
+ sn_jyl_mc,
+ bn_jyl_mc,
+ ptzh_sz_jyl_mc,
+ ptzh_bz_jyl_mc,
+ ptzh_sy_jyl_mc,
+ ptzh_by_jyl_mc,
+ ptzh_jyn_jyl_mc,
+ ptzh_sn_jyl_mc,
+ ptzh_bn_jyl_mc,
+ rzrq_sz_jyl_mc,
+ rzrq_bz_jyl_mc,
+ rzrq_sy_jyl_mc,
+ rzrq_by_jyl_mc,
+ rzrq_jyn_jyl_mc,
+ rzrq_sn_jyl_mc,
+ rzrq_bn_jyl_mc,
+ sz_yj,
+ bz_yj,
+ sy_yj,
+ by_yj,
+ jyn_yj,
+ sn_yj,
+ bn_yj,
+ ptzh_sz_yj,
+ ptzh_bz_yj,
+ ptzh_sy_yj,
+ ptzh_by_yj,
+ ptzh_jyn_yj,
+ ptzh_sn_yj,
+ ptzh_bn_yj,
+ rzrq_sz_yj,
+ rzrq_bz_yj,
+ rzrq_sy_yj,
+ rzrq_by_yj,
+ rzrq_jyn_yj,
+ rzrq_sn_yj,
+ rzrq_bn_yj,
+ sz_yjl,
+ bz_yjl,
+ sy_yjl,
+ by_yjl,
+ ptzh_sz_yjl,
+ ptzh_bz_yjl,
+ ptzh_sy_yjl,
+ ptzh_by_yjl,
+ ptzh_jyn_yjl,
+ rzrq_sz_yjl,
+ rzrq_bz_yjl,
+ rzrq_sy_yjl,
+ rzrq_by_yjl,
+ rzrq_jyn_yjl,
+ sz_zzl,
+ bz_zzl,
+ sy_zzl,
+ by_zzl,
+ jyn_zzl,
+ sn_zzl,
+ bn_zzl,
+ ptzh_sz_zzl,
+ ptzh_bz_zzl,
+ ptzh_sy_zzl,
+ ptzh_by_zzl,
+ ptzh_jyn_zzl,
+ ptzh_sn_zzl,
+ ptzh_bn_zzl,
+ rzrq_sz_zzl,
+ rzrq_bz_zzl,
+ rzrq_sy_zzl,
+ rzrq_by_zzl,
+ rzrq_jyn_zzl,
+ rzrq_sn_zzl,
+ rzrq_bn_zzl,
+ sz_jycs,
+ bz_jycs,
+ sy_jycs,
+ by_jycs,
+ jyn_jycs,
+ sn_jycs,
+ bn_jycs,
+ ptzh_sz_jycs,
+ ptzh_bz_jycs,
+ ptzh_sy_jycs,
+ ptzh_by_jycs,
+ ptzh_jyn_jycs,
+ ptzh_sn_jycs,
+ ptzh_bn_jycs,
+ rzrq_sz_jycs,
+ rzrq_bz_jycs,
+ rzrq_sy_jycs,
+ rzrq_by_jycs,
+ rzrq_jyn_jycs,
+ rzrq_sn_jycs,
+ rzrq_bn_jycs,
+ ptzh_zjjyrq,
+ rzrq_zjjyrq,
+ khq,
+ khqmc,
+ jyy_qczc,
+ ptzh_jyy_qczc,
+ rzrq_jyy_qczc,
+ jyy_jyl,
+ ptzh_jyy_jyl,
+ rzrq_jyy_jyl,
+ jyy_jyl_mr,
+ ptzh_jyy_jyl_mr,
+ rzrq_jyy_jyl_mr,
+ jyy_jyl_mc,
+ ptzh_jyy_jyl_mc,
+ rzrq_jyy_jyl_mc,
+ jyy_yj,
+ ptzh_jyy_yj,
+ rzrq_jyy_yj,
+ jyy_zzl,
+ ptzh_jyy_zzl,
+ rzrq_jyy_zzl,
+ jyy_jycs,
+ ptzh_jyy_jycs,
+ rzrq_jyy_jycs,
+ jbn_jycs,
+ ptzh_jbn_jycs,
+ rzrq_jbn_jycs,
+ jbn_zcjlr,
+ ptzh_jbn_zcjlr,
+ rzrq_jbn_zcjlr,
+ jbn_qczc,
+ ptzh_jbn_qczc,
+ rzrq_jbn_qczc,
+ khjl,
+ tzgw,
+ fwry,
+ ggqq_sz_qlc,
+ ggqq_sz_ywc,
+ rzrq_rzfz,
+ rzrq_rqfz,
+ rzrq_lxfz,
+ ptzh_djje,
+ rzrq_djje,
+ ggqq_djje,
+ jbn_ykl,
+ ptzh_jbn_ykl,
+ zzchb,
+ jylhb,
+ jyjhb,
+ bn_jyj,
+ by_jyj,
+ rzll,
+ rqll,
+ rzlx,
+ rzfx,
+ rqfysr,
+ rqfx,
+ yybzj,
+ ljqpcs_jyn,
+ jyn_qczc,
+ ptzh_jyn_qczc,
+ rzrq_jyn_qczc,
+ ztzc,
+ zqzc,
+ sy_rjzc,
+ ptzh_sy_rjzc,
+ rzrq_sy_rjzc,
+ ggqq_sz_ykl,
+ ggqq_bz_ykl,
+ ggqq_sy_ykl,
+ ggqq_by_ykl,
+ ggqq_jyy_ykl,
+ ggqq_jyn_ykl,
+ ggqq_bn_ykl,
+ ggqq_sn_ykl,
+ jrcp_sz_jyl,
+ jrcp_bz_jyl,
+ jrcp_sy_jyl,
+ jrcp_by_jyl,
+ jrcp_jyy_jyl,
+ jrcp_jyn_jyl,
+ jrcp_sn_jyl,
+ jrcp_bn_jyl,
+ ggqq_sz_jyl,
+ ggqq_bz_jyl,
+ ggqq_sy_jyl,
+ ggqq_by_jyl,
+ ggqq_jyy_jyl,
+ ggqq_jyn_jyl,
+ ggqq_sn_jyl,
+ ggqq_bn_jyl,
+ ggqq_bn_jyl_mrkc,
+ ggqq_bn_jyl_mrpc,
+ ggqq_bn_jyl_mckc,
+ ggqq_bn_jyl_mcpc,
+ ggqq_sz_yj,
+ ggqq_bz_yj,
+ ggqq_sy_yj,
+ ggqq_by_yj,
+ ggqq_jyy_yj,
+ ggqq_jyn_yj,
+ ggqq_sn_yj,
+ ggqq_bn_yj,
+ ggqq_bn_jyj,
+ ggqq_sz_cjsl,
+ ggqq_bz_cjsl,
+ ggqq_sy_cjsl,
+ ggqq_by_cjsl,
+ ggqq_jyy_cjsl,
+ ggqq_jyn_cjsl,
+ ggqq_bn_cjsl,
+ ggqq_sn_cjsl,
+ cl1,
+ cl2,
+ cl3,
+ cl4,
+ cl5,
+ cl6,
+ cl7,
+ cl8,
+ cl9,
+ cl10,
+ cl11,
+ cl12,
+ cl13,
+ cl14,
+ cl15,
+ cl16,
+ cl17,
+ cl18,
+ cl19,
+ cl20,
+ cl21,
+ cl22,
+ bn_zjjlr,
+ ptzh_bn_zjjlr,
+ rzrq_bn_zjjlr,
+ rjzzc_20r,
+ jyn_yjl,
+ bn_zgx,
+ bn_xc,
+ bn_xf,
+ otc_bn_yj,
+ bn_yjl,
+ ptzh_bn_yjl,
+ rzrq_bn_yjl,
+ sfktlr,
+ rqlx,
+ by_xc,
+ by_xf,
+ bn_zczzl,
+ ptzh_bn_zczzl,
+ rzrq_bn_zczzl,
+ jyy_zczzl,
+ ptzh_jyy_zczzl,
+ rzrq_jyy_zczzl,
+ jyy_rjzc,
+ ptzh_jyy_rjzc,
+ rzrq_jyy_rjzc,
+ jrcp_jyy_rjzc,
+ ggqq_jyy_rjzc,
+ gxlx,
+ gxlxmc,
+ dqcycpfl,
+ cjcycpfl,
+ jyy_cjcycpfl,
+ jsy_cjcycpfl,
+ jbn_cjcycpfl,
+ jyn_cjcycpfl,
+ fltzc,
+ sn_yjl,
+ ptzh_sn_yjl,
+ rzrq_sn_yjl,
+ xldm,
+ zydm,
+ djje,
+ khjb,
+ khjbmc,
+ xtbq,
+ jyy_ykl,
+ ptzh_jyy_ykl,
+ rzrq_jyy_ykl,
+ zfz,
+ gmbyl,
+ smbyl,
+ lcbyl,
+ bn_rjjzc,
+ ptzh_bn_rjjzc,
+ rzrq_bn_rjjzc,
+ by_rjjzc,
+ ptzh_by_rjjzc,
+ rzrq_by_rjjzc,
+ jyn_rjjzc,
+ ptzh_jyn_rjjzc,
+ rzrq_jyn_rjjzc,
+ jyy_rjjzc,
+ ptzh_jyy_rjjzc,
+ rzrq_jyy_rjjzc,
+ jsy_zcjlr,
+ ptzh_jsy_zcjlr,
+ rzrq_jsy_zcjlr,
+ ry,
+ rymc,
+ sz_zgx,
+ sy_zgx,
+ sn_zgx,
+ bz_zgx,
+ by_zgx,
+ jyy_zgx,
+ jbn_zgx,
+ jyn_zgx,
+ nl,
+ xlmc,
+ ylqd_short_code,
+ ylqd_name,
+ bn_fzzc,
+ sfktptzh,
+ sfktxyzh,
+ sfktqqzh,
+ zjjyrq,
+ tznx,
+ level_one,
+ level_name_tw,
+ level_name_five,
+ level_tw,
+ level_thr,
+ level_four,
+ level_five,
+ level_name_one,
+ level_name_thr,
+ level_name_four,
+ get_customer_source,
+ get_customer_source_name,
+ jjtg,
+ wbzcgs,
+ jszh,
+ ptzjzh,
+ bmlb,
+ bmmc,
+ zq,
+ zqname,
+ xsg
+ )
+ VALUES
+ (
+ 10000007,
+ 10000007,
+ 'i1',
+ 'ze',
+ 'ru',
+ '99',
+ 'Yp',
+ 'O3',
+ '6Q',
+ 'zO',
+ 'fN',
+ 'o2',
+ 'yy',
+ 'o3',
+ 45,
+ 77,
+ 42,
+ 72,
+ 41,
+ 8031,
+ 'My',
+ 31,
+ 'vT',
+ 61,
+ 'Yh',
+ 41,
+ 94,
+ 24,
+ 53,
+ 15,
+ 'NB',
+ 80,
+ 'Lr',
+ 97,
+ 36,
+ 'hG',
+ 89,
+ 'Ry',
+ 12,
+ '2u',
+ 87,
+ 63,
+ 'z8',
+ 99,
+ 'aW',
+ 86,
+ 55,
+ 'nY',
+ 28,
+ 'Ky',
+ 'gB',
+ 'b8',
+ 'KU',
+ 'bu',
+ 'bi',
+ 'Tt',
+ 'cj',
+ 'XU',
+ 'Z6',
+ '1K',
+ 'Vc',
+ 'aH',
+ 'kH',
+ 61,
+ 'vL',
+ 'by',
+ 'Fc',
+ 27,
+ 'xj',
+ 7.86,
+ 95,
+ 'BG',
+ 18.80,
+ 55.62,
+ 60.29,
+ 57.93,
+ 'aw',
+ 'Xn',
+ 'hg',
+ 69.85,
+ 83.68,
+ 35.36,
+ 9.70,
+ 10.18,
+ 74.96,
+ 33.74,
+ 62.97,
+ 49.10,
+ 99.00,
+ 48.80,
+ 48.54,
+ 11.99,
+ 23.43,
+ 67.11,
+ 77.83,
+ 87.80,
+ 38.743404,
+ 36.72994,
+ 28.74681,
+ 79.42273,
+ 42.93,
+ 29.43,
+ 55.76,
+ 15.29,
+ 61.75,
+ 75.14,
+ 88.32,
+ 84.97,
+ 81.11,
+ 56.49,
+ 9.70,
+ 14.15,
+ 4.62,
+ 65.77,
+ 7.41,
+ 86.70,
+ 15,
+ 29,
+ 33,
+ 15,
+ 19,
+ 98,
+ 67,
+ 38,
+ 39,
+ 63,
+ 55,
+ 26,
+ 68,
+ 79,
+ 20,
+ 42.99,
+ 66.28,
+ 23.39,
+ 87.57,
+ 28.43,
+ 1.55,
+ 13.47,
+ 61.75,
+ 72.75,
+ 52.18,
+ 63.50,
+ 79.60,
+ 25.38,
+ 1.47,
+ 19.20,
+ 39.56,
+ 3.10,
+ 90.38,
+ 13.95,
+ 56.72,
+ 42.39,
+ 1.61,
+ 83.73,
+ 21.69,
+ 85.27,
+ 64.58,
+ 16.88,
+ 71.14,
+ 78.41,
+ 41.19,
+ 14.52,
+ 37.15,
+ 6.36,
+ 33.11,
+ 2.29,
+ 4.64,
+ 43.66,
+ 43.48,
+ 80.94,
+ 16.83,
+ 65.87,
+ 39.40,
+ 57.80,
+ 27.15,
+ 48.10,
+ 29.22,
+ 58.50,
+ 0.84,
+ 77.66,
+ 44.19,
+ 20.43,
+ 23.15,
+ 42.58,
+ 31.81,
+ 42.14,
+ 86.56,
+ 6.17,
+ 18.10,
+ 11.20,
+ 20.47,
+ 73.76,
+ 86.56,
+ 38.56,
+ 32.27,
+ 86.11,
+ 45.25,
+ 74.00,
+ 21.51,
+ 88.52,
+ 33.78,
+ 60.97,
+ 82.73,
+ 19.32,
+ 59.37,
+ 4.93,
+ 69.80,
+ 22.54,
+ 4.79,
+ 9.75,
+ 19.83,
+ 7.20,
+ 50.27,
+ 49.54,
+ 27.20,
+ 50.11,
+ 33.47,
+ 75.16,
+ 87.21,
+ 68.18,
+ 12.28,
+ 77.71,
+ 79.65,
+ 29.20,
+ 60.42,
+ 47.56,
+ 4.52,
+ 13.34,
+ 21.40,
+ 51.29,
+ 88.560210,
+ 58.322853,
+ 37.664091,
+ 43.822809,
+ 63.817112,
+ 3.728851,
+ 9.512347,
+ 65.477740,
+ 82.234254,
+ 70.276274,
+ 33.321530,
+ 50.831006,
+ 38.990150,
+ 78.336383,
+ 75.418422,
+ 5.143038,
+ 29.575747,
+ 30.300801,
+ 49.744628,
+ 68.114051,
+ 63.340400,
+ 25.31,
+ 68.17,
+ 31.88,
+ 8.99,
+ 59.67,
+ 23.80,
+ 45.99,
+ 6.32,
+ 82.72,
+ 24.76,
+ 58.76,
+ 50.10,
+ 79.10,
+ 87.11,
+ 45.14,
+ 33.54,
+ 8.50,
+ 21.59,
+ 87.14,
+ 25.13,
+ 21.74,
+ 68.15,
+ 79.77,
+ 9.83,
+ 64.13,
+ 44.24,
+ 64.62,
+ 54.50,
+ 8.20,
+ 79.44,
+ 15.78,
+ 88.91,
+ 19.50,
+ 79.57,
+ 75.34,
+ 32.29,
+ 20.56,
+ 77.54,
+ 76.29,
+ 48.62,
+ 53.18,
+ 32.96,
+ 82.25,
+ 89.47,
+ 87.52,
+ 0.14,
+ 0.00,
+ 35.67,
+ 29.10,
+ 9.74,
+ 62.18,
+ 35.30,
+ 62.98,
+ 79.56,
+ 88.36,
+ 26.48,
+ 74.76,
+ 49.19,
+ 69.29,
+ 27.92,
+ 7.39,
+ 59.65,
+ 59.57,
+ 84.13,
+ 70.77,
+ 6.39,
+ 21.72,
+ 68.63,
+ 31.74,
+ 82.29,
+ 88.54,
+ 81.66,
+ 80.00,
+ 62.36,
+ 77.67,
+ 4.30,
+ 4.70,
+ 2.68,
+ 28.90,
+ 24.11,
+ 50.62,
+ 20.44,
+ 2.22,
+ 44.77,
+ 26.63,
+ 70.67,
+ 53.29,
+ 28.220575,
+ 79.203291,
+ 47.205645,
+ 21.378081,
+ 29.926391,
+ 50.704028,
+ 87.651866,
+ 64.869130,
+ 75.931374,
+ 44.696606,
+ 17.553897,
+ 7.392375,
+ 76.436932,
+ 49.768256,
+ 56.44,
+ 1.98,
+ 25.85,
+ 89.78,
+ 41.20,
+ 80.98,
+ 12.72,
+ 42.37,
+ 15.60,
+ 68.22,
+ 72.19,
+ 8.29,
+ 60.10,
+ 90.11,
+ 35.12,
+ 33.34,
+ 12.52,
+ 53.13,
+ 9.76,
+ 51.89,
+ 50.88,
+ 16.55,
+ 87.94,
+ 74.42,
+ 33.16,
+ 25.66,
+ 1.20,
+ 46.40,
+ 66.32,
+ 8.95,
+ 53.35,
+ 49.44,
+ 67.76,
+ 25.91,
+ 82.69,
+ 64.73,
+ 47.88,
+ 55.00,
+ 15.70,
+ 83.42,
+ 88.10,
+ 22.56,
+ 42,
+ 44,
+ 'qj',
+ 'qN',
+ 64.16,
+ 50.80,
+ 50.28,
+ 70.94,
+ 5.79,
+ 81.87,
+ 44.65,
+ 6.10,
+ 29.55,
+ 76.89,
+ 82.87,
+ 48.50,
+ 82.37,
+ 68.81,
+ 31.75,
+ 1.20,
+ 62.78,
+ 67.48,
+ 0.15,
+ 44.42,
+ 58.15,
+ 84,
+ 53,
+ 27,
+ 27.66,
+ 75.78,
+ 79.24,
+ 25.57,
+ 62.78,
+ 8.96,
+ 'Fz',
+ 'Qm',
+ 'Dn',
+ 42.53,
+ 10.44,
+ 15.56,
+ 67.15,
+ 32.92,
+ 21.22,
+ 42.94,
+ 52.30,
+ 22.474554,
+ 71.904748,
+ 37.435,
+ 76.511,
+ 67.912,
+ 81.66,
+ 1.65,
+ 53.251350,
+ 53.907770,
+ 34.57,
+ 49.88,
+ 40.20,
+ 10.48,
+ 45.72,
+ 26,
+ 22.42,
+ 88.46,
+ 62.78,
+ 29.33,
+ 68.84,
+ 66.70,
+ 15.70,
+ 13.00,
+ 80.438743,
+ 32.559955,
+ 68.812553,
+ 75.746583,
+ 68.115640,
+ 78.838187,
+ 52.295686,
+ 5.523116,
+ 32.62,
+ 28.79,
+ 82.53,
+ 31.72,
+ 26.68,
+ 15.87,
+ 59.55,
+ 23.19,
+ 77.60,
+ 22.93,
+ 64.23,
+ 86.55,
+ 65.81,
+ 82.13,
+ 2.60,
+ 49.82,
+ 25.15,
+ 14.14,
+ 85.50,
+ 77.42,
+ 38.53,
+ 77.56,
+ 9.78,
+ 9.37,
+ 84.90,
+ 57.60,
+ 12.00,
+ 7.35,
+ 36.19,
+ 46.92,
+ 26.94,
+ 59.81,
+ 50.80,
+ 76.75,
+ 81.33,
+ 53.25,
+ 29.91,
+ 47,
+ 88,
+ 86,
+ 60,
+ 98,
+ 77,
+ 32,
+ 88,
+ 33,
+ 95,
+ 59,
+ 40,
+ 10,
+ 77,
+ 92,
+ 69,
+ 95,
+ 91,
+ 85,
+ 88,
+ 96,
+ 76,
+ 23.91,
+ 49.42,
+ 44.22,
+ 56.57,
+ 38.341389,
+ 56.86,
+ 76.36,
+ 73.13,
+ 73.41,
+ 74.735003,
+ 68.503920,
+ 74.101693,
+ 'IG',
+ 73.95,
+ 51.27,
+ 65.20,
+ 26.24,
+ 12.94,
+ 64.16,
+ 27.63,
+ 6.89,
+ 79.12,
+ 19.64,
+ 30.88,
+ 17.52,
+ 13.27,
+ 64.90,
+ 'e2',
+ 'Ct',
+ '0C',
+ 'XM',
+ 'cJ',
+ 'ua',
+ '8P',
+ 'wR',
+ 36.56,
+ 3.268491,
+ 54.974659,
+ 31.313915,
+ 'nQ',
+ 'nD',
+ 66.71,
+ 86,
+ 'PH',
+ '3z',
+ 2.694460,
+ 34.394338,
+ 59.221228,
+ 37.59,
+ 23.54,
+ 76.70,
+ 31.59,
+ 89.37,
+ 84.10,
+ 19.25,
+ 78.19,
+ 77.60,
+ 18.54,
+ 24.10,
+ 29.79,
+ 72.44,
+ 78.57,
+ 29.52,
+ 46.72,
+ 22.71,
+ 50.67,
+ 19.55,
+ 'cQ',
+ 'PL',
+ 70.69,
+ 37.56,
+ 74.50,
+ 43.85,
+ 46.56,
+ 29.63,
+ 44.40,
+ 85.64,
+ 22,
+ 'tp',
+ 'vj',
+ 'aM',
+ 65.75,
+ 's3',
+ 'gk',
+ 'uQ',
+ 'IH',
+ 'Ec',
+ 'ev',
+ 'Sl',
+ 'xH',
+ 'Ij',
+ 'mq',
+ 'lP',
+ 'Gt',
+ 'Pl',
+ 'js',
+ '3q',
+ 'Eo',
+ 'F6',
+ 13.24,
+ 17.30,
+ 'ei',
+ 'Nz',
+ 'Or',
+ 'MT',
+ 'mV',
+ 'jM',
+ 90.79
+ ),
+ (
+ 10000007,
+ 10000007,
+ 'xt',
+ 'ox',
+ 'YF',
+ 'LQ',
+ '9c',
+ 'D5',
+ 'RQ',
+ 's5',
+ 'bV',
+ 'PE',
+ 'pR',
+ 'gA',
+ 99,
+ 95,
+ 95,
+ 53,
+ 88,
+ 8031,
+ 'bI',
+ 23,
+ '8W',
+ 71,
+ 'tl',
+ 67,
+ 93,
+ 58,
+ 86,
+ 96,
+ 'Rw',
+ 92,
+ 'lZ',
+ 18,
+ 57,
+ 'Xy',
+ 16,
+ 'XF',
+ 29,
+ 'xi',
+ 72,
+ 47,
+ 'sg',
+ 70,
+ 'Ju',
+ 14,
+ 38,
+ 'C4',
+ 62,
+ 'wN',
+ 'Hs',
+ 'z5',
+ 'y7',
+ '3C',
+ 'jO',
+ 'Jl',
+ 'Vu',
+ 'U4',
+ 'Mi',
+ 'K7',
+ 'HN',
+ 'UA',
+ 'oU',
+ 41,
+ 'TN',
+ 'UO',
+ 'DR',
+ 29,
+ 'jY',
+ 40.80,
+ 19,
+ 'tD',
+ 21.69,
+ 90.36,
+ 86.36,
+ 75.15,
+ 'RU',
+ 'Aw',
+ '8x',
+ 60.25,
+ 38.98,
+ 56.84,
+ 66.38,
+ 38.45,
+ 35.27,
+ 28.43,
+ 77.16,
+ 42.64,
+ 101.00,
+ 14.97,
+ 57.38,
+ 55.93,
+ 12.99,
+ 48.35,
+ 36.18,
+ 86.26,
+ 11.910252,
+ 10.18375,
+ 56.55950,
+ 0.97285,
+ 18.26,
+ 86.74,
+ 5.77,
+ 45.11,
+ 42.41,
+ 58.32,
+ 74.80,
+ 27.77,
+ 39.78,
+ 21.34,
+ 31.32,
+ 27.88,
+ 57.52,
+ 59.96,
+ 60.65,
+ 64.12,
+ 27,
+ 96,
+ 91,
+ 16,
+ 18,
+ 94,
+ 68,
+ 85,
+ 38,
+ 66,
+ 35,
+ 74,
+ 71,
+ 70,
+ 99,
+ 57.85,
+ 46.35,
+ 35.54,
+ 30.12,
+ 37.22,
+ 46.52,
+ 41.31,
+ 50.44,
+ 12.93,
+ 72.39,
+ 26.33,
+ 69.80,
+ 62.20,
+ 2.40,
+ 86.86,
+ 90.42,
+ 40.40,
+ 11.44,
+ 5.20,
+ 3.21,
+ 32.60,
+ 81.90,
+ 29.71,
+ 90.58,
+ 14.60,
+ 76.20,
+ 74.98,
+ 21.24,
+ 54.54,
+ 27.88,
+ 45.75,
+ 24.93,
+ 10.94,
+ 69.88,
+ 44.45,
+ 41.64,
+ 25.98,
+ 1.10,
+ 36.53,
+ 49.28,
+ 21.64,
+ 70.70,
+ 59.29,
+ 59.79,
+ 21.59,
+ 23.69,
+ 89.71,
+ 43.67,
+ 28.18,
+ 6.60,
+ 87.58,
+ 89.75,
+ 76.32,
+ 82.78,
+ 37.38,
+ 69.25,
+ 20.55,
+ 28.19,
+ 78.23,
+ 14.83,
+ 59.40,
+ 50.00,
+ 68.21,
+ 68.25,
+ 36.66,
+ 55.82,
+ 60.41,
+ 59.34,
+ 60.56,
+ 13.60,
+ 30.30,
+ 76.27,
+ 89.45,
+ 50.96,
+ 8.22,
+ 11.96,
+ 4.23,
+ 56.94,
+ 24.15,
+ 54.12,
+ 54.57,
+ 85.38,
+ 57.52,
+ 41.62,
+ 70.87,
+ 17.93,
+ 46.59,
+ 2.71,
+ 53.89,
+ 12.53,
+ 76.00,
+ 50.81,
+ 81.35,
+ 29.26,
+ 17.70,
+ 45.45,
+ 64.75,
+ 47.42,
+ 27.46,
+ 19.449344,
+ 21.832789,
+ 11.214982,
+ 57.762910,
+ 60.793679,
+ 52.937933,
+ 58.670647,
+ 38.799047,
+ 39.816889,
+ 9.924947,
+ 61.382178,
+ 22.495820,
+ 11.448956,
+ 52.177690,
+ 68.555788,
+ 89.947004,
+ 12.974670,
+ 38.800771,
+ 32.480332,
+ 25.925130,
+ 6.920880,
+ 29.52,
+ 39.54,
+ 67.17,
+ 54.13,
+ 2.92,
+ 45.78,
+ 74.95,
+ 5.91,
+ 46.50,
+ 35.79,
+ 68.20,
+ 61.66,
+ 29.75,
+ 27.39,
+ 43.83,
+ 56.47,
+ 59.95,
+ 59.99,
+ 17.29,
+ 32.83,
+ 65.35,
+ 4.32,
+ 37.57,
+ 58.00,
+ 7.79,
+ 3.58,
+ 40.63,
+ 18.30,
+ 17.45,
+ 65.99,
+ 22.00,
+ 0.82,
+ 19.80,
+ 11.90,
+ 31.56,
+ 38.11,
+ 73.80,
+ 65.73,
+ 4.53,
+ 11.23,
+ 52.50,
+ 84.60,
+ 11.00,
+ 22.63,
+ 69.58,
+ 89.24,
+ 13.13,
+ 71.47,
+ 77.91,
+ 39.53,
+ 3.57,
+ 71.17,
+ 46.89,
+ 5.76,
+ 15.73,
+ 14.40,
+ 46.52,
+ 22.90,
+ 89.71,
+ 56.24,
+ 14.85,
+ 67.70,
+ 70.70,
+ 5.77,
+ 74.89,
+ 66.84,
+ 3.59,
+ 48.30,
+ 65.20,
+ 53.45,
+ 30.83,
+ 78.91,
+ 84.20,
+ 44.64,
+ 62.19,
+ 60.10,
+ 68.68,
+ 14.62,
+ 47.70,
+ 34.80,
+ 46.80,
+ 74.80,
+ 19.00,
+ 33.50,
+ 84.22,
+ 30.67,
+ 1.46,
+ 69.324260,
+ 2.146236,
+ 8.391278,
+ 46.190015,
+ 31.662508,
+ 34.961556,
+ 37.552786,
+ 26.715659,
+ 26.417926,
+ 80.273976,
+ 27.919582,
+ 79.877255,
+ 55.621697,
+ 81.763087,
+ 0.74,
+ 34.39,
+ 61.53,
+ 46.41,
+ 60.65,
+ 8.64,
+ 42.54,
+ 87.51,
+ 27.13,
+ 70.74,
+ 29.49,
+ 47.27,
+ 19.43,
+ 43.70,
+ 1.68,
+ 82.49,
+ 17.88,
+ 62.69,
+ 21.34,
+ 8.61,
+ 50.92,
+ 35.59,
+ 37.19,
+ 75.12,
+ 62.47,
+ 86.97,
+ 67.95,
+ 44.73,
+ 48.10,
+ 86.80,
+ 31.47,
+ 53.65,
+ 75.79,
+ 3.54,
+ 88.14,
+ 13.90,
+ 2.85,
+ 52.38,
+ 59.50,
+ 29.20,
+ 56.17,
+ 33.10,
+ 84,
+ 58,
+ '1u',
+ '2C',
+ 46.54,
+ 45.69,
+ 38.18,
+ 6.78,
+ 49.65,
+ 80.20,
+ 34.50,
+ 61.71,
+ 41.14,
+ 15.74,
+ 49.70,
+ 90.68,
+ 33.64,
+ 69.24,
+ 65.88,
+ 13.90,
+ 17.88,
+ 53.30,
+ 17.47,
+ 67.93,
+ 48.81,
+ 40,
+ 46,
+ 76,
+ 34.50,
+ 52.55,
+ 82.36,
+ 21.74,
+ 25.94,
+ 79.10,
+ 'Gi',
+ 'M8',
+ 'CS',
+ 12.26,
+ 44.10,
+ 81.96,
+ 14.33,
+ 61.26,
+ 61.80,
+ 29.40,
+ 20.57,
+ 12.144110,
+ 8.398718,
+ 71.308,
+ 15.554,
+ 29.311,
+ 46.56,
+ 6.33,
+ 3.870077,
+ 45.832327,
+ 12.39,
+ 4.35,
+ 28.85,
+ 14.92,
+ 88.60,
+ 84,
+ 0.17,
+ 11.56,
+ 22.54,
+ 16.50,
+ 56.35,
+ 72.00,
+ 85.18,
+ 32.50,
+ 22.275797,
+ 54.240888,
+ 58.609557,
+ 50.742840,
+ 77.902665,
+ 32.328138,
+ 9.738135,
+ 37.566328,
+ 60.54,
+ 62.23,
+ 19.88,
+ 9.61,
+ 20.70,
+ 20.77,
+ 57.25,
+ 5.96,
+ 41.65,
+ 81.61,
+ 30.98,
+ 27.32,
+ 0.00,
+ 26.89,
+ 44.88,
+ 21.79,
+ 9.71,
+ 55.50,
+ 69.97,
+ 49.60,
+ 62.42,
+ 26.35,
+ 20.90,
+ 86.70,
+ 90.66,
+ 46.46,
+ 60.18,
+ 10.75,
+ 45.12,
+ 14.23,
+ 83.29,
+ 1.55,
+ 64.34,
+ 27.57,
+ 33.47,
+ 59.84,
+ 3.73,
+ 28,
+ 86,
+ 92,
+ 93,
+ 52,
+ 69,
+ 21,
+ 66,
+ 49,
+ 69,
+ 75,
+ 96,
+ 94,
+ 100,
+ 70,
+ 68,
+ 68,
+ 69,
+ 84,
+ 89,
+ 57,
+ 36,
+ 78.32,
+ 81.21,
+ 9.57,
+ 43.66,
+ 59.617879,
+ 80.60,
+ 20.00,
+ 22.64,
+ 31.96,
+ 43.553521,
+ 47.138657,
+ 4.176060,
+ 'Nf',
+ 88.51,
+ 28.15,
+ 77.32,
+ 15.98,
+ 65.88,
+ 63.94,
+ 52.78,
+ 36.85,
+ 51.96,
+ 87.53,
+ 35.30,
+ 66.51,
+ 1.86,
+ 5.15,
+ 'zQ',
+ 'xc',
+ 'E8',
+ 'HH',
+ 'EN',
+ 'vC',
+ 'PX',
+ '95',
+ 15.21,
+ 26.115630,
+ 84.105200,
+ 69.348403,
+ 'BI',
+ 'zI',
+ 88.51,
+ 85,
+ 'lF',
+ 'aH',
+ 68.328683,
+ 76.850540,
+ 5.528574,
+ 79.73,
+ 67.00,
+ 24.97,
+ 54.40,
+ 7.34,
+ 13.79,
+ 41.10,
+ 84.90,
+ 45.63,
+ 15.62,
+ 24.88,
+ 86.11,
+ 35.97,
+ 88.93,
+ 39.48,
+ 18.68,
+ 47.40,
+ 5.54,
+ 87.33,
+ 'MM',
+ 'W4',
+ 31.70,
+ 12.70,
+ 82.98,
+ 82.50,
+ 16.71,
+ 15.11,
+ 37.75,
+ 86.00,
+ 79,
+ 'ib',
+ 'mf',
+ '0c',
+ 72.22,
+ 'sf',
+ 'MP',
+ 'dQ',
+ 'M4',
+ 'Fw',
+ 'IA',
+ 'MO',
+ 'mS',
+ '2Y',
+ 'RG',
+ 'LM',
+ 'su',
+ '9R',
+ 'tQ',
+ 'iL',
+ 'Ae',
+ 'MQ',
+ 4.46,
+ 15.46,
+ 'J3',
+ 'uB',
+ 'sl',
+ 'RY',
+ 'yh',
+ 'ji',
+ 69.34
+ ),
+ (
+ 10000007,
+ 10000007,
+ 'VA',
+ '40',
+ '43',
+ '9y',
+ 'b0',
+ 'dy',
+ 'gq',
+ 'Ij',
+ 'F4',
+ '5V',
+ 'iy',
+ 'es',
+ 66,
+ 74,
+ 40,
+ 19,
+ 48,
+ 8031,
+ 'Eo',
+ 67,
+ 'zQ',
+ 73,
+ 'Gp',
+ 59,
+ 39,
+ 37,
+ 85,
+ 35,
+ 'Xt',
+ 23,
+ 'p3',
+ 64,
+ 43,
+ '1Q',
+ 30,
+ 'jb',
+ 63,
+ 'y5',
+ 83,
+ 90,
+ '49',
+ 19,
+ 'Xm',
+ 87,
+ 44,
+ 'oW',
+ 11,
+ 'Cq',
+ 'pD',
+ 'wV',
+ 'n4',
+ 'uN',
+ 'lX',
+ 'Hx',
+ '6s',
+ 'TF',
+ 'ZF',
+ 'WY',
+ 'uV',
+ '9U',
+ 'jd',
+ 60,
+ 'Z6',
+ '86',
+ 'hR',
+ 100,
+ 'Px',
+ 66.33,
+ 36,
+ 'wR',
+ 55.62,
+ 26.79,
+ 26.10,
+ 56.79,
+ 'hV',
+ 'dN',
+ 'Wm',
+ 29.91,
+ 84.25,
+ 84.20,
+ 16.28,
+ 59.00,
+ 47.75,
+ 87.93,
+ 28.15,
+ 78.60,
+ 100.00,
+ 70.90,
+ 4.30,
+ 5.80,
+ 4.57,
+ 8.52,
+ 56.97,
+ 71.72,
+ 61.530739,
+ 50.35009,
+ 11.21757,
+ 34.74684,
+ 69.23,
+ 84.32,
+ 4.49,
+ 13.62,
+ 9.34,
+ 57.84,
+ 1.40,
+ 86.19,
+ 80.54,
+ 61.69,
+ 54.58,
+ 39.40,
+ 66.74,
+ 23.49,
+ 81.12,
+ 41.50,
+ 83,
+ 66,
+ 91,
+ 24,
+ 52,
+ 18,
+ 59,
+ 75,
+ 88,
+ 44,
+ 91,
+ 89,
+ 89,
+ 43,
+ 77,
+ 70.35,
+ 37.72,
+ 74.11,
+ 52.57,
+ 33.25,
+ 68.95,
+ 89.43,
+ 11.47,
+ 22.27,
+ 12.44,
+ 5.54,
+ 85.52,
+ 10.21,
+ 70.75,
+ 14.77,
+ 31.00,
+ 43.19,
+ 74.70,
+ 47.95,
+ 42.13,
+ 59.89,
+ 16.96,
+ 47.11,
+ 29.93,
+ 62.46,
+ 27.15,
+ 43.76,
+ 53.23,
+ 24.84,
+ 29.49,
+ 41.53,
+ 71.30,
+ 49.00,
+ 44.72,
+ 41.51,
+ 15.50,
+ 75.25,
+ 86.88,
+ 20.92,
+ 40.73,
+ 61.21,
+ 10.75,
+ 86.72,
+ 9.92,
+ 38.80,
+ 83.38,
+ 10.90,
+ 63.13,
+ 79.67,
+ 41.22,
+ 75.72,
+ 60.65,
+ 15.41,
+ 63.68,
+ 50.81,
+ 90.87,
+ 59.63,
+ 7.20,
+ 79.33,
+ 65.71,
+ 63.11,
+ 55.70,
+ 18.71,
+ 1.79,
+ 41.52,
+ 35.50,
+ 55.22,
+ 88.21,
+ 38.25,
+ 24.64,
+ 70.10,
+ 58.40,
+ 45.27,
+ 74.29,
+ 40.83,
+ 26.34,
+ 53.52,
+ 32.27,
+ 73.91,
+ 90.81,
+ 82.83,
+ 42.71,
+ 87.74,
+ 62.40,
+ 62.40,
+ 70.10,
+ 56.45,
+ 80.21,
+ 54.20,
+ 66.10,
+ 76.27,
+ 72.88,
+ 46.80,
+ 54.35,
+ 44.88,
+ 88.60,
+ 9.13,
+ 44.62,
+ 53.63,
+ 12.606823,
+ 31.239831,
+ 6.159336,
+ 49.384105,
+ 31.679608,
+ 56.713094,
+ 61.385919,
+ 64.286729,
+ 58.238584,
+ 86.661107,
+ 12.849681,
+ 4.627707,
+ 9.438265,
+ 89.164620,
+ 12.120401,
+ 61.612412,
+ 75.525182,
+ 41.940972,
+ 38.903800,
+ 30.993664,
+ 12.443632,
+ 7.84,
+ 90.38,
+ 2.17,
+ 32.24,
+ 35.80,
+ 31.99,
+ 89.50,
+ 55.87,
+ 40.20,
+ 63.68,
+ 74.61,
+ 77.12,
+ 86.64,
+ 20.47,
+ 9.10,
+ 15.58,
+ 47.63,
+ 46.81,
+ 18.25,
+ 76.98,
+ 57.00,
+ 45.45,
+ 83.47,
+ 72.80,
+ 38.36,
+ 53.31,
+ 1.26,
+ 36.44,
+ 1.98,
+ 84.82,
+ 9.12,
+ 56.61,
+ 87.30,
+ 72.20,
+ 84.89,
+ 63.40,
+ 88.35,
+ 66.45,
+ 6.81,
+ 63.62,
+ 80.79,
+ 41.17,
+ 57.35,
+ 47.91,
+ 76.51,
+ 19.27,
+ 50.83,
+ 83.58,
+ 36.33,
+ 53.42,
+ 8.55,
+ 33.71,
+ 32.69,
+ 21.90,
+ 37.45,
+ 82.67,
+ 2.83,
+ 85.80,
+ 17.77,
+ 1.85,
+ 0.88,
+ 10.53,
+ 22.14,
+ 3.60,
+ 21.59,
+ 26.47,
+ 16.60,
+ 55.86,
+ 22.33,
+ 11.19,
+ 49.74,
+ 54.55,
+ 59.95,
+ 14.96,
+ 5.64,
+ 7.27,
+ 63.75,
+ 30.55,
+ 88.94,
+ 68.86,
+ 50.59,
+ 37.21,
+ 86.48,
+ 7.29,
+ 1.70,
+ 55.48,
+ 17.39,
+ 11.816207,
+ 7.588556,
+ 63.951446,
+ 50.683043,
+ 74.964118,
+ 28.605967,
+ 9.917708,
+ 88.755000,
+ 55.379528,
+ 6.491721,
+ 73.725170,
+ 47.361100,
+ 38.355305,
+ 40.408715,
+ 17.56,
+ 53.96,
+ 30.63,
+ 62.52,
+ 77.50,
+ 80.44,
+ 64.10,
+ 45.39,
+ 79.50,
+ 54.47,
+ 66.92,
+ 38.30,
+ 3.40,
+ 55.86,
+ 29.58,
+ 11.93,
+ 63.21,
+ 0.66,
+ 50.13,
+ 5.38,
+ 31.30,
+ 72.17,
+ 11.95,
+ 0.54,
+ 90.14,
+ 6.73,
+ 78.90,
+ 82.14,
+ 9.55,
+ 55.41,
+ 49.27,
+ 34.13,
+ 4.59,
+ 63.40,
+ 77.30,
+ 71.91,
+ 11.93,
+ 63.52,
+ 52.80,
+ 3.17,
+ 20.60,
+ 80.83,
+ 97,
+ 30,
+ 'XC',
+ 'uh',
+ 16.94,
+ 0.60,
+ 29.93,
+ 24.97,
+ 38.60,
+ 89.40,
+ 8.95,
+ 25.35,
+ 44.20,
+ 5.35,
+ 10.86,
+ 84.46,
+ 41.39,
+ 21.39,
+ 59.72,
+ 42.57,
+ 39.93,
+ 61.72,
+ 56.68,
+ 34.60,
+ 8.16,
+ 57,
+ 56,
+ 67,
+ 82.19,
+ 55.88,
+ 74.81,
+ 45.22,
+ 52.43,
+ 28.25,
+ '4P',
+ 'ol',
+ '8e',
+ 19.29,
+ 46.15,
+ 89.57,
+ 33.70,
+ 33.94,
+ 7.34,
+ 13.10,
+ 75.12,
+ 80.175957,
+ 77.218460,
+ 38.631,
+ 79.603,
+ 59.630,
+ 26.86,
+ 17.74,
+ 85.580189,
+ 46.331504,
+ 71.77,
+ 28.60,
+ 22.10,
+ 8.12,
+ 87.78,
+ 77,
+ 63.99,
+ 17.87,
+ 14.51,
+ 56.82,
+ 76.59,
+ 10.53,
+ 56.96,
+ 14.88,
+ 10.686673,
+ 57.291460,
+ 50.375523,
+ 68.997174,
+ 56.762140,
+ 83.941676,
+ 28.105420,
+ 52.483476,
+ 86.58,
+ 45.26,
+ 13.85,
+ 26.28,
+ 59.65,
+ 23.69,
+ 10.29,
+ 23.97,
+ 46.13,
+ 77.42,
+ 26.20,
+ 52.37,
+ 40.50,
+ 29.58,
+ 48.81,
+ 37.69,
+ 69.20,
+ 14.87,
+ 7.16,
+ 6.17,
+ 29.59,
+ 70.40,
+ 68.44,
+ 5.97,
+ 38.57,
+ 34.50,
+ 57.22,
+ 67.20,
+ 40.10,
+ 20.63,
+ 89.80,
+ 32.20,
+ 24.62,
+ 75.00,
+ 57.60,
+ 6.69,
+ 59.25,
+ 50,
+ 62,
+ 87,
+ 32,
+ 84,
+ 77,
+ 70,
+ 76,
+ 60,
+ 75,
+ 18,
+ 82,
+ 75,
+ 39,
+ 48,
+ 97,
+ 19,
+ 39,
+ 93,
+ 69,
+ 52,
+ 85,
+ 32.25,
+ 41.13,
+ 0.17,
+ 44.42,
+ 22.247195,
+ 6.97,
+ 4.63,
+ 35.80,
+ 90.16,
+ 9.514569,
+ 78.792163,
+ 29.544784,
+ 'y3',
+ 43.40,
+ 54.98,
+ 31.12,
+ 78.64,
+ 41.27,
+ 3.46,
+ 17.47,
+ 5.86,
+ 80.18,
+ 87.54,
+ 22.63,
+ 73.51,
+ 48.55,
+ 32.73,
+ 'Dv',
+ 'sR',
+ 'mD',
+ 'ml',
+ 'dX',
+ 'FU',
+ 'Sk',
+ 'yA',
+ 20.32,
+ 15.684845,
+ 76.970753,
+ 50.236843,
+ '5V',
+ 'XO',
+ 12.46,
+ 51,
+ 'V9',
+ 'WC',
+ 27.154478,
+ 47.996990,
+ 71.882292,
+ 27.42,
+ 21.81,
+ 84.90,
+ 51.32,
+ 32.64,
+ 90.39,
+ 38.82,
+ 13.35,
+ 27.61,
+ 64.54,
+ 33.82,
+ 23.46,
+ 79.52,
+ 10.70,
+ 27.29,
+ 48.52,
+ 20.60,
+ 21.80,
+ 47.24,
+ 'rc',
+ 'pO',
+ 28.22,
+ 42.34,
+ 12.10,
+ 35.37,
+ 34.12,
+ 11.39,
+ 77.96,
+ 22.79,
+ 32,
+ 'W7',
+ '5c',
+ 'iI',
+ 12.30,
+ 'M0',
+ 'hg',
+ '0N',
+ '4Q',
+ 'uy',
+ 'Fp',
+ 'qB',
+ 'tE',
+ 'sh',
+ '9H',
+ 'Z9',
+ 'it',
+ '5M',
+ '37',
+ 'Dm',
+ 'NB',
+ 'bg',
+ 20.83,
+ 44.81,
+ 'yd',
+ 'CT',
+ 'Qs',
+ 'Kw',
+ 'ex',
+ 'M2',
+ 11.26
+ );
+
+ INSERT INTO
+ USR_TLBL_VAL_R (
+ lbl_id,
+ khh,
+ lbl_clss_id,
+ lbl_clss_nm,
+ lbl_type_id,
+ lbl_type_name,
+ lbl_nm,
+ lbl_val_id,
+ lbl_val_code,
+ lbl_val_name,
+ lbl_val_dsc,
+ jsrq
+ )
+ VALUES
+ (
+ 60426,
+ 10000007,
+ 63,
+ 'nn',
+ 53,
+ 'ER',
+ 'Kw',
+ 29,
+ 'qP',
+ 'NO',
+ 'vp',
+ 78
+ ),
+ (
+ 94460,
+ 10000007,
+ 69,
+ 'yi',
+ 94,
+ 'Q7',
+ 'XX',
+ 62,
+ 'jB',
+ 'Ff',
+ 'lz',
+ 46
+ ),
+ (
+ 48414,
+ 10000007,
+ 92,
+ 'hV',
+ 78,
+ 'cl',
+ 'nn',
+ 94,
+ 'Vg',
+ 'DZ',
+ 'MD',
+ 94
+ );
+
+ set parallel_pipeline_task_num=17;
+ set enable_sql_cache=false;
+ set enable_nereids_distribute_planner=true;"""
+
+ test {
+ sql "select cast(sum(zzc) as int) from USR_V_KHZHSJ_ES_POC
A,USR_TLBL_VAL_R B WHERE A.khid = B.khh AND A.zzc >100 AND B.lbl_id IN
(94460,48414,60426) limit 100"
+ result([[303]])
+ }
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
