Doris内存持续增长(version-0.14.7)
hi~ 最近上线部署了一套doris（0.14.7）运行了近一个月，只通过streamload写入数据还没有执行查询，但内存一直稳步增长中 be.conf中配置的mem_limit = 50%，貌似没生效， 中间重启后，暂停写入操作 内存使用率也保持着没有下降 请问是否有修复方式 或是 可以通过升级版本解决？
回复: Doris内存持续增长(version-0.14.7)
hi~ 最近上线部署了一套doris（0.14.7）运行了近一个月，只通过streamload写入数据还没有执行查询，但内存一直稳步增长达到90%以上（256的内存） be.conf中配置的mem_limit = 50%，貌似没生效， 中间重启后，暂停写入操作 内存使用率也保持着没有下降 请问是否有修复方式 或是 可以通过升级版本解决？ - To unsubscribe, e-mail: dev-unsubscr...@doris.apache.org For additional commands, e-mail: dev-h...@doris.apache.org
MySQL client queries whether there is a limit of 65535 records for export?
Hi, is there a parameter that limits the maximum number of records 65535 through MySQL client query export? The total number of records in a table is 14552989, but whether it is to query the full amount through tools or select * from table into outfile "file:////result_", The maximum results are only 65535. The data table is the aggregate model, 16buckets, and it is normal to export the unique model. count(`count`)| --+ 14552989| FileNumber|TotalRows|FileSize|URL | --+-++-+ 1|65535| 4472974|file:////result_6d366b7e25744ae0-89ff707424449356_| 姓名 ：张泽钦 公司 ：杭州东方通信软件技术有限公司 广东项目部 地址 ：广州市天河区珠江新城海安路13号越秀财富世纪广场A1栋1802 邮编 ：510627 手机 ：13414145631 Email：zhan...@eastcom-sw.com
Re: Re: MySQL client queries whether there is a limit of 65535 records for export?
It takes effect with the addition of limit, thanks you ~ From: Jianliang Qi Date: 2022-07-04 17:45 To: dev Subject: Re: MySQL client queries whether there is a limit of 65535 records for export? Hi, Doris defaults to adding `limit 65535 `to `order by` clause, if you want to order by more data you can manually write an `order by` with a larger number. Jianliang Qi On Mon, Jul 4, 2022 at 5:07 PM zhan...@eastcom-sw.com < zhan...@eastcom-sw.com> wrote: > >Hi, is there a parameter that limits the maximum number of records > 65535 through MySQL client query export? > >The total number of records in a table is 14552989, but whether it is > to query the full amount through tools or select * from table into outfile > "file:////result_", >The maximum results are only 65535. > >The data table is the aggregate model, 16buckets, and it is normal to > export the unique model. > > count(`count`)| > --+ > 14552989| > > FileNumber|TotalRows|FileSize|URL > | > > --+-++-+ > 1|65535| > 4472974|file:////result_6d366b7e25744ae0-89ff707424449356_| > > > > > 姓名 ：张泽钦 > 公司 ：杭州东方通信软件技术有限公司 广东项目部 > 地址 ：广州市天河区珠江新城海安路13号越秀财富世纪广场A1栋1802 > 邮编 ：510627 > 手机 ：13414145631 > Email：zhan...@eastcom-sw.com >
UNIQUE模型是否支持字段类型 REPLACE_IF_NOT_NULL
hi，我尝试在UNIQUE模型表两次steamload 相同Key各一半的字段
每次未传值的字段都会被替换为NULL，是否有属性配置只更新不为空的字段值？
t1: key, col1,col2
t2: key, col3,col4 此次会把col1,col2的值更新为null
尝试新加属性 ALTER TABLE tbl set ("replace_if_not_null" = "true");
返回异常： errCode = 2, detailMessage = Unknown table property:
[replace_if_not_null]
姓名 ：张泽钦
公司 ：杭州东方通信软件技术有限公司 广东项目部
地址 ：广州市天河区珠江新城海安路13号越秀财富世纪广场A1栋1802
邮编 ：510627
手机 ：13414145631
Email：zhan...@eastcom-sw.com
????: The official website launched
The new version of the official website has greatly improved the user experience ~ luzhijing ?? 2022-07-21 10:28 dev ?? The official website launched Hi, all The Doris official website has been launched doris.apache.org We will still have some work in the near future, such as blog updates, docs optimization, translation improvements, and welcome everyone contribute about it. -- -- ??: "luzhijing" <543881...@qq.com>; : 2022??7??14??(??) 9:54 ??: "dev"
