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 >
