Hi John, Sorry for this late reply, some how I miss your answer.
Here is the command line I used : .\Debug\ardea.exe -d .\testCase\dimensions\ColPart -m Barcode:k,Row:f,Col:f,Filter:f,Exposure_time:f,Cycle:f,Image:k,Temperature:f,Sample_name:k,Array:k,Sample_volume:f,Inhibitor:k,Inhibitor_conc_:f,Antibody:k,ATP_conc_:f,Visual_QC:k,Strip:f,Imatinib_Resistant:f,Imatinib:k -t .\testCase\Array.txt Note that this command line is stored as the description parameter of the partition generated by ardea.exe (see -part.txt file I sent ...) ;-) 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: query error (Alexandre Maurel) > 2. Re: query error (K. John Wu) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 03 Dec 2009 10:41:35 +0100 > From: Alexandre Maurel <[email protected]> > Subject: Re: [FastBit-users] query error > To: [email protected] > Message-ID: <[email protected]> > Content-Type: text/plain; charset="iso-8859-1" > > Hi John, > > The problem is still there. > As attached document you will find ibis log file , generated by the > following command, > > %IBIS% -l log.txt -d .\dimensions\ColPart -q "select Inhibitor where > Inhibitor = 'Imatinib'" > %IBIS% -l log.txt -d .\dimensions\ColPart -q "select Inhibitor where > Inhibitor IN ('Imatinib')" > > Regards, > > Alexandre > > [email protected] a ?crit : > >> Send FastBit-users mailing list submissions to >> [email protected] >> >> Message: 2 >> Date: Mon, 23 Nov 2009 09:55:20 -0800 >> From: "K. John Wu" <[email protected]> >> Subject: Re: [FastBit-users] query error >> To: FastBit Users <[email protected]> >> Message-ID: <[email protected]> >> Content-Type: text/plain; charset=ISO-8859-1; format=flowed >> >> Hi, Alexandre, >> >> Thanks for reporting the problem and exploring the solutions. It >> turned out that we can tweak the lexer a little to recognize all >> quoted strings as string literals -- which eliminate the ambiguity in >> whether a string a column name or a string literal and correctly >> represents the original intend of your query expression. The change >> has been checked into the SVN repository. Please give the nightly >> snapshot a try when you get the chance. >> >> John >> >> PS: The nightly snapshot is available at >> <https://codeforge.lbl.gov/snapshots.php?group_id=44> and it is built >> in the early morning hours Pacific Time -- which means you will need >> to wait till tomorrow morning in order to get your hand on it. If you >> want to try it earlier, please let me know, I will send you the source >> code separately. >> >> >> >> > -------------- next part -------------- > An embedded and charset-unspecified text was scrubbed... > Name: log.txt > Url: > http://hpcrdm.lbl.gov/pipermail/fastbit-users/attachments/20091203/08d6c17e/attachment-0001.txt > > > ------------------------------ > > Message: 2 > Date: Thu, 03 Dec 2009 10:35:11 -0800 > From: "K. John Wu" <[email protected]> > Subject: Re: [FastBit-users] query error > To: FastBit Users <[email protected]> > Message-ID: <[email protected]> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > Hi, Alexandre, > > Thanks for getting back to us. To make it a little easier for us to > verify the problem has been fixed correctly, would you mind send us > the column names and types you used to process the CSV data in > Array.txt (you sent us earlier)? I think I am fixing correctly this > time around, but need to verify it to be sure ;-) > > John > > PS: You can either send us the command line of ardea you used process > Array.txt or a file containing the names and types in the order as > they appear in the file Array.txt. The content of -part.txt has all > the right names and types, but they are not in the right order -- I > have trouble matching the orders. > > > On 12/3/2009 1:41 AM, Alexandre Maurel wrote: > >> Hi John, >> >> The problem is still there. >> As attached document you will find ibis log file , generated by the >> following command, >> >> %IBIS% -l log.txt -d .\dimensions\ColPart -q "select Inhibitor where >> Inhibitor = 'Imatinib'" >> %IBIS% -l log.txt -d .\dimensions\ColPart -q "select Inhibitor where >> Inhibitor IN ('Imatinib')" >> >> Regards, >> >> Alexandre >> >> [email protected] a ?crit : >> >>> Send FastBit-users mailing list submissions to >>> [email protected] >>> >>> Message: 2 >>> Date: Mon, 23 Nov 2009 09:55:20 -0800 >>> From: "K. John Wu" <[email protected]> >>> Subject: Re: [FastBit-users] query error >>> To: FastBit Users <[email protected]> >>> Message-ID: <[email protected]> >>> Content-Type: text/plain; charset=ISO-8859-1; format=flowed >>> >>> Hi, Alexandre, >>> >>> Thanks for reporting the problem and exploring the solutions. It >>> turned out that we can tweak the lexer a little to recognize all >>> quoted strings as string literals -- which eliminate the ambiguity in >>> whether a string a column name or a string literal and correctly >>> represents the original intend of your query expression. The change >>> has been checked into the SVN repository. Please give the nightly >>> snapshot a try when you get the chance. >>> >>> John >>> >>> PS: The nightly snapshot is available at >>> <https://codeforge.lbl.gov/snapshots.php?group_id=44> and it is built >>> in the early morning hours Pacific Time -- which means you will need >>> to wait till tomorrow morning in order to get your hand on it. If you >>> want to try it earlier, please let me know, I will send you the source >>> code separately. >>> >>> >>> >> ------------------------------------------------------------------------ >> >> _______________________________________________ >> 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 28, Issue 1 > ******************************************** > > _______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
