[kepler-users] recommended way to link data from database query to R expression?

[ben leinfelder]

Hi David - 
I believe there are a few output options for the DB query actor. Tokens emitted from it can be sent directly to the R actor or they can be transformed using some of the other utility actors included in Kepler.
If you choose 'record' as the output type, I believe you will end up with a RecordToken (and then a data frame in R)
If you choose 'array' as the output type, you should end up with a list of RecordTokens.
If you first print your output to a Display actor, you will have a better idea of what kind of token manipulation you may need to perform in order to get exactly what you want.
If you get a sample workflow put together, please send it our way for with specific questions.
-ben

On Aug 16, 2010, at 10:59 AM, David LeBauer wrote:

> Hi,
> 
> I am new to Kepler. I am trying to use the Database Query Actor to
> query an array and then use the array in R. In R, the commands
> fetch(dbSendQuery()) return an array.
> 
> I have Kepler set up to retreive the data, but I would like to know
> what format the output should be, and then how to use that as an input
> in an R module.
> 
> Thank you,
> 
> David
> 
> 
> -- 
> David LeBauer, PhD
> Energy Biosciences Institute
> University of Illinois Urbana-Champaign
> 1206 W. Gregory Drive
> Urbana, IL  61801, U.S.A.
> _______________________________________________
> Kepler-users mailing list
> Kepler-users at kepler-project.org
> http://mercury.nceas.ucsb.edu/kepler/mailman/listinfo/kepler-users