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

For definition of the syntax component referenced in this statement, see:

• id

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 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"}