autonumber how it showing like even and odd?

[Anonymous]

i have data like this

t1:

load * inline [

date,id,sales

1/1/204,_03_01,100

1/2/204,_03_02,200

1/3/204,_03_03,300

1/4/204,_03_04,400

1/5/204,_03_05,500

1/6/204,_03_06,600

1/7/204,_03_07,700

];

t2:

load

autonumberhash128(date,id,sales) as new,

autonumberhash128(date,id) as new1,

resident t1;

drop table t1;

when i reload this script i am getting data for   'new' and 'new1' fields like

new:

1

3

5

7

11       and for

new1:

2

4

6

8

how i am getting  odd values for one field and even values for other field , what is reason behind this

i know that autonumber hash creates a unique integer value

[engishfaque · Accepted solution]

Dear Commonqlik,

You are right, field "new" is showing odd numbers and field "news" is showing even numbers.

It's happening due to the same autonumberhash128, when first line execute it generate "1" for field "new" and when it moves to the next line it finds the same autonumberhash128, then it generate "2" for field "new1" and same for each step.

Kindly find attached document.

Kind regards,

Ishfaque Ahmed