SQL quick reference

    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.

    Create a new connector for fetching data from or writing data to an external system with the connector name given. A connector can be either a source or a sink one. Note that source connector is not supported yet. When creating a connector, its type and its bound stream must be specified in the WITH clause. There can be other options such as database name, user name and password. There can be an optional IF NOT EXIST config to only create the given connector if it does not exist. See CREATE CONNECTOR.

    1. CREATE <SOURCE|SINK> CONNECTOR connector_name [IF NOT EXIST] WITH (connector_option [, ...]);

    One of the following states is assigned to the connectors:

    Please wait for it to finish setting up if the state of the connector is Creating or Created. You can restart an aborted or terminated connector (in the future). You may also abandon connectors by using

    SELECT (from streams)

    1. SELECT <* | expression [ AS field_alias ] [, ...]>
    2.   FROM stream_name [, ...]
    3.   [ GROUP BY field_name [, window_type] ]
    4.   EMIT CHANGES;

    Get record(s) from the specified view. The fields to get have to be already in the view. It produces static record(s) and costs little time. See .

    INSERT

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

    2. INSERT INTO stream_name VALUES 'json_value';
    3. INSERT INTO stream_name VALUES "binary_value";
    1. DROP CONNECTOR connector_name [IF EXISTS];

    SHOW

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