Hi, Andrew, Thanks for the test case. It appears that it touched on a couple of errors in how FastBit handles string valued columns. Please give SVN Revision 594 a try and see if it fixes the problem for you.
John On 10/25/12 8:36 AM, Olson, Andrew wrote: > Hi John, > I'm having trouble with metaTags when querying a table with multiple > partitions. Querying partitions individually works fine. For example: > > $ thula -d 2 -s "chr,pos" -w "score>9" > doQuery(score>9) evaluated on T-2 produced 13 hits out of 28638 records > -- begin printing the result table -- > Table (in memory) _Sgay1 (filter::sift2(SELECT chr,pos FROM 1 data partition > WHERE 9 < sc ...)) contsists of 2 columns and 13 rows > chr UINT (dictionary size: 1) > pos UINT > "2", 9309523 > "2", 9371326 > "2", 9372649 > "2", 9374871 > "2", 9375825 > "2", 9588685 > "2", 9606045 > "2", 9606657 > "2", 9606791 > "2", 9762418 > -- end printing -- > > > But if you want all the partitions in this directory it fails: > > $ thula -d . -s "chr,pos" -w "score>9" > doQuery(score>9) evaluated on T-1 produced 0 hit out of 215966 records > -- begin printing the result table -- > Table uNw3W (filter::sift2S(SELECT chr,pos FROM 5 data partitions WHERE 9 < s > ...)) contains 0 row and no column > -- end printing -- > > Attached is a tarball of the data which includes verbose output of the failed > command. The most suspicious messages involve filter::sift2S: > > $ grep sift2S thula.stdall > Constructed in-memory data partition uNw3W -- filter::sift2S(SELECT chr,pos > FROM 5 data partitions WHERE 9 < s ...) -- with 2 columns > filter::sift2S(SELECT chr,pos FROM 5 data partitions WHERE 9 < s ...) -- > processing data partition 1 > Warning -- filter::sift2S(SELECT chr,pos FROM 5 data partitions WHERE 9 < s > ...) failed to append 13 rows from 1, ierr = -18 > filter::sift2S(SELECT chr,pos FROM 5 data partitions WHERE 9 < s ...) -- > processing data partition 2 > Warning -- filter::sift2S(SELECT chr,pos FROM 5 data partitions WHERE 9 < s > ...) failed to append 13 rows from 2, ierr = -18 > filter::sift2S(SELECT chr,pos FROM 5 data partitions WHERE 9 < s ...) -- > processing data partition 3 > Warning -- filter::sift2S(SELECT chr,pos FROM 5 data partitions WHERE 9 < s > ...) failed to append 4 rows from 3, ierr = -18 > filter::sift2S(SELECT chr,pos FROM 5 data partitions WHERE 9 < s ...) -- > processing data partition 4 > Warning -- filter::sift2S(SELECT chr,pos FROM 5 data partitions WHERE 9 < s > ...) failed to append 32 rows from 4, ierr = -18 > filter::sift2S(SELECT chr,pos FROM 5 data partitions WHERE 9 < s ...) -- > processing data partition 5 > Warning -- filter::sift2S(SELECT chr,pos FROM 5 data partitions WHERE 9 < s > ...) failed to append 25 rows from 5, ierr = -18 > filter::sift2S(SELECT chr,pos FROM 5 data partitions WHERE 9 < s ...) -- > duration: 0.00539 sec(CPU), 0.0630391 sec(elapsed) > Table uNw3W (filter::sift2S(SELECT chr,pos FROM 5 data partitions WHERE 9 < s > ...)) contains 0 row and no column > > Andrew > > > > _______________________________________________ > 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
