Re:The official website launched

2022-07-21 Thread Thomas Cai
Hi ZhiJing, I would like to participate into some works related with docu/translation optimizations. Please feel free to assign some tasks. Regards, Thomas 在 2022-07-21 10:28:35,"luzhijing" <543881...@qq.com.INVALID> 写道: >Hi, all > > >The Doris official website has been launched  doris.

Re:Re: [Discuss] Invite external collaborators with the triage role on GitHub

2022-02-28 Thread Thomas Cai
Hi MingYu, Thank you. I am not good at coding. But just let me know when having chances to collaborate. Best Regards, Thomas 在 2022-02-28 17:52:28,"陈明雨" 写道: >Hi zuochunwei and Thomas: > > >you guys have been added to the external collabators: >https://github.com/apache/incubator-doris

Re:Re:Re:Re: [Discuss] Invite external collaborators with the triage role on GitHub

2022-02-14 Thread Thomas Cai
+1 id:thomascai126 At 2022-02-12 10:26:57, "陈明雨" wrote: >Hi all: > > >Now there are 6 people who are willing to be collaborators, and all of them >are active contributor to Doris: > > >jackwener:https://github.com/apache/incubator-doris/pulls?q=is%3Apr+author%3Ajackwener+is%3Aclo

Re:[NOTICE] Move Flink/Doris Connectors and Manager to new github repo

2022-02-10 Thread Thomas Cai
Hi MingYu, Thanks for letting us know this. I believe it is helpful. Just found a small typing mistake in Doris Manager "About" portion as attached pic. It looks the same contents for Flink/Spart connectors. Regards, Thomas 在 2022-02-10 14:58:47,"陈明雨" 写道: >Hi all: >As we discussed

Re:Re: Data Load Issue by using Kettle

2021-11-03 Thread Thomas Cai
!Best Regards >> 陈明雨 Mingyu Chen >> >> Email: >> morning...@163.com; >> morningman@gmail.com >> >> >> >> >> >> At 2021-10-31 11:29:09, "Thomas Cai" wrote: >> >Dear All, >> > >> > >> >I

Re:Re:Data Load Issue by using Kettle

2021-11-02 Thread Thomas Cai
is needs to load data in batches. > >It is recommended to use DataX doriswriter plug-in, or mysql odbc external >table for mysql data synchronization or load. > > > > >-- > >此致!Best Regards >陈明雨 Mingyu Chen > >Email: >morning...@163.com; >morningman

Data Load Issue by using Kettle

2021-10-30 Thread Thomas Cai
Dear All, I tried to load data from MySQL to Doris by using Kettle tool and found there was a limitation of 500 records. It means the job was successful if ETL records were less than 500. And the job failed when the records were more than 500, but the 500 records had still been loaded into Do

Re: SQL Execution Performance

2021-09-05 Thread Thomas Cai
Mingyu, Thanks for your confirmation. Regards, Thomas | | Thomas Cai 邮箱:thomas...@126.com | Signature is customized by Netease Mail Master On 09/06/2021 12:30, 陈明雨 wrote: It should have same results by using [shuffle] or not, no need to worry about it. -- 此致!Best Regards 陈明雨 Mingyu

Re:Re:SQL Execution Performance

2021-09-01 Thread Thomas Cai
>陈明雨 Mingyu Chen > >Email: >chenmin...@apache.org > > > > > >At 2021-09-01 12:39:11, "Thomas Cai" wrote: >>Dear All, >> >> >>I am having the SQL execution performance issue. The followings are the SQL >>and the result of S

SQL Execution Performance

2021-08-31 Thread Thomas Cai
Dear All, I am having the SQL execution performance issue. The followings are the SQL and the result of SQL explain. But I have no ideas on how to tune the SQL to improve. Expect to receive your suggestions. Thanks. Best Regards, Thomas =SQL START SELECT a.project

Re: The performance issue about Doris mapping table

2021-04-02 Thread Thomas Cai
Hi All, Share with you:I changed the table engine type of the original MySQL table from InnoDB to MYISAM. Then rebuild the mapping table in Doris. The query performance is almost the same as in MySQL directly. Best Regards, Thomas | | Thomas Cai 邮箱:thomas...@126.com | Signature is

Re: The performance issue about Doris mapping table

2021-04-01 Thread Thomas Cai
Dear Lee, Thanks for the info about limit clause. Actually I did try to query the whole records without limit both in MySql and Doris. The situation was almost the same. Regards Thomas | | Thomas Cai 邮箱:thomas...@126.com | Signature is customized by Netease Mail Master On 04/01/2021 11:50

Re:Re: The performance issue about Doris mapping table

2021-03-31 Thread Thomas Cai
- BytesRead: 0.00 - RowsReturnedRate: 211 At 2021-03-31 19:43:06, "ling miao" wrote: Hi Thomas Cai, Doris's mapping table read performance is indeed slightly worse than the direct read mysql table performance. But your case should not be affected.

The performance issue about Doris mapping table

2021-03-31 Thread Thomas Cai
Dear All, I got a performance issue when I selected records(limit 1000) from a Doris mapping table(MySQL,records were around 150K). It took less than 2s to look for the same records from MySQL table directly, but it would take about 20s from the Doris mapping table. My Doris version is 0.12 an