SQL quick reference

CREATE STREAM

Create a new HStreamDB stream with the stream name given. An exception will be thrown if the stream is already created. See CREATE STREAM.

1. CREATE STREAM stream_name [AS select_query] [WITH (stream_option [, ...])];

CREATE VIEW

Create a new view with the view name given. A view is a physical object like a stream and it is updated with time. An exception will be thrown if the view is already created. The name of a view can either be the same as a stream. See CREATE VIEW.

1. CREATE VIEW view_name AS select_query;

SELECT

Get records from a materialized view or a stream. Note that SELECT from streams can only used as a part of CREATE STREAM or CREATE VIEW. When you want to get results in a command-line session, create a materialized view first and then SELECT from it. See SELECT (Stream).

1. SELECT <* | expression [ AS field_alias ] [, ...]>
2. FROM table_ref [, ...]
3. [ WHERE expression ]
4. [ GROUP BY field_name [, ...] ]
5. [ HAVING expression ];

INSERT

Insert data into the specified stream. It can be a data record, a JSON value or binary data. See INSERT.

1. INSERT INTO stream_name (field_name [, ...]) VALUES (field_value [, ...]);
2. INSERT INTO stream_name VALUES 'json_value';
3. INSERT INTO stream_name VALUES "binary_value";

DROP

Delete a given stream or view. There can be an optional IF EXISTS config to only delete the given category if it exists.

1. DROP STREAM    stream_name    [IF EXISTS];
2. DROP VIEW      view_name      [IF EXISTS];

SHOW

Show the information of all streams, queries, views or connectors.

1. SHOW STREAMS;
2. SHOW QUERIES;
3. SHOW VIEWS;
4. SHOW CONNECTORS;