Datometry Documentation

Hyper-Q supports all commonly used SQL found in applications run on Teradata today. It covers thousands of features and feature variants of the complete body of Teradata SQL. Notably, this includes the following frequently used features:

In addition, Hyper-Q supports a vast array of syntax and semantics that are differently defined in Teradata and the destination system. In doing so, Hyper-Q reconciles these differences and delivers fully equivalent behavior including bit-identical results. On average, Hyper-Q supports 99.5% or more of the syntax of any given workload. For most customers, this means workloads can be replatformed without any significant intervention. However, in the rare case where an existing workload uses a variant of a feature that is yet unsupported, the original query should be modified accordingly.

Some features—stored procedures, macros, updatable views and recursive queries—may not yet be natively supported on the destination cloud data warehouse. Hyper-Q provides full emulation of these features by using the available constructs on the cloud data warehouse.

Often, the yet unsupported elements of a workload are due to permissive language features in Teradata SQL. Because of the lack of rigor in the language definition, users often under specify or misinterpret constructs leading to unexpected and unintended results. Datometry increases the coverage of Hyper-Q continuously and addresses additional feature requests rapidly. The design of the underlying framework enables additional and new language features with minimal delay.