Okey dok, Sheryl keep us posted! Cheers, Chris
On Sep 14, 2011, at 9:18 PM, Sheryl John wrote: > 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 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 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 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
