tracking: CREATE OR REPLACE

[BohuTANG]

Summary

CREATE OR REPLACEmeans "if the object exists, drop it, then create it", with it we can simple all the object operations:

DROP IF EXISTS ....
CREATE ...

into one:

CREATE OR REPLACE ...

[lichuang]

• 14448

• 14507

• 14547

• 14579

• 14582

• 14595

• 14598

• 14610

• 14635

• 14648

• 14653

• 14655

• 14657

• 14659

[BohuTANG]

Now, what we have left are these objects need to do:

• stage: https://docs.databend.com/sql/sql-commands/ddl/stage/
• connection: https://docs.databend.com/sql/sql-commands/ddl/connection/
• user&role: https://docs.databend.com/sql/sql-commands/ddl/user/
• udf: https://docs.databend.com/sql/sql-commands/ddl/udf/
• stream: https://docs.databend.com/sql/sql-commands/ddl/stream/
• view: https://docs.databend.com/sql/sql-commands/ddl/view/
• file format: https://docs.databend.com/sql/sql-commands/ddl/file-format/
• aggregating index: https://docs.databend.com/sql/sql-commands/ddl/aggregating-index/
• virtual column: https://docs.databend.com/sql/sql-commands/ddl/virtual-column/
• password policy: https://docs.databend.com/sql/sql-commands/ddl/password-policy/
• masking policy: https://docs.databend.com/sql/sql-commands/ddl/mask-policy/
• network policy: https://docs.databend.com/sql/sql-commands/ddl/network-policy/
• share: https://docs.databend.com/sql/sql-commands/ddl/share/
• share endpoint: https://docs.databend.com/sql/sql-commands/ddl/share-endpoint/create-share-endpoint

[PsiACE]

I want to try implementing some of them. I will try to track in this comment.

• [x] https://github.com/datafuselabs/databend/issues/14551 for udf

[BohuTANG]

Add:

• [ ] CREATE [ OR REPLACE ] WAREHOUSE|TASK (This may need help from @ZhiHanZ )
• [x] Share
• [x] Share Endpoint
• [x] External Function

Seems all is here.

[PsiACE]

External Function has been supported in #14581.

[lichuang]

create share only create a named share, without any other params, i think there is no need to impl or replace when create share: https://docs.databend.com/sql/sql-commands/ddl/share/

[BohuTANG]

Spilled out https://github.com/datafuselabs/databend/issues/14661, this tracking is all done.