Tracking(optimizer): notice user and give more information during optimization

[st1page]

after #9577 #9705

• better error message and hint to user to imrove SQL
  • transform overAgg to group topn, not refer the rank() function feat(optimizer): refactor group topn convert && improve err msg #9724
  • dynmic filter not convert successfully
• high risk to bring low performance
  • max/min on non-append only stream
  • watermark loss due to some misusing, such as cast timestampTZ to timestamp(fix: allow type cast of Timestamptz in generated column #9580), or dynamic filter can not derive watermark.
• 🤔 experimental features such as TTL and append-only table?

[github-actions]

This issue has been open for 60 days with no activity. Could you please update the status? Feel free to continue discussion or close as not planned.

[github-actions]

This issue has been open for 60 days with no activity.

If you think it is still relevant today, and needs to be done in the near future, you can comment to update the status, or just manually remove the no-issue-activity label.

You can also confidently close this issue as not planned to keep our backlog clean.
Don't worry if you think the issue is still valuable to continue in the future.
It's searchable and can be reopened when it's time. 😄