Subscribe to Terdata Developer Exchange - RSS feed for all blogs Latest blog posts
24 Dec 2012

Teradata Database supports Inline and Deferred Large Object Retrieval modes. The LOB retrieval modes control the content of rows and accessibility of LOB columns. 

28 Nov 2012

Most of us are aware of AMP worker tasks, and some of us are even obsessive about not running out of this finite resource.  But that’s on the AMP.  What about the tasks supporting user work on the parsing engine (PE)?  Should we be just as vigilant about what’s happening with tasks at the PE level?

Not really.  Here’s why.

15 Nov 2012

I’ve written a few blogs on the future of 3D printing and its impact on manufacturing and data analytics in the future, or as Chris Anderson stated, “The long tail of things.”  But, up to now, 3D printing has been expensive and mostly for small objects.

13 Nov 2012

In Teradata Database Release 14.10 object names have been lengthened from 30 bytes of a Latin or KANJISJIS character set to 128 Unicode characters. This capability supports a richer set of characters to compose object names. While using a session character set that may contain limitations due to the supported set of characters, Unicode delimited identifiers are supported in all SQL text statements. Please see the SQL Data Types and Literals manual for information on Unicode delimited identifiers.

29 Oct 2012

I gave a presentation on AMP worker tasks at the Teradata User Group conference last week in Washington DC.   A question came from someone in the audience concerning FastExport jobs in response mode, and whether or not they were holding AMP worker tasks.  This post addresses that question.

19 Oct 2012

When you start designing a statistics collection process topics include:

  • stats on some tables are more important than others.
  • some stats on a single table are more important than others.

Both problems involve some kind of prioritization process, which finally leads to a sorted list of COLLECT STATS statement (See Marcio Moura's blog When is the right time to refresh statistics?)

Processing this list (using a BTEQ script or a cursor in a Stored Procedure) could lead to another problem:

19 Sep 2012

First off, I am not one with anything, and I don’t think anyone would appreciate a peek inside my mind. That being said and irrelevant I wanted to do a quick post on Zen coding.

Zen coding is not new. Unfortunately, there are an infinite number of things that interest me but a finite amount of time, so I am just now getting around to using it. However, I really regret putting off learning Zen coding for this long.

17 Sep 2012

In my blog entries "Teradata Columnar" and "9.2 Quintillion? What's that all about?", I discussed column partitioning and the increased partition limit that are introduced in TD 14.0.  But there are other TD 14.0 partitioning enhancements that you may find useful.  The following provides a brief introduction to these enhancements; for more detailed information, see the Orange Book: Increased Partition Limit and other Partitioning Enhancements, the Orange Book: Teradata Columnar, and the TD 14.0 manuals.

13 Sep 2012

Ever wish they would fill-up the pothole quicker?  Municipalities are creating apps to allow the crowd to give them up-to-date notification of problems in the street.  This is in addition to the automated systems that tap into the stream of GPS and cell phone signals to monitor for real-time traffic issues.  “The New Jersey center offers a glimpse at the power of "big data," a term for techniques to gather reams of computerized information points, analyze them and spit out patterns, often in easy-to

11 Sep 2012

It is the Big Data era. But we do not have enough "big applications". 

This tool - 'Common UDF' - provides a code builder for both Teradata table UDF and Hadoop Pipes UDF based on the same core code. In this way, we can implement applications for both Teradata and Hadoop with the same code.

Download (7Kb)

This topic will be disucssed at Teradata PARTNERS 2012, Session ID 1987 - Common UDF cross Hadoop and Teradata – One Software for Two Platforms. Please join us at this session to learn more.