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]>> 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
