CREATE DATABASE

Starting from Timeplus Enterprise 2.6, you can create a database to organize your streams, materialized views and other resources. The database is a logical container to help you to manage and query the data more efficiently.

When you create a database in a cluster, the database is automatically replicated to all the nodes in the cluster. You can create a database with the following SQL:

CREATE DATABASE IF NOT EXISTS my_database;

Once the database is created, you can create streams, materialized views, and other resources in the database by running USE my_database before creating the resources.

For example:

CREATE DATABASE my_database;

USE my_database;

CREATE STREAM my_stream (raw string);

INSERT INTO my_stream(raw) VALUES ('hello');

SELECT * FROM table(my_stream);
--if you are using other databases
SELECT * FROM table(my_database.my_stream);

Limitations

• You can create databases with SQL but the current web console only supports the default database.
• User-defined functions are global and not bound to a specific database.

See also

• SHOW DATABASES - Show databases
• DROP DATABASE - Drop databases