Archives of the TeradataForum
Message Posted: Thu, 03 May 2012 @ 10:18:25 GMT
<-- 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).
SELECT RANK() OVER ( PARTITION BY PI_Column ORDER BY PI_Column ) ,PI_Column ,ColumnA ,ColumnB FROM MyTable;
(There is a NUPI on PI_Column on MyTable)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|