Hi, i am wondering how (and if?) Fastbit handles NULL values. I only found a few references in the documentation about NULL values.
This is one of them: https://sdm.lbl.gov/fastbit/doc/html/classibis_1_1tafel.html#8bfb87b836ec0e5b10a6f0c8a32fa6e6 To me that sounds as if the NULL value for a "int" should be 2^31-1. I can load these values via ardea. However when querying via ibis: How are these null values handled? /home/mop/fastbit/bin/ibis -d null_test -n -q "SELECT x WHERE 1=1" x (with counts) 2147483647, 1 This is fine. /home/mop/fastbit/bin/ibis -d null_test -n -q "SELECT COUNT(x) WHERE 1=1" tableSelect -- select(COUNT(x), 1=1) on table T-null_test produced a table with 1 row and 1 column tableSelect -- the result table (1 x 1) for "SELECT COUNT(x) FROM T-null_test WHERE 1=1" 1 I would fastbit to omit the NULL value here. Same for AVG() and the other aggregate functions. Are NULL values even implemented or am i badly misunderstanding something here? :S Kind regards, Andreas Streichardt _______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
