Concatenate two symbol lists - some values clobbered.

Community Support
1

Hello, 
I have :
q) a:td[`event_id]

q)a

15938422265436288484325639088700841387664880653339905852016215642764982516423233580286230431332711516..

q)b:diffsample[`event_id]

q)b

3442665661144735641952733478198390285571269841410714226581514342475446288140328516396`2..

q)sum a in b

0i

q)where a in b

`long$()

Just to make sure: 

q)sum b in a   

0i             

q)where b in a 

`long$() 

q)count a

50703

q)count b

633

And now, when I do:

q)count distinct (a,b)

51082

q)count (a,b)

51336

why do the (51336-51082) values get clobbered? I checked in the respective tables, all rows containing the missing event_ids are pristine. 

Thanks, 

Kumar

      

            

2

Also, please note that 
count(a,b) is the correct value I want(50703+633), however, the count distinct count(a,b) returns a value less that that sum, meaning it picks up some duplicates. 

However, (a in b) and (b in a) are null sets. 

Kumar

3

It could be that a and b themselves have duplicates?

What is 

count[distinct a] + count distinct b

?

Thanks

Jonny

Sent from my iPhone

4

Yes, you’re right, Jonny, thanks for that. My oversight. 
Much appreciated, 

Kumar