Archives of the TeradataForum
Message Posted: Wed, 09 May 2001 @ 15:51:26 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|