CREATE-DATABASE
CREATE-DATABASE
Name
CREATE DATABASE
Description
This statement is used to create a new database (database)
grammar:
CREATE DATABASE [IF NOT EXISTS] db_name
[PROPERTIES ("key"="value", ...)];
PROPERTIES
Additional information about the database, which can be defaulted.
If you create an Iceberg database, you need to provide the following information in properties:
PROPERTIES (
"iceberg.database" = "iceberg_db_name",
"iceberg.hive.metastore.uris" = "thrift://127.0.0.1:9083",
"iceberg.catalog.type" = "HIVE_CATALOG"
)illustrate:
ceberg.database
: the library name corresponding to Iceberg;iceberg.hive.metastore.uris
: hive metastore service address;iceberg.catalog.type
: The default isHIVE_CATALOG
; currently onlyHIVE_CATALOG
is supported, and more Iceberg catalog types will be supported in the future.
If you want to specify the default replica distribution for tables in db, you need to specify
replication_allocation
(thereplication_allocation
attribute of table will have higher priority than db)PROPERTIES (
"replication_allocation" = "tag.location.default:3"
)
Example
Create a new database db_test
CREATE DATABASE db_test;
Create a new Iceberg database iceberg_test
CREATE DATABASE `iceberg_test`
PROPERTIES (
"iceberg.database" = "doris",
"iceberg.hive.metastore.uris" = "thrift://127.0.0.1:9083",
"iceberg.catalog.type" = "HIVE_CATALOG"
);
Keywords
CREATE, DATABASE