All Forums Database
navneetthakur2 2 posts Joined 02/14
02 Feb 2014
NoPI

How does NoPI table take care of data distribution into various amps?

Raja_KT 1246 posts Joined 07/09
02 Feb 2014

Hi,
This link may help.
http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/Database_Management/B035_1094_111A/ch09.050.022.html#ww16471633
There are some more, which describe about the implementation too.
Cheers,
 

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

M.Saeed Khurram 544 posts Joined 09/12
03 Feb 2014

NOPI tables use an internal random row hash generator, Rows are assigned to the amps according the this randomly generated row hash. 
 Rows are appended at the end of each table, so no sorting is required. All the rows on one amp will have same hash bucket number, the uniqueness value is incremented so rowid is unique. Random row hash generator is used at AMP level or PE level. for SQL based functions PE uses the random generator, while in case of Fastload based functions AMP uses the random generator and assign rows. 
 

Khurram

navneetthakur2 2 posts Joined 02/14
03 Feb 2014

Thanks Raja and Khurram

You must sign in to leave a comment.