CREATE-DATABASE

Name

CREATE DATABASE

Description

This statement is used to create a new database (database)

grammar:

1. CREATE DATABASE [IF NOT EXISTS] db_name
2. [PROPERTIES ("key"="value", ...)];

PROPERTIES Additional information about the database, which can be defaulted.

• If you want to specify the default replica distribution for tables in db, you need to specify replication_allocation (the replication_allocation attribute of table will have higher priority than db)

1. PROPERTIES ( 2. "replication_allocation" = "tag.location.default:3" 3. )

Example

1. Create a new database db_test

1. CREATE DATABASE db_test; 2. Create a new database with default replica distribution:

1. CREATE DATABASE `iceberg_test` 2. PROPERTIES ( 3. "replication_allocation" = "tag.location.group_1:3" 4. );

Keywords

1. CREATE, DATABASE

Best Practice