Skip to main content

Datometry Documentation

General Configuration Parameters

Specifies basic configuration settings for the Hyper-Q deployment.

"general_setting".memory_limit = 2GB 
"general_setting".clustered = false 
"general_setting".log_dir = /opt/datometry/logs
Table 9. General Setting Parameters

Parameter

Type

Description

memory_limit

Integer

Specifies an amount of memory such that if a process consumes too much memory, Hyper-Q will throw an error to prevent a system crash.

clustered

Boolean

Set to true to enable operating in clustered mode. Setting clustered to false turns clustering off.

log_dir

String

(Optional) Specifies a directory other than the default that log files are written to. Note that the CLI option -logdir takes precedence over this setting. If -logdir and the dtm.ini option are both specified, the directory specified with -logdir is the one that Hyper-Q will use.

strict_numeric_format_check

Boolean

(Optional) Specifies if Hyper-Q returns a DTM8540 error for queries containing Teradata numeric formatting strings that it cannot correctly emulate.

Certain types of queries cause formatting to be applied in client-side applications such as Basic Teradata Query (BTEQ). In such cases Hyper-Q does not emulate the numeric format, as it can pass the format string as-is to the client and let BTEQ apply the necessary formatting.

However, in certain circumstances, such as CASTing a formatted number to a text data type, or passing it to other SQL functions, the formatting must be emulated by the database. For queries such as this which require server-side formatting, Hyper-Q emulates all Teradata formatting features in order to provide correct results. Setting strict_numeric_format_check to true will cause queries to fail if they use unsupported format string features and require server-side formatting emulation from Hyper-Q.

If strict_numeric_format_check is omitted or set to false, instead of returning an error for formats that cannot be correctly emulated, unsupported format strings are ignored and Hyper-Q uses the default numeric format. The default format can vary depending on the backend database in use, and may not be the same as the default Teradata numeric formatting.

To enable strict_numeric_format_check, set it to true. For example:

"general_settings".strict_numeric_format_check = true