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: [email protected]
WWW: http://sunset.usc.edu/~mattmann/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Adjunct Assistant Professor, Computer Science Department
University of Southern California, Los Angeles, CA 90089 USA
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
