Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 03 May 2012 @ 10:18:25 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Redistribution when doing RANK() OVER on PI
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, May 02, 2012 09:17 -->

I was wondering why the following SELECT SQL will cause redistribution on the all-AMPs STAT FUNCTION Step?

I'm using the Primary Index (only) in the OLAP function, so all the data needed to to the ranking is already present on any given Amp (BTW - when I remove the OLAP function from the Query, the redistribution goes away).

          RANK() OVER ( PARTITION BY PI_Column ORDER BY PI_Column )

(There is a NUPI on PI_Column on MyTable)


  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020