包含特殊字段数据查询错误

💬 StarRocks 用户问答
#1

在 社区群1 提问无果，遂在此提交case, 希望得到关注，因为我从两个版本里碰到同样的问题了。谢谢

【详述】
可以查看历史case: 【sql where条件 ='xxx'查不出数据 用like 'xxx' 可以查到数据，MD5(xxx)结果一样】
目前又出现同样的问题了

现象一：
使用 UNIQUE_ID like（%放任一位置即可）语句中包不包含vesting_date 都能查出，
select VESTING_DATE ,* from cpc_prod.dwd_cpc_research dcr where VESTING_DATE=‘2022-11-26’ and UNIQUE_ID like ‘0000e72e-462b-4b8%c-a8e2-eb9eb6271d60’

image
image1124×114 10.2 KB

现象二：
使用 “=” 当查询语句中不包含字段vesting_date 是可以查出见过
select UNIQUE_ID,id,VERSION from cpc_prod.dwd_cpc_research dcr where UNIQUE_ID = ‘0000e72e-462b-4b8c-a8e2-eb9eb6271d60’

image
image761×125 7.63 KB

当包含vesting_date（不管是select后还是where条件上）时都无结果
select UNIQUE_ID,id,VERSION,VESTING_DATE from cpc_prod.dwd_cpc_research dcr where UNIQUE_ID = ‘0000e72e-462b-4b8c-a8e2-eb9eb6271d60’
image

现象三：
新建结构一样的表，insert into select 灌入旧表数据，无上述问题。

现象四：
select count(*) 全表，新表和老表数据量一致。

现象五：
7月10号从3.3.14升级SR到3.4.4后问题还在。

老表是一个静态表，一年更新一次数据，问题数据（目前发现十多条数据，应该会更多）是很早的老数据，一直没动

【背景】25年6月30号，由于SR的 用于链接sqlServer 的jdbc catalogs 无故失效，重建也不行的情况下对sr升级，由3.3.9升级到3.3.14，jdbc catalogs重建生效问题解决。

但数据查询问题当时没有发现，在25年7.8号发现数据问题。
【业务影响】
数据查询，统计，导出数据错误或导出数据变少

【是否存算分离】
存算一体

