Hello John,
The problem is solved for the following query :
%IBIS% -l log.txt -d .\dimensions\ColPart -q "select Inhibitor where Inhibitor
= 'Imatinib'"
but this one failed :
%IBIS% -l log.txt -d .\dimensions\ColPart -q "select Inhibitor where Inhibitor
IN ('Imatinib')"
with the following message :
ibis::whereParser encountered syntax error at location Inhibitor IN
('Imatinib'):1.14-23
Warning -- whereClause(Inhibitor IN ('Imatinib')) failed to parse the string
into an expression tree
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: Tue, 08 Dec 2009 10:30:47 +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; format=flowed
>
> 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
>> ********************************************
>>
>>
>>
>
>
> ------------------------------
>
> Message: 2
> Date: Tue, 08 Dec 2009 10:21:47 -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 the information. I have just successfully run the query
> that was giving you trouble. The code has been checked into the SVN
> repository. The nightly snapshot is available at
> <https://codeforge.lbl.gov/snapshots.php?group_id=44> and is generated
> daily around 2AM PST. When you get a chance, please give it a try and
> let us know if it works for you.
>
> We would like to turn your test data (Array.txt) and sample query into
> part of the built-in tests. Would you mind grand us the permission to
> do so? In addition, would you like to add a few more queries for this
> purpose?
>
> John
>
>
>
> ------------------------------
>
> _______________________________________________
> FastBit-users mailing list
> [email protected]
> https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
>
>
> End of FastBit-users Digest, Vol 28, Issue 2
> ********************************************
>
>
_______________________________________________
FastBit-users mailing list
[email protected]
https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
