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

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


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


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


  • 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. 
Have more questions? Submit a request


Article is closed for comments.

Powered by Zendesk