Archives of the TeradataForum

Message Posted: Wed, 09 May 2001 @ 15:51:26 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Joan,

You shouldn't be placing the Primary index columns in the CSUM function, you need to be placing the Primary key columns or the columns that will make CSUM produce a unique key id. The Primary index columns can be NUPIs and by placing these columns into CSUM you will get duplicate values for every row with that NUPI values. This query will probably have to redistribute the data to execute this function, but you are talking about 1 billion rows and there is no better way to achieve this task that I know of. Also, you must have a very skewed NUPI if you are having these problems using your PI columns.

At least this is what I believe you are trying to do. Please correct me if I am wrong.

Good Luck,

Eric

EJK
Eric J. Kohut
Senior Solutions Consultant - Teradata Solutions Group - Retail
Certified Teradata Master
NCR Corp.

	<Prev	Next>		<<First	<Prev	Next>	Last>>