Hi John, I found the problem, there is a column named Imatinib which is also a value of the column Inhibitor ! I have rename the column Imatinib into Imatinib2 and the problem is gone.
Regards, Alexandre Alexandre Maurel a écrit : > Hi John, > > As attachment document , you will find the data and the logs from ibis. > In the log file I have highlighted the problem. > > Imatinib, 105006101, 4, 4, FP83, 6 error , this row should not > be there ( ! (Inhibitor = 'Imatinib' AND Barcode = '105006101' AND Row > = 4 AND Col = 4 AND Sample_name = 'FP83')) > > Note , I have run the following queries which are identical, and they > give the same error. > > select Inhibitor,Barcode,Row,Col,Sample_name where ( ( ! (Inhibitor = > 'DMSO' AND Barcode = '105006101' AND Row = 1 AND Col = 1 AND > Sample_name = 'PA97')) AND ( ! (Inhibitor = 'Imatinib' AND Barcode = > '105006101' AND Row = 4 AND Col = 4 AND Sample_name = 'FP83'))) > > select Inhibitor,Barcode,Row,Col,Sample_name where ((Inhibitor != > 'DMSO' OR Barcode != '105006101' OR Row != 1 OR Col != 1 OR > Sample_name != 'PA97') AND (Inhibitor != 'Imatinib' OR Barcode != > '105006101' OR Row != 4 OR Col != 4 OR Sample_name != 'FP83')) > > Regards, > > Alexandre > > [email protected] a écrit : >> Send FastBit-users mailing list submissions to >> [email protected] >> >> To subscribe or unsubscribe via the World Wide Web, visit >> https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users >> or, via email, send a message with subject or body 'help' to >> [email protected] >> >> You can reach the person managing the list at >> [email protected] >> >> When replying, please edit your Subject line so it is more specific >> than "Re: Contents of FastBit-users digest..." >> >> >> Today's Topics: >> >> 1. Re: bundle segment method reorder the raw data (Alexandre Maurel) >> >> >> ---------------------------------------------------------------------- >> >> Message: 1 >> Date: Wed, 18 Nov 2009 09:54:37 +0100 >> From: Alexandre Maurel <[email protected]> >> Subject: Re: [FastBit-users] bundle segment method reorder the raw >> data >> To: [email protected] >> Message-ID: <[email protected]> >> Content-Type: text/plain; charset=ISO-8859-1; format=flowed >> >> Hi John, >> >> Problem is solved , >> >> Thanks, >> >> Alexandre >> >> [email protected] a ?crit : >> >>> Send FastBit-users mailing list submissions to >>> [email protected] >>> >>> To subscribe or unsubscribe via the World Wide Web, visit >>> https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users >>> or, via email, send a message with subject or body 'help' to >>> [email protected] >>> >>> You can reach the person managing the list at >>> [email protected] >>> >>> When replying, please edit your Subject line so it is more specific >>> than "Re: Contents of FastBit-users digest..." >>> >>> >>> Today's Topics: >>> >>> 1. Re: bundle segment method reorder the raw data (K. John Wu) >>> >>> >>> ---------------------------------------------------------------------- >>> >>> Message: 1 >>> Date: Mon, 16 Nov 2009 17:25:27 -0800 >>> From: "K. John Wu" <[email protected]> >>> Subject: Re: [FastBit-users] bundle segment method reorder the raw >>> data >>> To: FastBit Users <[email protected]> >>> Message-ID: <[email protected]> >>> Content-Type: text/plain; charset=ISO-8859-1; format=flowed >>> >>> Hi, Alexandre, >>> >>> I have implemented some changes that I think will address the >>> problem you've encountered. The code has been checked in to SVN. >>> If you get the chance, please give the nightly snapshot a try and >>> let us know if it does address the problem. >>> >>> The nightly snapshot is available at >>> <https://codeforge.lbl.gov/snapshots.php?group_id=44>. You might >>> have to wait till the new snapshot is built during the middle of the >>> night pacific time. >>> >>> John >>> >>> >>> On 11/16/2009 1:24 AM, Alexandre Maurel wrote: >>> >>>> Hi John, >>>> >>>> I think I found a problem in function ibis::column::selectValuesT. >>>> When a query does not specify a where clause or when mask.cnt() == >>>> mask.size(), the method ibis::column::selectValuesT return a >>>> pointer on raw data ... >>>> Which cause the bundle segment method to reorder the raw data ! >>>> >>>> template <typename T> >>>> long ibis::column::selectValuesT(const bitvector& mask, >>>> ibis::array_t<T>& vals) const { >>>> ... >>>> ... >>>> if (mask.cnt() == mask.size()) >>>> return getValuesArray(&vals); >>>> ... >>>> ... >>>> if (tot == mask.size()) { // read all values >>>> ierr = ibis::fileManager::instance().getFile(dfn, vals); >>>> return ierr; >>>> } >>>> >>>> } >>>> >>>> Regards, >>>> >>>> Alexandre >>>> _______________________________________________ >>>> 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 >>> >>> >>> End of FastBit-users Digest, Vol 27, Issue 15 >>> ********************************************* >>> >>> >> >> >> ------------------------------ >> >> _______________________________________________ >> FastBit-users mailing list >> [email protected] >> https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users >> >> >> End of FastBit-users Digest, Vol 27, Issue 16 >> ********************************************* >> >> _______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
