Teradata 中的行大小限制 [英] Row size limitation in Teradata

问题描述

所以我知道 Teradata 有每行 64k 字节的限制.我有一个需要导出到 Teradata 的宽表，并且有一些字段 (varchar (5000)) 伴随着它.我们已经看到行大小超过此限制的情况.

So I know that Teradata has a limitation of 64k bytes per row. I have a wide table that I need to export to Teradata and there are some fields (varchar (5000)) that go along with that. We have seen cases where the row size exceeds this limitation.

那么，我的问题是，我们如何才能克服这种情况?我们无法在我们的源中修剪大型 VARCHARS，因为它们对下游业务用户来说是必需的.拆分表格始终是一种选择，但 Teradata 中是否还有其他方法可以处理这种情况?

So, my question is, how can we overcome this situation? We cannot trim the large VARCHARS in our source as they are necessary to the downstream business users. Splitting up the table is always the option, but are there any other ways in Teradata that this can be handled?

推荐答案

Teradata 16.00 将行大小增加到 1MB.否则，正如 JNevill 提到的那样，将表分成两个具有相同主索引的表.这允许它们在行键合并连接上以 AMP 本地连接在一起，这是 Teradata 中最有效的连接之一.

Teradata 16.00 increases row size to 1MB. Otherwise, as JNevill mentions split the table into two with the same primary index. This allows them to be joined together AMP-local on a row-key merge join, one of the most efficient joins in Teradata.

这篇关于Teradata 中的行大小限制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！