Good First Issue

[luzhijing]

The following are some easy tasks for new contributors. If you are participating in an open source project for the first time, it is recommended to choose one of the following tasks to practice. The first task is used to familiarize yourself with the submission process and feel the friendliness of the community.

If you are interested in a task, Please leave a message, for example, I am interested in implementing this task, please submit a PR in 2 weeks if you leave the message. If more than 2 weeks, other contributors are welcome to do it.

And If you think some tasks are more friendly for new contributors, feel free to add it.

NEW FEATURES

• [Feature] About supporting sequenceCount function and retention function #10473
• [Feature] The posexplode function support like hive. #11331
• [Roadmap] Enhanced system observability #7582

SQL Function

• nth_value
• collect_set
• tostartofminute
• dictgetstring
• argmax
• dictget
• multisearchallpositions
• domain
• arraymap
• anyheavy
• quantileexact
• range
• arrayreduce
• anylast
• path

IMPROVEMENT

• [Enhancement] Recover DDL #8421 [feature-wip](recover) new recover ddl and support show dropped #13067
• how can doris routine load with kafka sasl_ssl authentication work? #7861
• [Enhancement] Use NIO to replace the legacy IO. #11768
• [Enhancement] replace assertTrue(X.equals(X)) with assertEquals #11916

TESTS

write cases in sql under regression-test, please refer to regression-test/suite/empty_table in pr #8681

• HLL related @clownxc
• BITMAP related
• Aggregated function
• Decimal
• Double
• Set

DOCS & BLOGS TRANSLATION

• Doris SQL 原理解析 [doc] Add blog 'Doris analysis: Doris SQL principle analysis'  doris-website#69
• Doris Compaction 机制解析 [doc]: Add blog 'Doris analysis: Doris Compaction mechanism analysis'  doris-website#93
• Doris Stream Load 原理解析 [doc] Add blog 'principle of Doris Stream Load' doris-website#88
• Doris 索引机制解析 https://mp.weixin.qq.com/s/KdCdXb9Z3MdUZ5S0RV726Q
• Apache Doris 在京东搜索实时 OLAP 的探索与实践 https://blog.csdn.net/wypblog/article/details/109759696
• Apache Doris 在 WeLab实时大数据平台的应用实践 WIP: add WeLab.md doris-website#102
• Apache Doris 助力网易严选打造精细化运营 DMP 标签系统 https://mp.weixin.qq.com/s/OHviTnbiA5ewwXGFp5fQiw
• Apache Doris 在小米数据场景的应用实践与优化 https://mp.weixin.qq.com/s/1WX2nNOEGO0wKRkVGvxYBg

Translation these articles and submit a blog in repo https://github.com/apache/doris-website

[javagjChen]

[WeOpen Star] I would like to help DOCS & BLOGS TRANSLATION Doris Stream Load 原理解析 https://mp.weixin.qq.com/s/zwiza9WXqo8n49PMgaUrKg

[ZHbamboo]

[WeOpen Star] I would like to help DOCS & BLOGS Doris SQL 原理解析 https://mp.weixin.qq.com/s/v1jI1MxEHPT5czCWd0kRxw

[Chovyyyyyy]

[WeOpen Star] I would like to help IMPROVEMENT Recover DDL #8421

[ZHbamboo]

[WeOpen Star] I would like to help DOCS & BLOGS Doris Compaction 机制解析 https://mp.weixin.qq.com/s/5D1gAOEiFWM7N6KPwqHHdw

[dinggege1024]

[WeOpen Star] I would like to help [Enhancement] Use NIO to replace the legacy IO. #11768
#11768

[YIFENG12]

[WeOpen Star] I would like to help DOCS & BLOGS TRANSLATION Doris 索引机制解析 https://mp.weixin.qq.com/s/KdCdXb9Z3MdUZ5S0RV726Q

[TaoZex]

[WeOpen Star] I would like to help DOCS & BLOGS TRANSLATION Doris Stream Load 原理解析 https://mp.weixin.qq.com/s/zwiza9WXqo8n49PMgaUrKg

@javagjChen applied for this task 18 days ago, but the task has not been completed for more than two weeks. May I do it?

[isHuangXin]

[WeOpen Star] Hi, I want to try #10473 [NEW FEATURES]. Plz assign this issue to me~

[TaoZex]

[WeOpen Star] Hello, I want to try #11331[NEW FEATURES], could you also assign it to me? Thanks.

[javagjChen]

[WeOpen Star] I would like to help DOCS & BLOGS TRANSLATION Doris Stream Load 原理解析 https://mp.weixin.qq.com/s/zwiza9WXqo8n49PMgaUrKg

