oodt-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mattmann, Chris A (388J)" <chris.a.mattm...@jpl.nasa.gov>
Subject Re: PGETask Metadata
Date Thu, 15 Sep 2011 03:42:32 GMT
Hi Sheryl,

I notice you're using double quotes on the RecordID = "PID", yet you are using single quotes
on ISMTable = 'Chartevents'. 

Try using single quotes on both and see if that fixes it.

Thanks!

Cheers,
Chris

On Sep 14, 2011, at 7:03 PM, Sheryl John wrote:

> Hi,
> 
> I have defined some key-val pairs for a file( say Output.csv) in a metout-config.xml
for my PGETask Workflow. However, after executing the workflow, the met-config.xml is not
creating a Output.csv.cas file. 
> 
> I want to be able to use the above keys/metadata later on in an SQL-like query from the
pgeconfig file. For example, if I've defined 'RecordID' as a key in the metout-config.xml,
I would want to use this metadata in the following query:
> 
> SQL(FORMAT='$FileLocation/$Filename'){ SELECT FileLocation,Filename,ISMTable,RecordID
FROM ISMRawData WHERE ISMTable = 'Chartevents'  AND RecordID = "PID"}  The others keys included
in the query above are elements and product-types that were defined during ingestion in the
File Manager.
> 
> At present, the task fails to parse the above query when I run the workflow. Is this
because metout-config is not creating the Output.cas file?  And, what is the best way to specify
metadata files for a group of files or for a folder?
> 
> Thanks,
> Sheryl


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Chris Mattmann, Ph.D.
Senior Computer Scientist
NASA Jet Propulsion Laboratory Pasadena, CA 91109 USA
Office: 171-266B, Mailstop: 171-246
Email: chris.a.mattmann@nasa.gov
WWW:   http://sunset.usc.edu/~mattmann/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Adjunct Assistant Professor, Computer Science Department
University of Southern California, Los Angeles, CA 90089 USA
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++


Mime
View raw message