create_journal

Creates a new journal that provides a time windowed materialisation of a query.

Available in the network database and requires the star$define role.

Parameters:

Name	Optional	Type	Description
name$	Mandatory	Text	Name of the journal to be created.
query$	Mandatory	Text	Query to be materialised.
expression$	Mandatory	Text	Time expression for the start of a time window
period$	Mandatory	Text	Duration of a time window

Examples:

SELECT create_journal('myjournal','select count(*) from messages','timestamp','hour'); -- creates a journal that records the hourly count of messages received.

Tips:

• The time expression must return a date or time data type.
• The time period can be a standard time unit of millisecond, second, minute, hour, day, week, month, year, century or millennium.