【集群规模】三节点，2fe(1 leader+1observer）+3be（2节点fe与be混部）
【机器信息】CPU虚拟核/内存/网卡，例如：48C/125G/万兆
【联系方式】社区群1-Kevin 邮箱：yz.zhang@ccahouse.org
【附件】
EXPLAIN ANALYZE
select UNIQUE_ID,id,VERSION,VESTING_DATE from cpc_prod.dwd_cpc_research dcr where UNIQUE_ID = ‘0000e72e-462b-4b8c-a8e2-eb9eb6271d60’

e[0mSummarye[0m
e[0mQueryId: fee66121-5d6b-11f0-9b7b-2cea7fa0275ae[0m
e[0mVersion: 3.4.4-bc987bbe[0m
e[0mState: Finishede[0m
e[0mTotalTime: 168mse[0m
e[0mExecutionTime: 69.118ms [Scan: 54.095ms (78.26%), Network: 687.648us (0.99%), ResultDeliverTime: 0ns (0.00%), ScheduleTime: 0ns (0.00%)]e[0m
e[0mCollectProfileTime: 4mse[0m
e[0mFrontendProfileMergeTime: 73.564mse[0m
e[0mQueryPeakMemoryUsage: ?, QueryAllocatedMemoryUsage: 3.031 MBe[0m
e[0mTop Most Time-consuming Nodes:e[0m
e[1me[31m1. OLAP_SCAN (id=0) : 55.631ms (98.28%)e[0m
e[0m2. EXCHANGE (id=1) : 845.059us (1.49%)e[0m
e[0m3. RESULT_SINK: 129.608us (0.23%)e[0m
e[0mTop Most Memory-consuming Nodes:e[0m
e[0mNonDefaultVariables:e[0m
e[0manalyze_mv_v2: -> samplee[0m
e[0mbig_query_profile_threshold: 30s -> 0se[0m
e[0mcboPushDownAggregateMode_v1: 0 -> -1e[0m
e[0mcbo_cte_reuse: true -> falsee[0m
e[0mcbo_eq_base_type: decimal -> varchare[0m
e[0mcbo_materialized_view_rewrite_related_mvs_limit: 16 -> 64e[0m
e[0mcbo_push_down_topn_limit: 1000 -> 0e[0m
e[0mcharacter_set_results: utf8 -> NULLe[0m
e[0mconsistent_hash_virtual_number: 256 -> 128e[0m
e[0menable_async_profile: true -> falsee[0m
e[0menable_column_expr_predicate: true -> falsee[0m
e[0menable_datacache_async_populate_mode: true -> falsee[0m
e[0menable_datacache_io_adaptor: true -> falsee[0m
e[0menable_file_metacache: true -> falsee[0m
e[0menable_filter_unused_columns_in_scan_stage: true -> falsee[0m
e[0menable_force_rule_based_mv_rewrite: true -> falsee[0m
e[0menable_iceberg_column_statistics: false -> truee[0m
e[0menable_profile: false -> truee[0m
e[0menable_rewrite_bitmap_union_to_bitamp_agg: true -> falsee[0m
e[0menable_scan_datacache: true -> falsee[0m
e[0menable_scan_predicate_expr_reuse: true -> falsee[0m
e[0menable_view_based_mv_rewrite: true -> falsee[0m
e[0mexec_mem_limit: 2147483648 -> 107374182400e[0m
e[0mfull_sort_late_materialization_v2: true -> falsee[0m
e[0mfull_sort_max_buffered_bytes: 268435456 -> 16777216e[0m
e[0mfull_sort_max_buffered_rows: 1073741824 -> 1024000e[0m
e[0mgroup_concat_max_len: 1024 -> 65535e[0m
e[0mmax_allowed_packet: 33554432 -> 20971520e[0m
e[0mprofile_timeout: 10 -> 2e[0m
e[0mquery_timeout: 300 -> 7200e[0m
e[0mspill_mem_limit_threshold: 0.8 -> 0.5e[0m
e[0mspill_operator_min_bytes: 52428800 -> 10485760e[0m
e[0msql_mode_v2: 32 -> 2097184e[0m
e[0mtransmission_compression_type: AUTO -> LZ4e[0m
e[0mFragment 0e[0m
│ e[0mBackendNum: 1e[0m
│ e[0mInstancePeakMemoryUsage: 367.336 KB, InstanceAllocatedMemoryUsage: 498.305 KBe[0m
│ e[0mPrepareTime: ?e[0m
└──e[0mRESULT_SINKe[0m
│ e[0mTotalTime: 129.608us (0.23%) [CPUTime: 129.608us]e[0m
│ e[0mOutputRows: 0e[0m
│ e[0mSinkType: MYSQL_PROTOCALe[0m
└──e[0mEXCHANGE (id=1) e[0m
e[0mEstimates: [row: ?, cpu: ?, memory: ?, network: ?, cost: ?]e[0m
e[0mTotalTime: 845.059us (1.49%) [CPUTime: 157.411us, NetworkTime: 687.648us]e[0m
e[0mOutputRows: 0e[0m
e[0mPeakMemory: ?, AllocatedMemory: ?e[0m
e[0m
e[0mFragment 1e[0m
│ e[0mBackendNum: 3e[0m
│ e[0mInstancePeakMemoryUsage: 507.508 KB, InstanceAllocatedMemoryUsage: 2.545 MBe[0m
│ e[0mPrepareTime: ?e[0m
└──e[0mDATA_STREAM_SINK (id=1)e[0m
│ e[0mPartitionType: UNPARTITIONEDe[0m
└──e[1me[31mOLAP_SCAN (id=0) e[0m
e[1me[31mEstimates: [row: 1, cpu: 52.00, memory: 0.00, network: 0.00, cost: 26.00]e[0m
e[1me[31mTotalTime: 55.631ms (98.28%) [CPUTime: 1.535ms, ScanTime: 54.095ms]e[0m
e[1me[31mOutputRows: 0e[0m
e[1me[31mTable: : dwd_cpc_researche[0m
e[1me[31mSubordinateOperators: e[0m
e[1me[31mCHUNK_ACCUMULATEe[0m
e[1me[31mNOOPe[0m
e[1me[31mOLAP_SCAN_PREPAREe[0m
e[1me[31mDetail Timers: [ScanTime = IOTaskExecTime + IOTaskWaitTime]e[0m
e[1me[31mIOTaskExecTime: 9.151ms [min=62.407us, max=54.012ms]e[0m
e[1me[31mIOTime: 8.936ms [min=0ns, max=53.621ms]e[0m
e[1me[31mSegmentInit: 9.039ms [min=0ns, max=53.879ms]e[0m
e[1me[31mColumnIteratorInit: 8.971ms [min=0ns, max=53.759ms]e[0m
e[1me[31mIOTaskWaitTime: 80.133us [min=31.906us, max=99.649us]e[0m
e[0m

EXPLAIN ANALYZE
select UNIQUE_ID,id,VERSION,VESTING_DATE from cpc_prod.dwd_cpc_research dcr where UNIQUE_ID like ‘0000%e72e-462b-4b8c-a8e2-eb9eb6271d60’

e[0mSummarye[0m
e[0mQueryId: 17fbbc29-5d6c-11f0-9b7b-2cea7fa0275ae[0m
e[0mVersion: 3.4.4-bc987bbe[0m
e[0mState: Finishede[0m
e[0mTotalTime: 793mse[0m
e[0mExecutionTime: 777.632ms [Scan: 727.849ms (93.60%), Network: 921.243us (0.12%), ResultDeliverTime: 0ns (0.00%), ScheduleTime: 0ns (0.00%)]e[0m
e[0mCollectProfileTime: 9mse[0m
e[0mFrontendProfileMergeTime: 6.117mse[0m
e[0mQueryPeakMemoryUsage: ?, QueryAllocatedMemoryUsage: 1.139 GBe[0m
e[0mTop Most Time-consuming Nodes:e[0m
e[1me[31m1. OLAP_SCAN (id=0) : 921.871ms (99.86%)e[0m
e[0m2. EXCHANGE (id=1) : 1.194ms (0.13%)e[0m
e[0m3. RESULT_SINK: 133.032us (0.01%)e[0m
e[0mTop Most Memory-consuming Nodes:e[0m
e[0mNonDefaultVariables:e[0m
e[0manalyze_mv_v2: -> samplee[0m
e[0mbig_query_profile_threshold: 30s -> 0se[0m
e[0mcboPushDownAggregateMode_v1: 0 -> -1e[0m
e[0mcbo_cte_reuse: true -> falsee[0m
e[0mcbo_eq_base_type: decimal -> varchare[0m
e[0mcbo_materialized_view_rewrite_related_mvs_limit: 16 -> 64e[0m
e[0mcbo_push_down_topn_limit: 1000 -> 0e[0m
e[0mcharacter_set_results: utf8 -> NULLe[0m
e[0mconsistent_hash_virtual_number: 256 -> 128e[0m
e[0menable_async_profile: true -> falsee[0m
e[0menable_column_expr_predicate: true -> falsee[0m
e[0menable_datacache_async_populate_mode: true -> falsee[0m
e[0menable_datacache_io_adaptor: true -> falsee[0m
e[0menable_file_metacache: true -> falsee[0m
e[0menable_filter_unused_columns_in_scan_stage: true -> falsee[0m
e[0menable_force_rule_based_mv_rewrite: true -> falsee[0m
e[0menable_iceberg_column_statistics: false -> truee[0m
e[0menable_profile: false -> truee[0m
e[0menable_rewrite_bitmap_union_to_bitamp_agg: true -> falsee[0m
e[0menable_scan_datacache: true -> falsee[0m
e[0menable_scan_predicate_expr_reuse: true -> falsee[0m
e[0menable_view_based_mv_rewrite: true -> falsee[0m
e[0mexec_mem_limit: 2147483648 -> 107374182400e[0m
e[0mfull_sort_late_materialization_v2: true -> falsee[0m
e[0mfull_sort_max_buffered_bytes: 268435456 -> 16777216e[0m
e[0mfull_sort_max_buffered_rows: 1073741824 -> 1024000e[0m
e[0mgroup_concat_max_len: 1024 -> 65535e[0m
e[0mmax_allowed_packet: 33554432 -> 20971520e[0m
e[0mprofile_timeout: 10 -> 2e[0m
e[0mquery_timeout: 300 -> 7200e[0m
e[0mspill_mem_limit_threshold: 0.8 -> 0.5e[0m
e[0mspill_operator_min_bytes: 52428800 -> 10485760e[0m
e[0msql_mode_v2: 32 -> 2097184e[0m
e[0mtransmission_compression_type: AUTO -> LZ4e[0m
e[0mFragment 0e[0m
│ e[0mBackendNum: 1e[0m
│ e[0mInstancePeakMemoryUsage: 370.859 KB, InstanceAllocatedMemoryUsage: 505.117 KBe[0m
│ e[0mPrepareTime: ?e[0m
└──e[0mRESULT_SINKe[0m
│ e[0mTotalTime: 133.032us (0.01%) [CPUTime: 133.032us]e[0m
│ e[0mOutputRows: 1e[0m
│ e[0mSinkType: MYSQL_PROTOCALe[0m
└──e[0mEXCHANGE (id=1) e[0m
e[0mEstimates: [row: ?, cpu: ?, memory: ?, network: ?, cost: ?]e[0m
e[0mTotalTime: 1.194ms (0.13%) [CPUTime: 272.948us, NetworkTime: 921.243us]e[0m
e[0mOutputRows: 1e[0m
e[0mPeakMemory: ?, AllocatedMemory: ?e[0m
e[0m
e[0mFragment 1e[0m
│ e[0mBackendNum: 3e[0m
│ e[0mInstancePeakMemoryUsage: 24.856 MB, InstanceAllocatedMemoryUsage: 1.139 GBe[0m
│ e[0mPrepareTime: 12.935mse[0m
└──e[0mDATA_STREAM_SINK (id=1)e[0m
│ e[0mPartitionType: UNPARTITIONEDe[0m
└──e[1me[31mOLAP_SCAN (id=0) e[0m
e[1me[31mEstimates: [row: 3405667, cpu: 177082606.88, memory: 0.00, network: 0.00, cost: 88541303.44]e[0m
e[1me[31mTotalTime: 921.871ms (99.86%) [CPUTime: 194.021ms, ScanTime: 727.849ms]e[0m
e[1me[31mOutputRows: 1e[0m
e[1me[31mTable: : dwd_cpc_researche[0m
e[1me[31mSubordinateOperators: e[0m
e[1me[31mCHUNK_ACCUMULATEe[0m
e[1me[31mNOOPe[0m
e[1me[31mOLAP_SCAN_PREPAREe[0m
e[1me[31mDetail Timers: [ScanTime = IOTaskExecTime + IOTaskWaitTime]e[0m
e[1me[31mIOTaskExecTime: 131.206ms [min=1.254ms, max=727.813ms]e[0m
e[1me[31mIOTime: 101.380ms [min=0ns, max=670.816ms]e[0m
e[1me[31mSegmentRead: 104.918ms [min=545.254us, max=678.083ms]e[0m
e[1me[31mBlockFetch: 98.662ms [min=143.361us, max=639.668ms]e[0m
e[1me[31mIOTaskWaitTime: 197.580us [min=36.562us, max=2.549ms]e[0m
e[0m

表结构：
– cpc_prod.dwd_cpc_research definition

CREATE TABLE dwd_cpc_research (
UNIQUE_ID varchar(50) NOT NULL COMMENT “”,
VESTING_DATE date NOT NULL COMMENT “”,
ID bigint(20) NOT NULL AUTO_INCREMENT COMMENT “自增id”,
VERSION varchar(30) NULL COMMENT “”,
C010304 varchar(30) NULL COMMENT “”,
YEAR int(11) NULL DEFAULT “2016” COMMENT “”,
HOS_PROV varchar(50) NULL COMMENT “”,
HOS_CITY varchar(100) NULL COMMENT “”,
HOS_COUNTY varchar(100) NULL COMMENT “”,
C01020401 varchar(30) NULL COMMENT “”,
C01020402 varchar(30) NULL COMMENT “”,
C01020403 varchar(150) NULL COMMENT “”,
HOS_NAME varchar(150) NULL COMMENT “”,
HOSPITAL_ID varchar(50) NULL COMMENT “”,
CODE varchar(50) NULL COMMENT “”,
C0101 varchar(50) NULL COMMENT “”,
C010101 varchar(200) NULL COMMENT “”,
C010102 varchar(50) NULL COMMENT “”,
C010103 varchar(50) NULL COMMENT “”,
C01010301 varchar(100) NULL COMMENT “”,
C010104 varchar(50) NULL COMMENT “”,
C010105 varchar(30) NULL COMMENT “”,
C010106 varchar(30) NULL COMMENT “”,
C010107 varchar(30) NULL COMMENT “”,
C010108 varchar(30) NULL COMMENT “”,
C010109 varchar(30) NULL COMMENT “”,
C010110 varchar(30) NULL COMMENT “”,
C010111 varchar(30) NULL COMMENT “”,
C010112 varchar(30) NULL COMMENT “”,
C0102 varchar(30) NULL COMMENT “”,
C010201 varchar(30) NULL COMMENT “”,
C010202 varchar(30) NULL COMMENT “”,
C010203 varchar(30) NULL COMMENT “”,
C01020301 varchar(50) NULL COMMENT “”,
C01020302 varchar(30) NULL COMMENT “”,
C010204 varchar(30) NULL COMMENT “”,
C01020404 varchar(30) NULL COMMENT “”,
C010205 varchar(30) NULL COMMENT “”,
C01020501 varchar(30) NULL COMMENT “”,
C010206 varchar(30) NULL COMMENT “”,
C010207 varchar(30) NULL COMMENT “”,
C01020701 varchar(50) NULL COMMENT “”,
C01020702 varchar(100) NULL COMMENT “”,
C010208 varchar(30) NULL COMMENT “”,
C01020801 varchar(30) NULL COMMENT “”,
C0102080101 varchar(30) NULL COMMENT “”,
C0102080102 varchar(30) NULL COMMENT “”,
C0102080103 varchar(100) NULL COMMENT “”,
C010208010301 varchar(100) NULL COMMENT “”,
C01020801030101 varchar(30) NULL COMMENT “”,
C0102080104 varchar(30) NULL COMMENT “”,
C0102080105 varchar(30) NULL COMMENT “”,
C0102080106 varchar(30) NULL COMMENT “”,
C0102080107 varchar(30) NULL COMMENT “”,
C01020802 varchar(30) NULL COMMENT “”,
C0102080201 varchar(60) NULL COMMENT “”,
C0102080202 varchar(500) NULL COMMENT “”,
C0102080203 varchar(30) NULL COMMENT “”,
C0102080204 varchar(100) NULL COMMENT “”,
C010208020401 varchar(100) NULL COMMENT “”,
C01020802040101 varchar(30) NULL COMMENT “”,
C0102080205 varchar(30) NULL COMMENT “”,
C0102080206 varchar(30) NULL COMMENT “”,
C0102080207 varchar(30) NULL COMMENT “”,
C0102080208 varchar(30) NULL COMMENT “”,
C0102080209 varchar(30) NULL COMMENT “”,
C0102080210 varchar(30) NULL COMMENT “”,
C01020803 varchar(30) NULL COMMENT “”,
C0102080301 varchar(30) NULL COMMENT “”,
C0102080302 varchar(30) NULL COMMENT “”,
C0102080303 varchar(30) NULL COMMENT “”,
C0102080304 varchar(30) NULL COMMENT “”,
C01020804 varchar(30) NULL COMMENT “”,
C0102080401 varchar(300) NULL COMMENT “”,
C0102080402 varchar(100) NULL COMMENT “”,
C0102080403 varchar(30) NULL COMMENT “”,
C0102080404 varchar(100) NULL COMMENT “”,
C010209 varchar(30) NULL COMMENT “”,
C01020901 varchar(30) NULL COMMENT “”,
C01020902 varchar(30) NULL COMMENT “”,
C01020903 varchar(30) NULL COMMENT “”,
C01020904 varchar(30) NULL COMMENT “”,
C01020905 varchar(30) NULL COMMENT “”,
C0102090501 varchar(30) NULL COMMENT “”,
C010209050101 varchar(255) NULL COMMENT “”,
C010209050102 varchar(255) NULL COMMENT “”,
C0102090502 varchar(30) NULL COMMENT “”,
C010209050201 varchar(255) NULL COMMENT “”,
C010209050202 varchar(255) NULL COMMENT “”,
C01020906 varchar(30) NULL COMMENT “”,
C010210 varchar(30) NULL COMMENT “”,
C01021001 varchar(30) NULL COMMENT “”,
C0102100101 varchar(100) NULL COMMENT “”,
C010210010101 varchar(100) NULL COMMENT “”,
C01021001010101 varchar(30) NULL COMMENT “”,
C01021001010102 varchar(30) NULL COMMENT “”,
C01021001010103 varchar(30) NULL COMMENT “”,
C01021001010104 varchar(30) NULL COMMENT “”,
C01021001010105 varchar(30) NULL COMMENT “”,
C01021001010106 varchar(30) NULL COMMENT “”,
C01021001010107 varchar(30) NULL COMMENT “”,
C0102100101010701 varchar(30) NULL COMMENT “”,
C0102100101010702 varchar(30) NULL COMMENT “”,
C0102100101010703 varchar(30) NULL COMMENT “”,
C01021001010108 varchar(30) NULL COMMENT “”,
C01021001010109 varchar(30) NULL COMMENT “”,
C0102100101010901 varchar(30) NULL COMMENT “”,
C010210010101090101 varchar(30) NULL COMMENT “”,
C010210010101090102 varchar(30) NULL COMMENT “”,
C0102100101010902 varchar(30) NULL COMMENT “”,
C010210010101090201 varchar(30) NULL COMMENT “”,
C01021001010109020101 varchar(30) NULL COMMENT “”,
C01021001010109020102 varchar(30) NULL COMMENT “”,
C0102100102 varchar(30) NULL COMMENT “”,
C010210010201 varchar(30) NULL COMMENT “”,
C0103 varchar(30) NULL COMMENT “”,
C010301 varchar(30) NULL COMMENT “”,
C01030101 varchar(30) NULL COMMENT “”,
C0103010101 varchar(30) NULL COMMENT “”,
C010301010101 varchar(30) NULL COMMENT “”,
C010301010102 varchar(30) NULL COMMENT “”,
C010301010103 varchar(30) NULL COMMENT “”,
C0103010102 varchar(60) NULL COMMENT “”,
C010301010201 varchar(800) NULL COMMENT “”,
C01030102 varchar(30) NULL COMMENT “”,
C0103010201 varchar(100) NULL COMMENT “”,
C010301020101 varchar(100) NULL COMMENT “”,
C010301020102 varchar(30) NULL COMMENT “”,
C0103010202 varchar(30) NULL COMMENT “”,
C010302 varchar(30) NULL COMMENT “”,
C01030201 varchar(30) NULL COMMENT “”,
C0103020101 varchar(30) NULL COMMENT “”,
C0103020102 varchar(30) NULL COMMENT “”,
C010302010201 varchar(30) NULL COMMENT “”,
C010302010202 varchar(30) NULL COMMENT “”,
C010302010203 varchar(30) NULL COMMENT “”,
C010302010204 varchar(30) NULL COMMENT “”,
C010302010205 varchar(30) NULL COMMENT “”,
C01030202 varchar(30) NULL COMMENT “”,
C0103020201 varchar(30) NULL COMMENT “”,
C01030203 varchar(30) NULL COMMENT “”,
C0103020301 varchar(30) NULL COMMENT “”,
C0103020302 varchar(30) NULL COMMENT “”,
C01030204 varchar(30) NULL COMMENT “”,
C0103020401 varchar(30) NULL COMMENT “”,
C01030205 varchar(30) NULL COMMENT “”,
C0103020501 varchar(30) NULL COMMENT “”,
C01030206 varchar(30) NULL COMMENT “”,
C0103020601 varchar(30) NULL COMMENT “”,
C0103020602 varchar(30) NULL COMMENT “”,
C01030207 varchar(30) NULL COMMENT “”,
C0103020701 varchar(30) NULL COMMENT “”,
C0103020702 varchar(30) NULL COMMENT “”,
C010303 varchar(20) NULL COMMENT “”,
C01030301 varchar(30) NULL COMMENT “”,
C0103030101 varchar(30) NULL COMMENT “”,
C0103030102 varchar(30) NULL COMMENT “”,
C0103030103 varchar(30) NULL COMMENT “”,
C01030401 varchar(30) NULL COMMENT “”,
C0103040101 varchar(30) NULL COMMENT “”,
C0103040102 varchar(30) NULL COMMENT “”,
C0103040103 varchar(30) NULL COMMENT “”,
C0103040104 varchar(30) NULL COMMENT “”,
C0103040105 varchar(30) NULL COMMENT “”,
C0103040106 varchar(30) NULL COMMENT “”,
C0103040107 varchar(30) NULL COMMENT “”,
C010304010701 varchar(30) NULL COMMENT “”,
C01030401070101 varchar(30) NULL COMMENT “”,
C0103040107010101 varchar(30) NULL COMMENT “”,
C0103040107010102 varchar(30) NULL COMMENT “”,
C01030401070102 varchar(30) NULL COMMENT “”,
C0103040107010201 varchar(30) NULL COMMENT “”,
C0103040107010202 varchar(30) NULL COMMENT “”,
C01030401070103 varchar(30) NULL COMMENT “”,
C0103040107010301 varchar(30) NULL COMMENT “”,
C0103040107010302 varchar(30) NULL COMMENT “”,
C010304010702 varchar(30) NULL COMMENT “”,
C01030401070201 varchar(30) NULL COMMENT “”,
C01030401070202 varchar(500) NULL COMMENT “”,
C01030401070203 varchar(30) NULL COMMENT “”,
C01030401070204 varchar(30) NULL COMMENT “”,
C010304010703 varchar(30) NULL COMMENT “”,
C010304010704 varchar(30) NULL COMMENT “”,
C0103040108 varchar(30) NULL COMMENT “”,
C010304010801 varchar(30) NULL COMMENT “”,
C01030401080101 varchar(30) NULL COMMENT “”,
C0103040108010101 varchar(30) NULL COMMENT “”,
C0103040108010102 varchar(30) NULL COMMENT “”,
C0103040108010103 varchar(30) NULL COMMENT “”,
C0103040108010104 varchar(30) NULL COMMENT “”,
C0103040108010105 varchar(30) NULL COMMENT “”,
C01030401080102 varchar(30) NULL COMMENT “”,
C0103040108010201 varchar(30) NULL COMMENT “”,
C010304010801020101 varchar(30) NULL COMMENT “”,
C01030401080102010101 varchar(100) NULL COMMENT “”,
C0103040108010201010101 varchar(30) NULL COMMENT “”,
C010304010801020101010101 varchar(30) NULL COMMENT “”,
C0103040108010201010102 varchar(30) NULL COMMENT “”,
C010304010801020101010201 varchar(30) NULL COMMENT “”,
C010304010801020102 varchar(30) NULL COMMENT “”,
C010304010801020103 varchar(30) NULL COMMENT “”,
C010304010801020104 varchar(30) NULL COMMENT “”,
C010304010801020105 varchar(30) NULL COMMENT “”,
C010304010801020106 varchar(30) NULL COMMENT “”,
C010304010801020107 varchar(30) NULL COMMENT “”,
C01030401080102010701 varchar(30) NULL COMMENT “”,
C01030401080102010702 varchar(30) NULL COMMENT “”,
C01030401080102010703 varchar(30) NULL COMMENT “”,
C010304010801020108 varchar(30) NULL COMMENT “”,
C010304010801020109 varchar(30) NULL COMMENT “”,
C0103040108010202 varchar(30) NULL COMMENT “”,
C010304010801020201 varchar(30) NULL COMMENT “”,
C0103040108010203 varchar(30) NULL COMMENT “”,
C01030401080103 varchar(30) NULL COMMENT “”,
C0103040108010301 varchar(30) NULL COMMENT “”,
C0103040108010302 varchar(30) NULL COMMENT “”,
C01030401080104 varchar(30) NULL COMMENT “”,
C0103040108010401 varchar(30) NULL COMMENT “”,
C0103040108010402 varchar(30) NULL COMMENT “”,
C01030401080105 varchar(30) NULL COMMENT “”,
C010304010802 varchar(30) NULL COMMENT “”,
C01030402 varchar(30) NULL COMMENT “”,
C0103040201 varchar(30) NULL COMMENT “”,
C0103040202 varchar(30) NULL COMMENT “”,
C0103040203 varchar(30) NULL COMMENT “”,
C0103040204 varchar(30) NULL COMMENT “”,
C0103040205 varchar(30) NULL COMMENT “”,
C0103040206 varchar(30) NULL COMMENT “”,
C0103040207 varchar(30) NULL COMMENT “”,
C010304020701 varchar(30) NULL COMMENT “”,
C01030402070101 varchar(30) NULL COMMENT “”,
C0103040207010101 varchar(30) NULL COMMENT “”,
C0103040207010102 varchar(30) NULL COMMENT “”,
C01030402070102 varchar(30) NULL COMMENT “”,
C0103040207010201 varchar(30) NULL COMMENT “”,
C0103040207010202 varchar(30) NULL COMMENT “”,
C01030402070103 varchar(30) NULL COMMENT “”,
C0103040207010301 varchar(30) NULL COMMENT “”,
C0103040207010302 varchar(30) NULL COMMENT “”,
C010304020702 varchar(30) NULL COMMENT “”,
C01030402070201 varchar(30) NULL COMMENT “”,
C01030402070202 varchar(200) NULL COMMENT “”,
C01030402070203 varchar(30) NULL COMMENT “”,
C01030402070204 varchar(30) NULL COMMENT “”,
C010304020703 varchar(30) NULL COMMENT “”,
C010304020704 varchar(30) NULL COMMENT “”,
C0103040208 varchar(30) NULL COMMENT “”,
C010304020801 varchar(30) NULL COMMENT “”,
C010304020802 varchar(30) NULL COMMENT “”,
C010304020803 varchar(30) NULL COMMENT “”,
C010304020804 varchar(30) NULL COMMENT “”,
C0103040209 varchar(30) NULL COMMENT “”,
C010304020901 varchar(30) NULL COMMENT “”,
C0103040210 varchar(30) NULL COMMENT “”,
C010304021001 varchar(30) NULL COMMENT “”,
C01030402100101 varchar(30) NULL COMMENT “”,
C0103040210010101 varchar(30) NULL COMMENT “”,
C0103040210010102 varchar(30) NULL COMMENT “”,
C0103040210010103 varchar(30) NULL COMMENT “”,
C0103040210010104 varchar(30) NULL COMMENT “”,
C0103040210010105 varchar(30) NULL COMMENT “”,
C01030402100102 varchar(30) NULL COMMENT “”,
C0103040210010201 varchar(30) NULL COMMENT “”,
C01030403 varchar(30) NULL COMMENT “”,
C0103040301 varchar(30) NULL COMMENT “”,
C0103040302 varchar(30) NULL COMMENT “”,
C0103040303 varchar(30) NULL COMMENT “”,
C0103040304 varchar(30) NULL COMMENT “”,
C0103040305 varchar(30) NULL COMMENT “”,
C0103040306 varchar(30) NULL COMMENT “”,
C0103040307 varchar(30) NULL COMMENT “”,
C010304030701 varchar(30) NULL COMMENT “”,
C01030403070101 varchar(30) NULL COMMENT “”,
C0103040307010101 varchar(30) NULL COMMENT “”,
C0103040307010102 varchar(30) NULL COMMENT “”,
C01030403070102 varchar(30) NULL COMMENT “”,
C0103040307010201 varchar(30) NULL COMMENT “”,
C0103040307010202 varchar(30) NULL COMMENT “”,
C01030403070103 varchar(30) NULL COMMENT “”,
C0103040307010301 varchar(30) NULL COMMENT “”,
C0103040307010302 varchar(30) NULL COMMENT “”,
C010304030702 varchar(30) NULL COMMENT “”,
C01030403070201 varchar(30) NULL COMMENT “”,
C01030403070202 varchar(200) NULL COMMENT “”,
C01030403070203 varchar(30) NULL COMMENT “”,
C01030403070204 varchar(30) NULL COMMENT “”,
C010304030703 varchar(30) NULL COMMENT “”,
C010304030704 varchar(30) NULL COMMENT “”,
C0103040308 varchar(30) NULL COMMENT “”,
C010304030801 varchar(100) NULL COMMENT “”,
C010304030802 varchar(30) NULL COMMENT “”,
C010304030803 varchar(30) NULL COMMENT “”,
C010304030804 varchar(30) NULL COMMENT “”,
C0103040309 varchar(30) NULL COMMENT “”,
C010304030901 varchar(30) NULL COMMENT “”,
C0103040310 varchar(30) NULL COMMENT “”,
C010304031001 varchar(30) NULL COMMENT “”,
C01030403100101 varchar(30) NULL COMMENT “”,
C0103040310010101 varchar(30) NULL COMMENT “”,
C0103040310010102 varchar(30) NULL COMMENT “”,
C0103040310010103 varchar(30) NULL COMMENT “”,
C0103040310010104 varchar(30) NULL COMMENT “”,
C0103040310010105 varchar(30) NULL COMMENT “”,
C01030403100102 varchar(30) NULL COMMENT “”,
C0103040310010201 varchar(30) NULL COMMENT “”,
C01030404 varchar(30) NULL COMMENT “”,
C0103040401 varchar(30) NULL COMMENT “”,
C0103040402 varchar(30) NULL COMMENT “”,
C0103040403 varchar(30) NULL COMMENT “”,
C0103040404 varchar(30) NULL COMMENT “”,
C010304040401 varchar(30) NULL COMMENT “”,
C01030404040101 varchar(30) NULL COMMENT “”,
C01030404040102 varchar(30) NULL COMMENT “”,
C01030404040103 varchar(30) NULL COMMENT “”,
C01030404040104 varchar(30) NULL COMMENT “”,
C010304040402 varchar(30) NULL COMMENT “”,
C01030404040201 varchar(30) NULL COMMENT “”,
C01030404040202 varchar(30) NULL COMMENT “”,
C01030404040203 varchar(30) NULL COMMENT “”,
C0103040405 varchar(30) NULL COMMENT “”,
C0103040406 varchar(30) NULL COMMENT “”,
C0103040407 varchar(30) NULL COMMENT “”,
C0103040408 varchar(30) NULL COMMENT “”,
C01030405 varchar(30) NULL COMMENT “”,
C0103040501 varchar(30) NULL COMMENT “”,
C0103040502 varchar(30) NULL COMMENT “”,
C0103040503 varchar(30) NULL COMMENT “”,
C0103040504 varchar(30) NULL COMMENT “”,
C010304050401 varchar(30) NULL COMMENT “”,
C010304050402 varchar(30) NULL COMMENT “”,
C010304050403 varchar(30) NULL COMMENT “”,
C010304050404 varchar(30) NULL COMMENT “”,
C0103040505 varchar(30) NULL COMMENT “”,
C0103040506 varchar(30) NULL COMMENT “”,
C0103040507 varchar(30) NULL COMMENT “”,
C010304050701 varchar(30) NULL COMMENT “”,
C01030405070101 varchar(30) NULL COMMENT “”,
C01030405070102 varchar(30) NULL COMMENT “”,
C0103040507010201 varchar(30) NULL COMMENT “”,
C01030406 varchar(30) NULL COMMENT “”,
C0103040601 varchar(30) NULL COMMENT “”,
C0103040602 varchar(100) NULL COMMENT “”,
C0103040603 varchar(30) NULL COMMENT “”,
C0103040604 varchar(30) NULL COMMENT “”,
C0103040605 varchar(30) NULL COMMENT “”,
C01030407 varchar(30) NULL COMMENT “”,
C0103040701 varchar(30) NULL COMMENT “”,
C0103040702 varchar(30) NULL COMMENT “”,
C0103040703 varchar(30) NULL COMMENT “”,
C0103040704 varchar(30) NULL COMMENT “”,
C0103040705 varchar(30) NULL COMMENT “”,
C01030408 varchar(30) NULL COMMENT “”,
C0103040801 varchar(30) NULL COMMENT “”,
C0103040802 varchar(30) NULL COMMENT “”,
C0103040803 varchar(30) NULL COMMENT “”,
C0103040804 varchar(30) NULL COMMENT “”,
C0104 varchar(30) NULL COMMENT “”,
C010401 varchar(30) NULL COMMENT “”,
C01040101 varchar(30) NULL COMMENT “”,
C01040102 varchar(30) NULL COMMENT “”,
C01040103 varchar(30) NULL COMMENT “”,
C01040104 varchar(255) NULL COMMENT “”,
C01040105 varchar(30) NULL COMMENT “”,
C01040106 varchar(30) NULL COMMENT “”,
C01040107 varchar(30) NULL COMMENT “”,
C01040108 varchar(30) NULL COMMENT “”,
C0104010801 varchar(30) NULL COMMENT “”,
C0104010802 varchar(30) NULL COMMENT “”,
C01040109 varchar(30) NULL COMMENT “”,
C01040110 varchar(30) NULL COMMENT “”,
C0104011001 varchar(100) NULL COMMENT “”,
C010402 varchar(60) NULL COMMENT “”,
C010403 varchar(300) NULL COMMENT “”,
C01040301 varchar(100) NULL COMMENT “”,
C01040302 varchar(30) NULL COMMENT “”,
C01040303 varchar(30) NULL COMMENT “”,
C01040304 varchar(30) NULL COMMENT “”,
C01040305 varchar(30) NULL COMMENT “”,
C01040306 varchar(30) NULL COMMENT “”,
C01040307 varchar(30) NULL COMMENT “”,
C01040308 varchar(30) NULL COMMENT “”,
C0104030801 varchar(30) NULL COMMENT “”,
C010403080101 varchar(30) NULL COMMENT “”,
C010403080102 varchar(30) NULL COMMENT “”,
C010403080103 varchar(30) NULL COMMENT “”,
C010403080104 varchar(30) NULL COMMENT “”,
C010403080105 varchar(30) NULL COMMENT “”,
C010404 varchar(30) NULL COMMENT “”,
C01040401 varchar(30) NULL COMMENT “”,
C01040402 varchar(30) NULL COMMENT “”,
C0104040201 varchar(30) NULL COMMENT “”,
C01040403 varchar(30) NULL COMMENT “”,
C01040404 varchar(30) NULL COMMENT “”,
C01040405 varchar(30) NULL COMMENT “”,
C01040406 varchar(30) NULL COMMENT “”,
C010405 varchar(100) NULL COMMENT “”,
C0105 varchar(30) NULL COMMENT “”,
C010501 varchar(30) NULL COMMENT “”,
C01050101 varchar(300) NULL COMMENT “”,
C01050102 varchar(30) NULL COMMENT “”,
C010502 varchar(30) NULL COMMENT “”,
C010503 varchar(30) NULL COMMENT “”,
C010504 varchar(30) NULL COMMENT “”,
C01050401 varchar(100) NULL COMMENT “”,
C010505 varchar(30) NULL COMMENT “”,
C01050501 varchar(30) NULL COMMENT “”,
C01050502 varchar(30) NULL COMMENT “”,
C01050503 varchar(30) NULL COMMENT “”,
C010506 varchar(100) NULL COMMENT “”,
C010507 varchar(30) NULL COMMENT “”,
C01050701 varchar(30) NULL COMMENT “”,
C0105070101 varchar(100) NULL COMMENT “”,
C01050702 varchar(30) NULL COMMENT “”,
C0105070201 varchar(30) NULL COMMENT “”,
C01050703 varchar(30) NULL COMMENT “”,
C0105070301 varchar(30) NULL COMMENT “”,
C0105070302 varchar(30) NULL COMMENT “”,
C010508 varchar(30) NULL COMMENT “”,
C01050801 varchar(30) NULL COMMENT “”,
C01050802 varchar(30) NULL COMMENT “”,
C01050803 varchar(30) NULL COMMENT “”,
C01050804 varchar(30) NULL COMMENT “”,
C0105080401 varchar(30) NULL COMMENT “”,
C01050805 varchar(30) NULL COMMENT “”,
C01050806 varchar(100) NULL COMMENT “”,
C010509 varchar(30) NULL COMMENT “”,
C01050901 varchar(30) NULL COMMENT “”,
C0105090101 varchar(30) NULL COMMENT “”,
C01050902 varchar(30) NULL COMMENT “”,
C0105090201 varchar(30) NULL COMMENT “”,
C01050903 varchar(30) NULL COMMENT “”,
C0105090301 varchar(30) NULL COMMENT “”,
C01050904 varchar(30) NULL COMMENT “”,
C01050905 varchar(30) NULL COMMENT “”,
C0105090501 varchar(30) NULL COMMENT “”,
C01050906 varchar(30) NULL COMMENT “”,
C01050907 varchar(30) NULL COMMENT “”,
C01050908 varchar(30) NULL COMMENT “”,
C01050909 varchar(30) NULL COMMENT “”,
C01050910 varchar(30) NULL COMMENT “”,
C01050911 varchar(30) NULL COMMENT “”,
C01050912 varchar(30) NULL COMMENT “”,
C01050913 varchar(30) NULL COMMENT “”,
C010510 varchar(30) NULL COMMENT “”,
C01051001 varchar(30) NULL COMMENT “”,
C0105100101 varchar(30) NULL COMMENT “”,
C0105100102 varchar(100) NULL COMMENT “”,
C0105100103 varchar(30) NULL COMMENT “”,
C01051002 varchar(30) NULL COMMENT “”,
C0105100201 varchar(30) NULL COMMENT “”,
C0105100202 varchar(30) NULL COMMENT “”,
C01051003 varchar(30) NULL COMMENT “”,
C0105100301 varchar(30) NULL COMMENT “”,
C01051004 varchar(30) NULL COMMENT “”,
C0105100401 varchar(30) NULL COMMENT “”,
C01051005 varchar(30) NULL COMMENT “”,
C0105100501 varchar(100) NULL COMMENT “”,
C01051006 varchar(30) NULL COMMENT “”,
C0105100601 varchar(100) NULL COMMENT “”,
C01051007 varchar(30) NULL COMMENT “”,
C0105100701 varchar(100) NULL COMMENT “”,
C0105100702 varchar(30) NULL COMMENT “”,
C0105100703 varchar(30) NULL COMMENT “”,
C010511 varchar(30) NULL COMMENT “”,
C01051101 varchar(30) NULL COMMENT “”,
C01051102 varchar(30) NULL COMMENT “”,
C01051103 varchar(30) NULL COMMENT “”,
C0105110301 varchar(30) NULL COMMENT “”,
C010511030101 varchar(30) NULL COMMENT “”,
C010511030102 varchar(30) NULL COMMENT “”,
C010511030103 varchar(30) NULL COMMENT “”,
C0105110302 varchar(30) NULL COMMENT “”,
C010511030201 varchar(30) NULL COMMENT “”,
C010511030202 varchar(60) NULL COMMENT “”,
C010511030203 varchar(100) NULL COMMENT “”,
C010511030204 varchar(30) NULL COMMENT “”,
C010511030205 varchar(30) NULL COMMENT “”,
C01051103020501 varchar(30) NULL COMMENT “”,
C0105110302050101 varchar(30) NULL COMMENT “”,
C0105110302050102 varchar(30) NULL COMMENT “”,
C0105110302050103 varchar(30) NULL COMMENT “”,
C010511030206 varchar(30) NULL COMMENT “”,
C01051103020601 varchar(100) NULL COMMENT “”,
C0105110302060101 varchar(100) NULL COMMENT “”,
C0105110302060102 varchar(30) NULL COMMENT “”,
C010511030207 varchar(30) NULL COMMENT “”,
C01051103020701 varchar(30) NULL COMMENT “”,
C0105110303 varchar(30) NULL COMMENT “”,
C010511030301 varchar(30) NULL COMMENT “”,
C010511030302 varchar(30) NULL COMMENT “”,
C010511030303 varchar(500) NULL COMMENT “”,
C010511030304 varchar(800) NULL COMMENT “”,
C0105110304 varchar(30) NULL COMMENT “”,
C010511030401 varchar(30) NULL COMMENT “”,
C010511030402 varchar(30) NULL COMMENT “”,
C010512 varchar(30) NULL COMMENT “”,
C01051201 varchar(30) NULL COMMENT “”,
C0105120101 varchar(30) NULL COMMENT “”,
C010512010101 varchar(30) NULL COMMENT “”,
C010512010102 varchar(30) NULL COMMENT “”,
C010512010103 varchar(30) NULL COMMENT “”,
C01051202 varchar(30) NULL COMMENT “”,
C0105120201 varchar(30) NULL COMMENT “”,
C010512020101 varchar(30) NULL COMMENT “”,
C010512020102 varchar(30) NULL COMMENT “”,
C010512020103 varchar(30) NULL COMMENT “”,
C01051203 varchar(30) NULL COMMENT “”,
C0105120301 varchar(30) NULL COMMENT “”,
C010512030101 varchar(30) NULL COMMENT “”,
C010512030102 varchar(30) NULL COMMENT “”,
C010512030103 varchar(30) NULL COMMENT “”,
C01051204 varchar(30) NULL COMMENT “”,
C0105120401 varchar(30) NULL COMMENT “”,
C010512040101 varchar(30) NULL COMMENT “”,
C010512040102 varchar(30) NULL COMMENT “”,
C010512040103 varchar(30) NULL COMMENT “”,
C01051205 varchar(30) NULL COMMENT “”,
C0105120501 varchar(30) NULL COMMENT “”,
C0105120502 varchar(30) NULL COMMENT “”,
C0105120503 varchar(30) NULL COMMENT “”,
REGISTER_TIME varchar(30) NULL COMMENT “”,
STATUS varchar(30) NULL COMMENT “”,
BATCH varchar(20) NULL COMMENT “”,
CENTER_ID int(11) NULL COMMENT “”,
IS_LOCK_DATA tinyint(4) NULL COMMENT “”,
CREATED_AT datetime NULL COMMENT “”,
ID_VALID tinyint(4) NULL COMMENT “”,
MD5IDCARD varchar(50) NULL COMMENT “”,
C0102070201 varchar(300) NULL COMMENT “”,
C01051008 varchar(2) NULL COMMENT “是否脂蛋白”,
C0105100801 varchar(20) NULL COMMENT “脂蛋白数值”,
C0105100802 varchar(2) NULL COMMENT “脂蛋白单位”,
C01051009 varchar(2) NULL COMMENT “是否糖化血红蛋白”,
C0105100901 varchar(20) NULL COMMENT “糖化血红蛋白数值”
) ENGINE=OLAP
PRIMARY KEY(UNIQUE_ID, VESTING_DATE)
COMMENT “胸痛科研表”
PARTITION BY RANGE(VESTING_DATE)
(PARTITION p1899 VALUES [(“1899-01-01”), (“1899-01-02”)),
PARTITION p1900 VALUES [(“1899-01-02”), (“2016-01-01”)),
PARTITION p2017 VALUES [(“2016-01-01”), (“2018-01-01”)),
PARTITION p2018 VALUES [(“2018-01-01”), (“2021-01-01”)),
PARTITION p2021 VALUES [(“2021-01-01”), (“2023-01-01”)),
PARTITION p2023 VALUES [(“2023-01-01”), (“2025-01-01”)),
PARTITION p2025 VALUES [(“2025-01-01”), (“2027-01-01”)),
PARTITION p2027 VALUES [(“2027-01-01”), (“2029-01-01”)),
PARTITION p2029 VALUES [(“2029-01-01”), (“2031-01-01”)))
DISTRIBUTED BY HASH(UNIQUE_ID) BUCKETS 18
PROPERTIES (
“compression” = “LZ4”,
“enable_persistent_index” = “true”,
“fast_schema_evolution” = “false”,
“replicated_storage” = “true”,
“replication_num” = “3”
);

#2

insert into select 到另一个表，看看还有没有问题，可能是 short key index 写入有问题索引错误，可以升级重新导一下这个表

京ICP备2022026421号-1