Hi, Gerrit, FastBit supports a small number of operations with NULL values. In the where clause, NULL can appears in one expression,
column-name NOT NULL To get rows where the particular column has NULL values, you can negate the above expression NOT (column-name NOT NULL) We have not exercised the select clause involving NULL values since our original design was to preclude all NULL values from the select clauses. This restriction has been relaxed a little. Feel free to let us know if you spot anything that needs attention. John On 8/1/12 11:13 AM, Gerrit Hendrikus van Doorn wrote: > Hi, > > I was wondering what the correct way is to handle NULL values. I'm > aware that fastbit stores empty values in a .msk file, but am I able > to query NULL values? One option is to assign some specific value for > NULL values (like MAX_INT). However, this might mess up the meta-data > inside the -part.txt. How are the min/max values in -part.txt used? > > Thanks, > Gerrit > > > _______________________________________________ > FastBit-users mailing list > [email protected] > https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users > _______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
