8.7.1 Details of the query group property file

Organization of this subsection
(1) Format
(2) File name
(3) File storage location
(4) Description
(5) Specifiable parameters
(6) Notes

(1) Format

Specify each parameter in the following format:

parameter-name=value

(2) File name

query-group-name

Specify a query group name as a string of 1 to 64 alphanumeric characters (0 to 9, a to z, A to Z) and the underscore (_). A query group name must begin with a single-byte alphabetic character.

(3) File storage location

This file must be stored in the following directory:

working-directory\conf\

(4) Description

This file specifies the path of the query definition file and tuning parameters to be used to run the query group. You create a separate file for each query group.

(5) Specifiable parameters

The table below lists and describes the parameters that can be specified and their default values. For details about the parameters, see 8.7.2 Details of the parameters in the query group property file.

Table 8-5 Specifiable parameters and their default values (query group property file)

No.Parameter nameDescriptionDefault valuePermitted value rangeWhether or not changeable during restart#1
1querygroup.cqlFilePathSpecifies the path of the query definition file that defines the query group.NoneAbsolute path or path relative to the working directoryN
2querygroup.sleepOnOverStoreSpecifies the period of time that execution of the query group is to be placed in the sleep mode when the SDP server's checking determines that there is no available space in the output stream queue.Value specified in system_config.properties#21 to 2147483647​Y
3querygroup.sleepOnOverStoreRetryCountSpecifies the number of times the SDP server is to check the output stream queue for available space before it loads to the output stream queue the tuples obtained from query execution.Value specified in system_config.properties#20 to 2147483647​Y
4stream.filterConditionSpecifies a conditional expression for using the timestamp adjustment function to filter tuples.NoneSee 8.7.2(4) stream.filterCondition=conditional-expression.Y
5stream.filterModeSpecifies whether the timestamp adjustment function is to be used to filter tuples:
  • unuse: Does not filter tuples.
  • condition: Filters tuples.
unuseunuse
or
condition
Y
6stream.freeInputQueueSizeThresholdSpecifies a threshold value (%) for the available size with respect to the maximum number of elements used in the input stream queue.Value specified in system_config.properties#2Integer from 1 to 99Y
7stream.freeInputQueueSizeThresholdOutputMessageSpecifies whether a warning message is to be output to the SDP server's message log:
  • true: Outputs warning message.
  • false: Does not output warning message.
Value specified in system_config.properties#2true
or
false
Y
8stream.maxKeepTupleCountSpecifies the maximum number of tuples that can be retained by the timestamp adjustment function.Value specified in system_config.properties#2Integer from 1 to 1048576​Y
9stream.propertyFilesSpecifies the names of the stream property files when properties are specified for individual streams.None--Y
10stream.timestampAccuracySpecifies the time units and time adjustment range for the timestamp adjustment function.Value specified in system_config.properties#2See 8.7.2(10) stream.timestampAccuracy={{sec|msec|usec},time-adjustment-range|unuse}.Y
11stream.timestampModeSpecifies the timestamp mode used to timestamp tuples:
  • Server: Uses the server mode.
  • DataSource: Uses the data source mode.
Value specified in system_config.properties#2Server
or
DataSource
N
12stream.timestampPositionSpecifies the name of the time-data column in tuples.Value specified in system_config.properties#2--Y
13stream.tupleLogModeSpecifies whether execution of the sdptplput command is to be enabled:
  • true: sdptplput command is to be executed.
  • false: Execution of sdptplput command is to be disabled.
Value specified in system_config.properties#2true
or
false
N
14tpl.backupFileCountSpecifies the maximum number of backup generations to be retained for the tuple log file.Value specified in system_config.properties#2Integer from 0 to 10Y
15tpl.bufferCountSpecifies the number of tuple log buffers.Value specified in system_config.properties#2Integer from 3 to 512Y
16tpl.bufferSizeSpecifies the maximum size of a tuple log buffer (in kilobytes).Value specified in system_config.properties#2Integer from 1 to 2048000​Y
17tpl.fileCountSpecifies the maximum number of tuple log files.Value specified in system_config.properties#2Integer from 3 to 512Y
18tpl.fileSizeSpecifies the maximum size of a tuple log file (in megabytes).Value specified in system_config.properties#2Integer from 1 to 2048Y
19tpl.outputLevelSpecifies the tuple log output level:
  • 1: Outputs tuple logs for the tuples that are stored in the stream queue.
  • 2: Outputs tuple logs for the tuples that are discarded due to out-of-sequence time.
  • 3: Outputs tuple logs for tuples with levels 1 and 2.
Value specified in system_config.properties#2Integer from 1 to 3Y
20tpl.outputTriggerSpecifies the tuple log file output timing:
  • BUFFER: Outputs tuple logs to a file when the buffer being used to collect the current tuple logs in the target stream becomes full.
  • NONE: Does not output tuple logs to a file or perform buffering of tuple logs.
Value specified in system_config.properties#2BUFFER
or
NONE
Y
21tpl.useOverwriteSpecifies whether the buffer is to be overwritten in the event of a full tuple log buffer:
  • true: Overwrites the tuple log buffer.
  • false: Does not overwrite the tuple log buffer.
Value specified in system_config.properties#2true
or
false
Y
Legend:
Y: Changeable
N: Not changeable
--: Not applicable
#1
Indicates whether (Y) or not (N) the parameter's setting can be changed when the query group is started by the sdpcqlstart command with the -reload option specified.
#2
If no value is specified in the system configuration property file (system_config.properties), the default value for the system configuration property file is used.

(6) Notes