Datometry Knowledge Base

OpenDB

• OpenDB Usage Examples

Troubleshooting Hyper-Q

• Hyper-Q Error Code Reference
• DTM3021: Endpoint port '1025' unavailable: address already in use
• DTM3031 : The datepart tzoffset is not supported by date function datepart for data type datetime
• DTM3102: Failed to connect to the underlying database
• DTM8031: Object not found or no permission 
• DTM8193: Syntax error before: 'EOL'

See all 14 articles

Installation Guides

• Datometry Hyper-Q for Google BigQuery Installation and Setup
• Datometry Hyper-Q for Azure Synapse Installation and Setup

Hyper-Q Log Files

• Error Log Reference
• About Hyper-Q Log Files

Configuration

• High Availability and Failover
• Customization of Installation
• Configuring an ODBC Driver for Datometry Hyper-Q
• Set up accounts for Teradata client applications

FAQ & Troubleshooting

• How do I Upgrade Hyper-Q in Place using RPM Packages?
• How can I modify or tune a Hyper-Q query?
• How Does Hyper-Q Perform Bulk Load Error Handling?

SQL Support and Hyper-Q

• Semantics for Teradata Vector NOT IN Predicates
• Create, Update and Maintain Data Definition Language (DDL) for Teradata on Azure Synapse
• Optimize Teradata DELETE Statements and Transactions for Azure Synapse Analytics
• Call user defined functions created natively on the backend data warehouse using Hyper-Q
• Optimizations for Teradata DELETE ALL and DELETE without a WHERE Clause Statements
• Process SQL Batches for Azure Synapse Analytics Using sqlcmd

See all 10 articles

User Defined Functions

• Install or Upgrade Hyper-Q Standard UDFs

Datometry Internal (For Internal Users)

• Enable ODBC trace to troubleshoot specific ODBC client connectivity issues on UNIX/LINUX