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 [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
