FlinkCDAS同步starrrocks，varchar超长导致数据同步失败

最新推荐文章于 2024-09-11 10:46:35 发布
最新推荐文章于 2024-09-11 10:46:35 发布
阅读量1.4k 收藏 1
点赞数
分类专栏： Flink 文章标签： 数据库 mysql apache
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/m0_66705151/article/details/129461278
版权

FlinkCDAS同步starrrocks，varchar超长导致数据同步失败

使用FlinkCDAS同步mysql数据到starrocks时，报org.apache.flink.table.api.TableException: Failed to deserialize the input record，看异常栈根源是starrocks入库异常，报too many filtered rows，同步的数据中存在异常行，被过滤了，无法正常入库。

org.apache.flink.table.api.TableException: Failed to deserialize the input record: SourceRecord{sourcePartition={server=mysql_binlog_source}, sourceOffset={transaction_id=null, ts_sec=1678505077, file=, pos=0}} ConnectRecord{topic='mysql_binlog_source.dd.tableee', kafkaPartition=null, key=Struct{id=6031202774149}, keySchema=Schema{mysql_binlog_source.db.tableee.Key:STRUCT}, value=Struct{after=Struct{id=60312027,name=Ad from a Page post #6,031,202,774,149,run_status=,object_id=0,object_story_id=,effective_object_story_id=1693370527557087_1764951593732313,object_story_spec={"page_id":"1693370527557087","link_data":{"name":"Segredos para usu\u00e1rios Samsung!","image_hash":"efb4d7d867876aa44d33a4ba3b8e12adgb","call_to_action":{"type":"INSTALL_MOBILE_APP"}}},body=,image_hash=,image_file=,image_url=,image_crops=,video_id=,actor_image_hash=,link_url=,object_url=,url_tags=,preview_url=,thumbnail_url=,follow_redirect=,object_store_url=,link_deep_link_url=,call_to_action_type=,object_type=,product_set_id=,adlabels=,applink_treatment=,dynamic_ad_voice=,place_page_set_id=0,instagram_actor_id=0,instagram_permalink_url=,template_url=,object_instagram_id=0,link_og_id=,instagram_story_id=,zipbytes=,copy_from=,asset_feed_spec=,created_time=1655725861000,updated_time=1667633606000,page_id=1693370527557087},source=Struct{version=1.6.4.Final,connector=mysql,name=mysql_binlog_source,ts_ms=0,db=db,table=creative,server_id=0,file=,pos=0,row=0},op=r,ts_ms=1678505077334}, valueSchema=Schema{mysql_binlog_source.db.tableee.Envelope:STRUCT}, timestamp=null, headers=ConnectHeaders(headers=)}.
	at com.ververica.cdc.debezium.table.RowDataDebeziumDeserializeSchema.deserialize(RowDataDebeziumDeserializeSchema.java:150)
	at com.ververica.cdc.connectors.mysql.source.MySqlEvolvingSourceDeserializeSchema.deserialize(MySqlEvolvingSourceDeserializeSchema.java:143)
	at com.ververica.cdc.connectors.mysql.source.reader.MySqlRecordEmitter.emitElement(MySqlRecordEmitter.java:131)
	at com.ververica.cdc.connectors.mysql.source.reader.MySqlRecordEmitter.processElement(MySqlRecordEmitter.java:111)
	at com.ververica.cdc.connectors.mysql.source.reader.MySqlRecordEmitter.emitRecord(MySqlRecordEmitter.java:83)
	at com.ververica.cdc.connectors.mysql.source.reader.MySqlRecordEmitter.emitRecord(MySqlRecordEmitter.java:56)
	at org.apache.flink.connector.base.source.reader.SourceReaderBase.pollNext(SourceReaderBase.java:159)
	at org.apache.flink.streaming.api.operators.SourceOperator.emitNext(SourceOperator.java:385)
	at org.apache.flink.streaming.runtime.io.StreamTaskSourceInput.emitNext(StreamTaskSourceInput.java:70)
	at org.apache.flink.streaming.runtime.io.StreamOneInputProcessor.processInput(StreamOneInputProcessor.java:68)
	at org.apache.flink.streaming.runtime.tasks.StreamTask.processInput(StreamTask.java:641)
	at org.apache.flink.streaming.runtime.tasks.mailbox.MailboxProcessor.runMailboxLoop(MailboxProcessor.java:203)
	at org.apache.flink.streaming.runtime.tasks.StreamTask.runMailboxLoop(StreamTask.java:1079)
	at org.apache.flink.streaming.runtime.tasks.StreamTask.invoke(StreamTask.java:1028)
	at org.apache.flink.runtime.taskmanager.Task.runWithSystemExitMonitoring(Task.java:954)
	at org.apache.flink.runtime.taskmanager.Task.restoreAndInvoke(Task.java:933)
	at org.apache.flink.runtime.taskmanager.Task.doRun(Task.java:746)
	at org.apache.flink.runtime.taskmanager.Task.run(Task.java:568)
	at java.lang.Thread.run(Thread.java:834)
	Suppressed: java.lang.RuntimeException: Writing records to StarRocks failed.
		at com.starrocks.connector.flink.manager.StarRocksSinkManager.checkFlushException(StarRocksSinkManager.java:396)
		at com.starrocks.connector.flink.manager.StarRocksSinkManager.close(StarRocksSinkManager.java:285)
		at com.starrocks.connector.flink.table.sink.StarRocksDynamicSinkFunction.close(StarRocksDynamicSinkFunction.java:242)
		at org.apache.flink.api.common.functions.util.FunctionUtils.closeFunction(FunctionUtils.java:41)
		at org.apache.flink.streaming.api.operators.AbstractUdfStreamOperator.close(AbstractUdfStreamOperator.java:114)
		at org.apache.flink.streaming.runtime.tasks.StreamOperatorWrapper.close(StreamOperatorWrapper.java:163)
		at org.apache.flink.streaming.runtime.tasks.RegularOperatorChain.closeAllOperators(RegularOperatorChain.java:125)
		at org.apache.flink.streaming.runtime.tasks.StreamTask.closeAllOperators(StreamTask.java:1272)
		at org.apache.flink.util.IOUtils.closeAll(IOUtils.java:254)
		at org.apache.flink.core.fs.AutoCloseableRegistry.doClose(AutoCloseableRegistry.java:72)
		at org.apache.flink.util.AbstractAutoCloseableRegistry.close(AbstractAutoCloseableRegistry.java:127)
		at org.apache.flink.streaming.runtime.tasks.StreamTask.cleanUp(StreamTask.java:1191)
		at org.apache.flink.runtime.taskmanager.Task.lambda$restoreAndInvoke$0(Task.java:936)
		at org.apache.flink.runtime.taskmanager.Task.runWithSystemExitMonitoring(Task.java:954)
		at org.apache.flink.runtime.taskmanager.Task.restoreAndInvoke(Task.java:936)
		... 3 more
	Caused by: com.starrocks.connector.flink.manager.StarRocksStreamLoadFailedException: Failed to flush data to StarRocks, Error response: 
{"Status":"Fail","BeginTxnTimeMs":0,"Message":"too many filtered rows","NumberUnselectedRows":0,"CommitAndPublishTimeMs":0,"Label":"3ecfb766-d4c0-4a4a-9ace-139e74e39f4a","LoadBytes":51839093,"StreamLoadPlanTimeMs":0,"NumberTotalRows":48570,"WriteDataTimeMs":471,"TxnId":2805956,"LoadTimeMs":473,"ErrorURL":"http://192.16.61.113:8040/api/_load_error_log?file=error_log_3542ac0c208e8ddc_b712c1cb407f85b9","ReadDataTimeMs":52,"NumberLoadedRows":48566,"NumberFilteredRows":4}
{"streamLoadErrorLog":"Error: NULL value in non-nullable column 'name'. Row: [6004092296930, '', 170703647, 6004092298930, 0, '', '', NULL, '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', '', 0, '', '', '', '', NULL, '', 2022-11-01 14:53:25, 2022-11-01 14:53:25, 0, 0]\nError: NULL value in non-nullable column 'name'. Row: [6004092297130, '', 170703647, 6004092299930, 0, '', '', NULL, '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', '', 0, '', '', '', '', NULL, '', 2022-11-01 14:53:25, 2022-11-01 14:53:25, 0, 0]\nError: NULL value in non-nullable column 'name'. Row: [6004092297730, '', 170703647, 6004092301330, 0, '', '', NULL, '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', '', 0, '', '', '', '', NULL, '', 2022-11-01 14:53:25, 2022-11-01 14:53:25, 0, 0]\nError: NULL value in non-nullable column 'name'. Row: [6004092304530, '', 170703647, 6004092304930, 0, '', '', NULL, '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', '', 0, '', '', '', '', NULL, '', 2022-11-01 14:53:25, 2022-11-01 14:53:25, 0, 0]\n"}

		at com.starrocks.connector.flink.manager.StarRocksStreamLoadVisitor.doStreamLoad(StarRocksStreamLoadVisitor.java:105)
		at com.starrocks.connector.flink.manager.StarRocksSinkManager.asyncFlush(StarRocksSinkManager.java:320)
		at com.starrocks.connector.flink.manager.StarRocksSinkManager.lambda$startAsyncFlushing$0(StarRocksSinkManager.java:162)
		... 1 more
Caused by: org.apache.flink.streaming.runtime.tasks.ExceptionInChainedOperatorException: Could not forward element to next operator
	at org.apache.flink.streaming.runtime.tasks.ChainingOutput.pushToOperator(ChainingOutput.java:101)
	at org.apache.flink.streaming.runtime.tasks.ChainingOutput.collect(ChainingOutput.java:80)
	at org.apache.flink.streaming.runtime.tasks.ChainingOutput.collect(ChainingOutput.java:39)
	at org.apache.flink.streaming.runtime.tasks.SourceOperatorStreamTask$AsyncDataOutputToOutput.emitRecord(SourceOperatorStreamTask.java:313)
	at org.apache.flink.streaming.api.operators.source.SourceOutputWithWatermarks.collect(SourceOutputWithWatermarks.java:110)
	at org.apache.flink.streaming.api.operators.source.SourceOutputWithWatermarks.collect(SourceOutputWithWatermarks.java:101)
	at com.ververica.cdc.connectors.mysql.source.reader.MySqlRecordEmitter$OutputCollector.collect(MySqlRecordEmitter.java:168)
	at com.ververica.cdc.connectors.mysql.source.MySqlEvolvingSourceDeserializeSchema$SimpleCollector.collect(MySqlEvolvingSourceDeserializeSchema.java:236)
	at com.ververica.cdc.connectors.mysql.source.MySqlEvolvingSourceDeserializeSchema$SimpleCollector.collect(MySqlEvolvingSourceDeserializeSchema.java:227)
	at com.ververica.cdc.debezium.table.AppendMetadataCollector.collect(AppendMetadataCollector.java:51)
	at com.ververica.cdc.debezium.table.AppendSystemColumnAndMetadataCollector.collect(AppendSystemColumnAndMetadataCollector.java:43)
	at com.ververica.cdc.debezium.table.RowDataDebeziumDeserializeSchema.emit(RowDataDebeziumDeserializeSchema.java:169)
	at com.ververica.cdc.debezium.table.RowDataDebeziumDeserializeSchema.deserialize(RowDataDebeziumDeserializeSchema.java:130)
	... 18 more
Caused by: org.apache.flink.streaming.runtime.tasks.ExceptionInChainedOperatorException: Could not forward element to next operator
	at org.apache.flink.streaming.runtime.tasks.ChainingOutput.pushToOperator(ChainingOutput.java:101)
	at org.apache.flink.streaming.runtime.tasks.ChainingOutput.collect(ChainingOutput.java:80)
	at org.apache.flink.streaming.runtime.tasks.ChainingOutput.collect(ChainingOutput.java:39)
	at org.apache.flink.streaming.runtime.tasks.CopyingBroadcastingOutputCollector.collect(CopyingBroadcastingOutputCollector.java:40)
	at org.apache.flink.streaming.runtime.tasks.CopyingBroadcastingOutputCollector.collect(CopyingBroadcastingOutputCollector.java:28)
	at org.apache.flink.streaming.api.operators.CountingOutput.collect(CountingOutput.java:56)
	at org.apache.flink.streaming.api.operators.CountingOutput.collect(CountingOutput.java:29)
	at org.apache.flink.table.runtime.operators.evolution.SchemaEvolutionOperator.processElement(SchemaEvolutionOperator.java:171)
	at org.apache.flink.streaming.runtime.tasks.ChainingOutput.pushToOperator(ChainingOutput.java:99)
	... 30 more
Caused by: org.apache.flink.streaming.runtime.tasks.ExceptionInChainedOperatorException: Could not forward element to next operator
	at org.apache.flink.streaming.runtime.tasks.ChainingOutput.pushToOperator(ChainingOutput.java:101)
	at org.apache.flink.streaming.runtime.tasks.ChainingOutput.collect(ChainingOutput.java:80)
	at org.apache.flink.streaming.runtime.tasks.ChainingOutput.collect(ChainingOutput.java:39)
	at org.apache.flink.streaming.api.operators.CountingOutput.collect(CountingOutput.java:56)
	at org.apache.flink.streaming.api.operators.CountingOutput.collect(CountingOutput.java:29)
	at org.apache.flink.streaming.api.operators.StreamFilter.processElement(StreamFilter.java:39)
	at org.apache.flink.streaming.runtime.tasks.ChainingOutput.pushToOperator(ChainingOutput.java:99)
	... 38 more
Caused by: java.lang.RuntimeException: Writing records to StarRocks failed.
	at com.starrocks.connector.flink.manager.StarRocksSinkManager.checkFlushException(StarRocksSinkManager.java:396)
	at com.starrocks.connector.flink.manager.StarRocksSinkManager.writeRecords(StarRocksSinkManager.java:215)
	at com.starrocks.connector.flink.table.sink.StarRocksDynamicSinkFunction.invoke(StarRocksDynamicSinkFunction.java:198)
	at org.apache.flink.table.runtime.operators.sink.SinkOperator.processElement(SinkOperator.java:68)
	at org.apache.flink.streaming.runtime.tasks.ChainingOutput.pushToOperator(ChainingOutput.java:99)
	... 44 more
	[CIRCULAR REFERENCE:com.starrocks.connector.flink.manager.StarRocksStreamLoadFailedException: Failed to flush data to StarRocks, Error response: 
{"Status":"Fail","BeginTxnTimeMs":0,"Message":"too many filtered rows","NumberUnselectedRows":0,"CommitAndPublishTimeMs":0,"Label":"3ecfb766-d4c0-4a4a-9ace-139e74e39f4a","LoadBytes":51839093,"StreamLoadPlanTimeMs":0,"NumberTotalRows":48570,"WriteDataTimeMs":471,"TxnId":2805956,"LoadTimeMs":473,"ErrorURL":"http://192.16.61.123:8040/api/_load_error_log?file=error_log_3542ac0c208e8ddc_b712c1cb407f85b9","ReadDataTimeMs":52,"NumberLoadedRows":48566,"NumberFilteredRows":4}
{"streamLoadErrorLog":"Error: NULL value in non-nullable column 'name'. Row: [6004092296930, '', 170703647, 6004092298930, 0, '', '', NULL, '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', '', 0, '', '', '', '', NULL, '', 2022-11-01 14:53:25, 2022-11-01 14:53:25, 0, 0]\nError: NULL value in non-nullable column 'name'. Row: [6004092297130, '', 170703647, 6004092299930, 0, '', '', NULL, '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', '', 0, '', '', '', '', NULL, '', 2022-11-01 14:53:25, 2022-11-01 14:53:25, 0, 0]\nError: NULL value in non-nullable column 'name'. Row: [6004092297730, '', 170703647, 6004092301330, 0, '', '', NULL, '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', '', 0, '', '', '', '', NULL, '', 2022-11-01 14:53:25, 2022-11-01 14:53:25, 0, 0]\nError: NULL value in non-nullable column 'name'. Row: [6004092304530, '', 170703647, 6004092304930, 0, '', '', NULL, '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', '', 0, '', '', '', '', NULL, '', 2022-11-01 14:53:25, 2022-11-01 14:53:25, 0, 0]\n"}
]

通过starrocks返回的ErrorURL查看starrocks的异常日志。提示非空字段name存在空值。通过主键id反查mysqli源表的记录，发现name值是存在的。一开始怀疑是name的映射不对，但比较ddl发现是一致的。后来通过flink sql debug，发现是name值的字符长度超长，导致sink starrrocoks时被置空，最终导致入库异常。

Error: NULL value in non-nullable column 'name'. Row: [6004092296930, '', 170703647, 6004092298930, 0, '', '', NULL, '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', '', 0, '', '', '', '', NULL, '', 2022-11-01 14:53:25, 2022-11-01 14:53:25, 0, 0]

源表和starrocks表中name的定义为name varchar(20) not null。但实际写入的name值超过了20.修改starrocks的name定义，字符长度大于mysql中name的最长字符值即可。

flink 写入 starrocks 报错 too many filtered rows attachment
yy的博客
11-10 1092
把你starrocks中DDL里的varchar(...) 先修改为STRING. 一般是因为字段超出定义的长度.
数据集成时表模型同步方法解析
01-17
在数据模型同步中，需要考虑到数据的格式和类型，例如，使用VARCHAR、BOOLEAN、INT、DATE等类型来表示不同的数据字段。在Java中，可以使用java.sql.Types来指定这些类型。 同时，在数据模型同步中，也需要考虑到...
Flink往Starrocks写数据报错：too many filtered rows
SunnyRivers
11-06 1707
这个其实比较郁闷，你抛出的异常是过滤出太多行，与not null有什么关系呢？但是，当你把not null去掉后，发现很多too many filtered rows的bug都能解决了。这个时候你把最新的数据导入，可能会报上面的错。正当你以为你根据字面意思就知道bug的本质的时候，你会发现有些场景，你日期写的完全没有问题依然会报上面的错（说明这个starrocks源码写的不严谨）。比如你写的是tinyint，但实际来的值超过这个范围，就会报错too many filtered rows（真有点扯淡啊）。
MySQL 中定义的字符串长度跟 StarRocks 定义的是一致的吗？
最新发布
qq_34735262的博客
09-11 160
在 StarRocks 中，VARCHAR(n) 中的n代表字节数，而在 MySQL 中，VARCHAR(n) 中的 n 代表字符数。根据 UTF-8，1 个汉字等于 3 个字节。当 StarRocks 和 MySQL 将 n 定义成相同数字时，MySQL 保存的字符数是 StarRocks 的 3 倍。建议设置成4倍，兼容utf-5 mb4。
doris报错：too many filtered rows
海若_matrix的博客
04-12 1万+
1.报错场景 加载数据 [starcross@app1 FLink-test-LT]$ curl --location-trusted -u root:aba -T 'data_2022-04-11.csv' -H "label:testdoris201" -H "column_separator:," -XPUT http://10.22.33.69:8030/api/os/ws/_stream_load 2.报错内容 { "TxnId": 831311, "Label": "testd
Starrocks StreamLoad导入csv数据报错too many filtered rows
qq_42607505的博客
07-07 2901
【已解决】Starrocks StreamLoad导入csv数据报错too many filtered rows。
导入失败，报错：“too many filtered rows xxx, “ErrorURL“:“
eagle89的专栏
01-16 3250
[INTERNAL_ERROR]too many filtered rows",
大数据StarRocks(五) ：数据类型
运维仙人
01-06 3166
StarRocks 支持数据类型：数值类型、字符串类型、日期类型、半结构化类型、其他类型。您在建表时可以指定以下类型的列，向表中导入该类型的数据并查询数据。 5.1 数值类型 SMALLINT 2 字节有符号整数，范围 [-32768, 32767] INT 4 字节有符号整数，范围 [-2147483648, 2147483647] BIGINT 8 字节有符号整数，范围 [-9223372036854775808, 9223372036854775807] LARGEINT 16 字节有符号整
记录apache doris使用过程中出现的问题
热门推荐
qq_31866793的博客
10-28 3万+
1，执行创建语句过程中出现： [Err] 1064 - errCode = 2, detailMessage = Failed to find enough host in all backends. need: 3 原因： 语句中指定了PROPERTIES("replication_num" = "3"); 结果BE只有2个： 查看对应节点的日志：. ==> ./be.WARNING.log.20200921-141304 <== W1026 18:13:39.1399..
MYSQL和MSSQL会员同步.rar_mssql_mysql和MSSQL同步_会员_会员数据_数据同步
09-23
当涉及到跨数据库的数据同步时，特别是在会员系统中，确保数据的一致性和完整性至关重要。本文将深入探讨MySQL和MSSQL之间的会员数据同步方法和相关知识点。 1. **数据同步需求**：在多数据库环境中，如同时使用...
MySQL中VARCHAR与CHAR格式数据的区别
12-15
在MySQL数据库中，CHAR和VARCHAR是两种常用的字符串数据类型，它们在存储和处理方式上有着显著的区别，这对于数据库设计和优化至关重要。 首先，CHAR是一种固定长度的字符串类型。这意味着无论你存储的实际数据有多...
MySQL数据类型varchar详解
09-10
MySQL中的`VARCHAR`数据类型是用于存储可变长度的字符串数据的，它的主要优势在于空间效率，因为它只存储实际输入的字符数量，不像`CHAR`数据类型会预留固定长度的空间。下面将详细介绍`VARCHAR`的逻辑意义、最大...
如何在两个SQLSERVER之间数据同步
06-27
### 如何在两个SQLSERVER之间实现数据同步 在IT领域，特别是对于企业级应用而言，数据同步是一项重要的技术，能够确保不同地理位置的数据中心之间数据的一致性和可用性。本文将详细介绍如何通过SQL Server的复制...
StarRocks-生产环境问题集锦
weixin_45943866的博客
03-21 5128
实时平台设计方案将最终目的数据库更换为StarRocks,使用后的感受简直就是更快更高更强，但在开发使用过程中也遇到了一些小问题(以下问题均出现在Flink写入StarRocks架构中).
Flink CDC 如何简化数据入湖
weixin_52268321的博客
03-21 2602
1 概述 CDC 的全称： Change Data Capture 。在广义的概念上，只要是能捕获数据变更的技术，都可以称之为CDC。目前通常描述的 CDC 技术主要面向数据库的变更，是一种用于捕获数据库中数据变更的技术 数据湖： 数据湖是一个集中式存储库，允许以任意规模存储所有结构化和非结构化数据。可以按原样存储数据（无需先对数据进行结构化处理），并运行不同类型的分析 – 从控制面板和可视化到大数据处理、实时分析和机器学习，以指导做出更好的决策。 2 Flink CDC 性能测试 阿里巴巴技术专家—伍翀(
第3.2章：StarRocks数据导入--Stream Load
流木的博客
02-09 1万+
一、环境准备 Stream Load可以说是StarRocks最为核心的导入方式，StarRocks的主要导入方式例如Routine Load、Flink Connector、DataX StarRocksWriter等，底层实现都是基于Stream Load的思想，所以我们着重介绍。 Stream Load是由用户发送HTTP请求将本地文件或数据流导入至StarRocks中的导入方式，其本身不依赖其他组件。Stream Load支持导入本地数据文件（csv、txt等）和json文件，建议单次导入的数据
【无标题】Doris报错 （too many filtered rows）
ShiXZ213的博客
10-28 2870
doris
数据库varchar长度对效率的影响
qq_28094373的博客
10-18 2884
开发中发现某个表varchar长度被定为600、2000等较大的长度。 虽然varchar在存储相同字符时占用大小是一样的，但是mysql在存储时会分配一定大小的内存块来存储，导致查询时效率非常差。 将长度改为适应大小后，查询时间减少一半以上 ...
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值