Hi Chris, Thanks for pointing that out. I was working on a different query and similar to the one I described. Though I've used only single quotes now, I'm still getting the same parsing error.
But, I think what I intended to do with context metadata ( for my workflow) doesn't make sense for a single file product and rather, would apply for a group of files. I guess I have revise my workflow logic and metadata use before getting back to this query. Thanks! On Wed, Sep 14, 2011 at 8:42 PM, Mattmann, Chris A (388J) < [email protected]> wrote: > 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 > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > -- -Sheryl
