Archives of the TeradataForum
Message Posted: Thu, 25 Apr 2013 @ 09:14:42 GMT
seems not to work the same way - also to my surprise.
Table gutenberg has about 1.6 billion so I cross join with a 2 row result. Single node dev system with R14.0....
select top 100 * from ( select g.term_in_gutenberg, t.id, cast(row_number() over (order by g.term_in_gutenberg, t.id) as decimal(18,0)) as row_num from xxx.gutenberg g cross join (select id from yyy.ref_id where id in (1,2)) as t ) as t order by 3 desc ; *** Failure 2616 Numeric overflow occurred during computation. Statement# 1, Info =0 *** Total elapsed time was 2 hours, 24 minutes and 54 seconds.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|