select * from table(gen_sequence(2,4)) as t;
I wrote a 'generate_rows' UDF with the same basic ideas that Akira presented in is 'gen_sequence' UDF code.
I wanted to verify that we can trust AMP ID's to be consecutive numbers.
For example -
Assuming we have a system of 144 AMPs.
Can we trust AMP ID's to be 144 consecutive numbers in the range 0..143?
What happans in a case of an AMP failure (let say AMP ID 12) ? Would the UDF still run? would there be a gap in the range of AMP ID's?
Dudu (David) Markovitz
Just to be clear -
I'm aware that Akira doesn't count on the AMP ID's to be consecutive numbers,
I'm just curious about this issue.