Dear Bao Toan Nguyen, The basic problem is that the integer constants you are using are too long to fit in a double precision floating-point number which is used to store most of the constants inside FastBit. You can try the following (to replace your expression)
where MaTB = 144115188075857871ULL OR MaTB = 144115188075857872ULL The restriction is that you have to indicate these numbers are "unsigned long long" with the ULL suffix and you can only use these numbers in equality expressions shown above. Hope this helps. John PS: Please send your email to the mailing list, it might help others too. On 1/15/12 7:06 PM, bao toan nguyen wrote: > Hi ,K. John Wu ! > > I use function "fastbit_build_query" in field ULong(name feild : > 'MaTB") with swhere=" MaTB between *144115188075857871 * and > *144115188075857872* ", but in result of query have value " > *144115188075857888* " ??? > I don't know why have this value ??? > (i build index for "MaTB" with mode:=" <binning none/><encoding range/>") > > thanks very much team FastBit was supported . > best regards ! > > 2012/1/5 K. John Wu <[email protected] <mailto:[email protected]>> > > Hi, Bao Toan Nguyen, > > Thanks for your interest in FastBit software. > > Based on what you have said, it is likely that your queries can be > answered with indexes built by FastBit, however, the data records you > want to retrieve are actually scatter around in the data files. > Effectively, FastBit has to read the whole data file and then pick out > the entries you want. A strategy to improve the retrieval speed is to > reorganize the data records so that you don't have read the whole data > file. > > Hope this helps. > > John > > > > On 1/4/12 7:04 PM, bao toan nguyen wrote: > > hi ! K. John Wu > > > > I use FastBit 2.4, when use Query is very very fast ,but i get > records > > of this Query very very slowly(i use function > > fastbit_get_qualified_xxxx ). ??? > > > > what's function use to get records of Query to fast ? > > > > best regards ! > > > > > -- > Nguyen Bao Toan. _______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
