Skip to main content

Datometry Documentation

Endpoint Configuration Parameters

The [endpoint] defines the Hyper-Q service endpoint. SQL clients connect to the endpoint to gain access to the Hyper-Q VM. The endpoint consists of the IP address and the port number at which Hyper-Q service is available.

[endpoints] 
"endpoint".port = 1025
"endpoint".database = "database" 
"endpoint1".app_protocol = odbc
"endpoint".type = teradata
"endpoint".version = "170000"
"endpoint".is_case_sensitive = false
"endpoint".spill_dir = "/hyperq-spool"
"endpoint".timezone = "America Pacific"
Table 4. Endpoint Parameters

Parameter

Type

Description

app_protocol

String

Database property used to identify the network protocol of the clients connecting to Hyper-Q.

Teradata and ODBC are synonyms that identify the SQL clients as Teradata clients. There is no default value. Use the value dtm_pgv3 for Datometry ODBC and JDBC drivers (PolyTools).

century_break

Integer

Specifies which two-digit years are to be interpreted as 20th-century years and which two-digit years are interpreted as 21st-century years. The values can range from 0 to 100. The default is 0.

In this example, strings such as '00/01/01' and '24/01/01' are interpreted as years 2000 and 2024, respectively. A string inserted as '25/01/01' is interpreted as the year 1925. The choice of 25 specifies that the database will use a cushion of up to 25 years to handle input dates for the 21st century, and does not have historic input data prior to the year 1925.

"endpoint1".century_break = 25

database

String

Specifies the database to use with the [policies] parameter.

is_case_sensitive

Boolean

Identifies the case sensitivity of the backend system catalogs. The default is true. Hyper-Q uses this value to properly emulate Teradata system catalog lookups.

memory_quota

Integer

Specifies when the result device begins writing converted results to disk. A low value will increase the result conversion time because more results will return to disk before being sent to client.

You specify the value in megabytes. For example "endpoint".memory_quota = 10MB

port

Integer

Specifies that the endpoint accept connections on the specified port number. In the above example, Hyper-Q is accepting connections to endpoint at port number 1025.

spill_dir

String

Specifies the directory where Hyper-Q creates a file to store large result sets.

timezone

String or Integer

Specifies the local time zone. Hyper-Q adjusts time values to the time zone you specify, and automatically adjusts for daylight saving time when specifying a time zone by name. This allows existing clients to continue to operate in local time on backend systems that only support UTC.

You can specify the time zone value as either an integer or string. For example:

"endpoint".timezone = "America Pacific"
"endpoint".timezone = "-04:00"

Additionally, you can specify a time zone using the set time zone command. This overrides the time zone configuration specified using "endpoint".timezone. For example:

set time zone '-10';
set time zone 'America Eastern';
set time zone '03:00';

type

String

Specifies the native database. For example:

"endpoint".type = Teradata

version

Integer

Specifies the Teradata version that Hyper-Q is emulating. "140000" specifies 14.x and "170000" specifies 17.x Teradata distributions.

"endpoint".version = "170000"