CREATE NAMESPACE Statement

You can add a new namespace by using the CREATE NAMESPACE statement.

Syntax

create_namespace_statement ::= 
   CREATE NAMESPACE [IF NOT EXISTS] namespace_name

namespace_name ::= name_path
name_path ::= field_name ("." field_name)*
field_name ::= id | DSTRING

Semantics

IF NOT EXISTS: This is an optional clause. If you specify this clause, and if a namespace with the same name exists, then this is a noop and no error is generated. If you don't specify this clause, and if a namespace with the same name exists, an error is generated indicating that the namespace already exists.

Note:

Namespace names starting with sys are reserved. You cannot use the prefix sys for any namespaces.

Example 3-1 Create Namespace Statement

The following statement defines a namespace named ns1.

CREATE NAMESPACE IF NOT EXISTS ns1;

Create Table in the namespace ns1 as follows:

CREATE TABLE ns1:t (id INTEGER, name STRING, primary key (id));
INSERT INTO ns1:t VALUES (1, 'Smith');
SELECT * FROM ns1:t;

Output:

{"id":1,"name":"Smith"}