@javagjChen applied for this task 18 days ago, but the task has not been completed for more than two weeks. May I do it?

@TaoZex yes

[forrestnie]

[WeOpen Star] hi，I want to try Doris Compaction 机制解析 https://mp.weixin.qq.com/s/5D1gAOEiFWM7N6KPwqHHdw ,can I get a chance to do it? i will try my best to finish this.

[luzhijing]

[WeOpen Star] hi，I want to try Doris Compaction 机制解析 https://mp.weixin.qq.com/s/5D1gAOEiFWM7N6KPwqHHdw ,can I get a chance to do it? i will try my best to finish this.

Thanks for your passion, but @ZHbamboo has applied this task, you can choose someone else.

[luzhijing]

[WeOpen Star] Hi, I want to try #10473 [NEW FEATURES]. Plz assign this issue to me~

Done

[luzhijing]

[WeOpen Star] Hello, I want to try #11331[NEW FEATURES], could you also assign it to me? Thanks.

Yes, you can comment at #11331 and I will assign it to you.

[TaoZex]

[WeOpen Star] Hello, I want to try #11331[NEW FEATURES], could you also assign it to me? Thanks.

Yes, you can comment at #11331 and I will assign it to you.

Thank you. I've already applied for this issue in the comments section.

[forrestnie]

[WeOpen Star] hi，I want to try Apache Doris 在京东搜索实时 OLAP 的探索与实践 https://blog.csdn.net/wypblog/article/details/109759696 , can I get a chance to do it? i will try my best to finish this.

[Toms1999]

hello,
Doris Compaction 机制解析 https://mp.weixin.qq.com/s/5D1gAOEiFWM7N6KPwqHHdw
Doris Stream Load 原理解析 https://mp.weixin.qq.com/s/zwiza9WXqo8n49PMgaUrKg
Doris 索引机制解析 https://mp.weixin.qq.com/s/KdCdXb9Z3MdUZ5S0RV726Q
Can you make me one of these three，thanks

[luzhijing]

[WeOpen Star] hi，I want to try Apache Doris 在京东搜索实时 OLAP 的探索与实践 https://blog.csdn.net/wypblog/article/details/109759696 , can I get a chance to do it? i will try my best to finish this.

OK, you can translate this article and thanks for your passion.

[luzhijing]

hello, Doris Compaction 机制解析 https://mp.weixin.qq.com/s/5D1gAOEiFWM7N6KPwqHHdw Doris Stream Load 原理解析 https://mp.weixin.qq.com/s/zwiza9WXqo8n49PMgaUrKg Doris 索引机制解析 https://mp.weixin.qq.com/s/KdCdXb9Z3MdUZ5S0RV726Q Can you make me one of these three，thanks

I'm sorry that those three had been assigned, you can choose someone else.

[isHuangXin]

[WeOpen Star] hi, @luzhijing. Is this issue available now? If the translation of this article has not been done, please assign it to me, I expect to submit a PR tomorrow.
Apache Doris 在 WeLab实时大数据平台的应用实践 https://zhuanlan.zhihu.com/p/257183139

[isHuangXin]

[WeOpen Star] hi, @luzhijing. Is this issue available now? If the translation of this article has not been done, please assign it to me, I expect to submit a PR tomorrow.
Apache Doris 助力网易严选打造精细化运营 DMP 标签系统 https://mp.weixin.qq.com/s/OHviTnbiA5ewwXGFp5fQiw

[luzhijing]

[WeOpen Star] hi, @luzhijing. Is this issue available now? If the translation of this article has not been done, please assign it to me, I expect to submit a PR tomorrow. Apache Doris 在 WeLab实时大数据平台的应用实践 https://zhuanlan.zhihu.com/p/257183139

OK, you can translate this article and thanks for your passion.

[Diksha587]

I am interested in DOCS & BLOGS TRANSLATION if there is any blog post remaining to assign I would like to fill the post
I'm a newbie and this would be my first open source contribution

[luzhijing]

I am interested in DOCS & BLOGS TRANSLATION if there is any blog post remaining to assign I would like to fill the post I'm a newbie and this would be my first open source contribution

