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

Comments

Article is closed for comments.

Powered by Zendesk