Teradata 16 New Features

Brief overview of some of the new features added in Teradata 16 version.
➠ Two new string functions were added

• PIVOT ~ Transpose Rows to Columns
• UNPIVOT ~ Transpose Columns to Rows

  Visit PIVOT page and UNPIVOT page to check syntax and examples for above functions.



➠ New DATASET datatype: DATASET datatype is a new Complex Datatype (CDT) representing self-describing files interpreted based on a schema. 

• The DATASET datatype allows variable types of storage formats but as of now only Avro is supported for Release 16.00. 
• DATASET datatype can hold documents of size up to 16 MB. 
• Functions are available to process, shredd, and publish data from DATASET datatype.

➠ COUNT DISTINCT Performance Improvement: Queries with COUNT DISTINCT are now processed more efficiently by Teradata.

• Benefits: 
  • The primary benefit of this feature is an improvement in the performance of queries that use COUNT DISTINCT.

➠ Global Space Accounting: The space accounting in Teradata has been enhanced to manage space limits at a global level, rather than AMP-level limit. This enhancement is referred as global space accounting. 

• System limits are now soft limits rather than hard limits(equal space allocated to each AMP) in earlier version. 
• The soft limit is specified as a percentage and can be set at the system level. 

Untill Next :)

Pankaj Chahar

+91-8802350184

Pankajchahar052@gmail.com