Sign in Subscribe

Databricks

A collection of 17 issues

Teradata Built-In Functions: TO_NUMBER, TRUNC, CEILING, FLOOR, LEAST, GREATEST, ROUND

TO_NUMBER I have often needed a function to verify whether a character column contains a numeric value. Typically, I have resorted to using a workaround, such as: CASE WHEN UPPER('12.77') = LOWER('12.77') THEN 'IS_NUMERIC' ELSE 'IS_NOT_NUMERIC&

Understanding Teradata's SAMPLE Function: Randomly Select Rows and More

What is the Teradata Sample Function? The SAMPLE function returns a set of randomly selected rows. Here are the characteristics: * Ask for a sample with an absolute number of rows * Ask for a sample that contains a certain percentage of the table rows * Ask for more than one sample at

Hot Standby Nodes: The Secret to Seamless Performance and Recovery

A hot standby node belongs to a clique of nodes and does not host virtual processes such as AMPs or Parsing Engines. The standby node remains idle until a member of its clique crashes or fails. At this point, the standby node is activated to take over the failed node&

Extracting Numeric Tokens from Strings with CHAR2HEXINT Function in Teradata SQL

Learn how the CHAR2HEXINT function helped solve a real-world problem of extracting number parts from a string in Teradata SQL. Read on for the solution.

Optimizing Teradata Queries: A Case Study on Generating Rows Between Start and End Dates

Learn how to optimize SQL queries in Teradata with this case study. See how a recursive query was replaced with a more efficient approach.

Track and Optimize Query Performance with Teradata DBQLOGTBL System Table

Teradata DBQLOGTBL is a system table in the Teradata database management system that stores log data for all queries on the system. It is a valuable resource for tracking and analyzing query performance, as it contains information about the resources used by each query and the duration of the query.

Teradata Pro is now DWH Pro!