Hi Guys

I’m hoping someone can point me in the right direction or help me out here.

We collect netflow type information and store it in fastbit, but on some 
occasions it appears that the sum() is not adding all the rows together on the 
where clause.

—snip—
$ ibis -d ./archive/day/2016/06/26 -q "SELECT 
sum(IN_BYTES),IPV4_SRC_ADDR,IPV4_DST_ADDR,APPLICATION,PROTOCOL WHERE 
IPV4_DST_ADDR=3290788180 AND NOT IPV4_SRC_ADDR BETWEEN 3289316736 AND 
3289316863" -o /dev/stdout | sort -rn 

tableSelect -- 
select(sum(IN_BYTES),IPV4_SRC_ADDR,IPV4_DST_ADDR,APPLICATION,PROTOCOL, 
IPV4_DST_ADDR=3290788180 AND NOT IPV4_SRC_ADDR BETWEEN 3289316736 AND 
3289316863) on table T-26 produced a table with 6714 rows and 5 columns
12825571012, 3290643812, 3290788180, 143, 6
1535037401, 3290643812, 3290788180, 143, 6
—snip—

From the above you can see that in the resulting data it should be 1 line with 
the sum values 1535037401 and 12825571012 added together, as the  rest of the 
row is the same, so by all rights should be added together.

We are running:
—snip—
ibis --version

FastBit ibis1.3.8
—snip—

On FreeBSD 9.3-RELEASE.



--
Alan Kemp
Support: 0861 IRISNS (474767)
Office:  +27 21 418 4840
Mobile: +27 83 257 5970
IRIS Network Systems





_______________________________________________
FastBit-users mailing list
FastBit-users@hpcrdm.lbl.gov
https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users

Reply via email to