Data Type Hints
The following hints allow you to accommodate differences between Teradata and Azure Synapse data types.
Specify How Hyper-Q Performs Rounding When Computing DECIMAL Data Types The division rules for Azure Synapse differ from Teradata when calculating the last decimal digit. This issue becomes apparent when using the Teradata utilities RoundHalfwayMagUp = TRUE and RoundNumberAsDec = FALSE. You can specify how Hyper-Q performs rounding when using these utilities. By enabling the hint round_halfway_mag_up, Hyper-Q will return the same division values in the last decimal digit as Teradata.
Cast Strings to Integer or Numeric Values You can cast a string to an integer or numeric value on Azure Synapse that is compatible with Teradata conversion rules.
Accept Timestamp Values Using Any Type of Character Separators When CASTing text to a timestamp, you can allow Hyper-Q to accept timestamp values with any character as separators between timestamp parts.
Apply Strict Checks of Teradata Timestamps You can perform a strict check of the Teradata default timestamp format using the Hyper-Q SQL hint text_to_timestamp_advanced_separators_strict_format_checking.
Translate Teradata TRYCAST to TIMESTAMP Function You can translate the Teradata TRYCAST to TIMESTAMP function using the timestamp_trycast hint. TRYCAST takes a string and casts it to the specified data type—in this case TIMESTAMP.
Enable Support for Leap Seconds Teradata supports leap seconds, whereas many other databases do not. The leap_second_literals hint lets you enable the handling of leap seconds.