Welcome first contribution! This article (Doris 索引机制解析 https://mp.weixin.qq.com/s/KdCdXb9Z3MdUZ5S0RV726Q) had been assigned after 22 days but not yet submit a PR, you can translate it.

[sahilm-10]

@luzhijing I am interested in DOCS & BLOGS TRANSLATION. I am new to Open-Source, if there's any post remaining to assign , Please assign me. I want to contribute.

[luzhijing]

@luzhijing I am interested in DOCS & BLOGS TRANSLATION. I am new to Open-Source, if there's any post remaining to assign , Please assign me. I want to contribute.

Welcome! You can translate this article(Apache Doris 在小米数据场景的应用实践与优化 https://mp.weixin.qq.com/s/1WX2nNOEGO0wKRkVGvxYBg)

[Diksha587]

@luzhijing I am interested in DOCS & BLOGS TRANSLATION. I am new to Open-Source, if there's any post remaining to assign , Please assign me. I want to contribute.

Welcome! You can translate this article(Apache Doris 在小米数据场景的应用实践与优化 https://mp.weixin.qq.com/s/1WX2nNOEGO0wKRkVGvxYBg)

I have translated the document but I am a little bit confused where to put it in the repo and make the PR to submit can someone please guide me?

[luzhijing]

@luzhijing I am interested in DOCS & BLOGS TRANSLATION. I am new to Open-Source, if there's any post remaining to assign , Please assign me. I want to contribute.

Welcome! You can translate this article(Apache Doris 在小米数据场景的应用实践与优化 https://mp.weixin.qq.com/s/1WX2nNOEGO0wKRkVGvxYBg)

I have translated the document but I am a little bit confused where to put it in the repo and make the PR to submit can someone please guide me?

My WeChat is ApacheDoris_Zaki, is it convenient for you to add me ?

[sahilm-10]

@luzhijing I have Translated and made the PR. Can you please review it?

[luzhijing]

@luzhijing I have Translated and made the PR. Can you please review it?

Done

[xiaochen-zhou]

[WeOpen Star] I would like to help TESTS, Please assign me. I want to contribute.

[nextdreamblue]

[WeOpen Star] I would like to help IMPROVEMENT Recover DDL #8421

[dinggege1024]

@luzhijing

Hi, when could the function issue could code with java?

[TaoZex]

I want to try argmax funtion.At the same time, do I need to implementation argmin funtion?

[Yukang-Lian]

I want to try argmax funtion.At the same time, do I need to implementation argmin funtion?

Yeah, it's really great if you can implement both argmin and argmax function. You can refer to link1, link2 and link3. If you have any question, please do let me konw. I am pretty willing to help！

[TaoZex]

I want to try argmax funtion.At the same time, do I need to implementation argmin funtion?

Yeah, it's really great if you can implement both argmin and argmax function. You can refer to link1, link2 and link3. If you have any question, please do let me konw. I am pretty willing to help！

Thanks for your help.

[lingtaolf]

I would like to implement tostarto* function.

[Yukang-Lian]

I would like to implement tostarto* function.

Thank for your passion! You can refer to link1, link2, link3, link4. If you have any question, I am happy to help!

[TangSiyang2001]

I'd like to implement the collect_set funtion,may I try it?

[Yukang-Lian]

Thank for your passion! However, collect_set function has been finished. #10606
You can try other functions.

[TangSiyang2001]

Thank for your passion! However, collect_set function has been finished. #10606 You can try other functions.

Thank you for your prompt reply,may I try dictget then?

[Yukang-Lian]

I think it is a little complicated, how about argmax function? You can get started quickly！

[TangSiyang2001]

I think it is a little complicated, how about argmax function? You can get started quickly！

OK,I will work on argmax,thank you for your advice!

[Yukang-Lian]

Good luck! If you have any questions, I am willing to help!

[TangSiyang2001]

Good luck! If you have any questions, I am willing to help!

Hi,I realized that argmax and argmin seem to act the same role of max_by and min_by.May I just treat argmax and argmin as aliases of the latter?Or plz point it out if I misunderstood.Thanks!

[Yukang-Lian]

Good luck! If you have any questions, I am willing to help!

Hi,I realized that argmax and argmin seem to act the same role of max_by and min_by.May I just treat argmax and argmin as aliases of the latter?Or plz point it out if I misunderstood.Thanks!

Please add my wechat abmdocrt_lyk, let's talk about some details.

[isHuangXin]

I want to try SQL Function argmax, if this issue is available, plz assign it to me. Thanks～

[Alexxigang]

[WeOpen star] Hello, I'm intrested in #7579, I am new to Open-Source, if there's any post remaining to assign , Please tell me. I want to contribute.

[Yukang-Lian]

[WeOpen star] Hello, I'm intrested in #7579, I am new to Open-Source, if there's any post remaining to assign , Please tell me. I want to contribute.

Please add my wechat abmdocrt_lyk.