Hi, Rock, Thanks for the detailed description of the problem. I was able locate the source of the error and checked in a fix as SVN revision 463. You may download a read-only copy from the SVN repository with
svn checkout https://codeforge.lbl.gov/anonscm/fastbit If you have already a copy from the SVN, then you simply need to type svn update Please feel free to let us know if you have any issue with the update code. John On 1/19/12 2:48 PM, Rock Wang wrote: > Hi John, > > I use ibis with the supplied test data, the result set doesn't seem as > what you described? > > /ibis -d tmp -q "select a,b,c where a in (0,1)" > a, b, c (with counts) > 0, 0, 99, 1 > 1, 1, 98, 1 > > doQuery:: evaluate(SELECT a,b,c FROM tmp WHERE a in (0,1)) produced 2 > hits, took 0 CPU seconds, 0.0859835 elapsed seconds > > /ibis -d tmp -q "select a,b,c where a in (0,1) and c = 99" > a, b, c (with counts) > 0, 0, 99, 1 > 1, 1, 98, 1 > > doQuery:: evaluate(SELECT a,b,c FROM tmp WHERE a in (0,1) and c = 99) > produced 2 hits, took 0 CPU seconds, 0.00206184 elapsed seconds > > Thanks, > rock > > > On Thu, Jan 19, 2012 at 2:38 PM, John Wu <[email protected] > <mailto:[email protected]>> wrote: > > Hi, Rock, > > The statement you've given should be supported through ibis.cpp as > > ibis -d directory-name -q "select xxx from tal where col in (val1, > val2, val3) and col2 = c" > > (all in one command line). > > I believe "col in (val1, val2, val3)" is equivalent to "(col = val1 or > col = val2 or col = val3)" > > If you find FastBit software behave differently, please feel free to > let us know. > > John > > > On 1/19/12 2:33 PM, Rock Wang wrote: > > Hi John, > > > > Thanks for the reply, does fastbit support IN statement like > > > > select xxx from tal where col in (val1, val2, val3) and col2 = c? > > > > somehow, the result set contains all data where col in (val1, val2, > > val3) is true. > > > > Thanks, > > Rock > > > > On Wed, Jan 18, 2012 at 10:47 AM, John Wu <[email protected] > <mailto:[email protected]> > > <mailto:[email protected] <mailto:[email protected]>>> wrote: > > > > Hi, Rock, > > > > You can use ibis command line tool in examples directory to > add and > > delete rows. More information about the ibis command line > tool is > > available at > > > > <http://lbl.gov/~kwu/fastbit/doc/ibisCommandLine.html> > > > > The Makefile in tests has some example command lines for the > using > > this tool. Look for command lines with '-y' option for > examples of > > removing rows. Look for command lines with '-a' option for > examples > > of adding/appending data. You can also convert CSV files > with either > > readcsv or ardea. > > > > Good luck. > > > > John > > > > > > On 1/18/12 10:26 AM, Rock Wang wrote: > > > Hi John, > > > > > > Do you have examples on how to delete or update in FastBit. > > > > > > Thanks, > > > Rock > > > > > > _______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
