Tom, I am glad to hear that someone is using the aliases to query the FileManager. Here is the wiki page I started to document examples of how to use the aliases and different use cases.
https://cwiki.apache.org/OODT/bash-and-tcsh-shell-tools-for-file-manager.html On to the questions: The SQL query does what I expect ;-) but with one problem - in what order will I receive the data? I can't figure out an automatic way to find out which column is which data. >>> I would hope the data would be returned in the same order you asked for it. Given your example though the order may not be preserved. Is full SQL query syntax supported? >>> I don't believe it is. It is intended to be a simple way to form queries. The Lucene query returns the productID. Is there a class I can use that will return something similar to the sql query? (Although I should look at the code and find this out for myself - asking is free :-) >>> Not sure, maybe someone else can chime in. I've not yet tested any more complex SQL and Lucene queries - I was just wondering if there where any useful info out there that would show me some more funky example queries. So far I've found lucene tutorial<http://www.lucenetutorial.com/lucene-query-syntax.html> and sql quick ref <http://www.w3schools.com/sql/sql_quickref.asp>. I'll tie this into OODT Filemgr User Guide<https://cwiki.apache.org/confluence/display/OODT/OODT+Filemgr+User+Guide> once I've figured these things out. I see the version of lucene being used it quiet old (2.0.0 and the latest ver is 2.9.1). Is there any reason why OODT is using this old version? Should I be spending the effort to use a different (i.e. sql database) or are other OODT implementations using lucene? >>> The intent is to enable simple queries into the FileManager. Several projects initially use Lucene here at JPL. Sometimes though the project out grows the capabilities of Lucene, and we start to consider a different catalog solution. On LMMP we used BerkeleyDB when Paul Ramirez wrote a custom catalog, and on RCMES Andrew Hart wrote a custom Catalog to normalize metadata and store it directly in MySQL. Hope that helps. -Cameron On Fri, Sep 23, 2011 at 6:30 AM, Thomas Bennett <[email protected]> wrote: > Hi, > > I have a few questions about building queries for filemgr lucene catalogs > and I was thinking someone may be able to help me. > > I've ingested some files into catalog and then using the command line tools > (and aliases - thanks Cameron!) to query the catalog. > > I'm not too familiar with writing SQL queries, but I've been able to > achieve the the following types of queries: > > bin$ ./query_tool --url http://localhost:9000 --sql -query "SELECT > Observer,Description,Duration,ExperimentID FROM KatFile WHERE > Observer='jasper'" --sortBy Duration > > Which returns: > ..... > jasper,a9909ae6-822b-11e0-a7a1-0060dd4721d8,Target track,637.841571569 > jasper,47c3a4da-822a-11e0-a7a1-0060dd4721d8,Target track,565.859450817 > jasper,777b0f34-8224-11e0-a7a1-0060dd4721d8,Target track,80.9798858166 > > * > * > bin$ ./query_tool --url http://localhost:9000 --lucene -query > 'Observer:sharmila' > > Which returns: > ....... > ba9b292e-e506-11e0-ad74-9f1c5e7f0611 > b93dbc0d-e506-11e0-ad74-9f1c5e7f0611 > b7e530ec-e506-11e0-ad74-9f1c5e7f0611 > b66ff60b-e506-11e0-ad74-9f1c5e7f0611 > afc6556a-e506-11e0-ad74-9f1c5e7f0611 > * > * > * > * > *Questions:* > > 1. The SQL query does what I expect ;-) but with one problem - in what > order will I receive the data? I can't figure out an automatic way to find > out which column is which data. > 2. Is full SQL query syntax supported? > 3. The Lucene query returns the productID. Is there a class I can use > that will return something similar to the sql query? (Although I should > look > at the code and find this out for myself - asking is free :-) > 4. I've not yet tested any more complex SQL and Lucene queries - I was > just wondering if there where any useful info out there that would show me > some more funky example queries. So far I've found lucene > tutorial<http://www.lucenetutorial.com/lucene-query-syntax.html> > and sql quick ref <http://www.w3schools.com/sql/sql_quickref.asp>. I'll > tie this into OODT Filemgr User > Guide<https://cwiki.apache.org/confluence/display/OODT/OODT+Filemgr+User+Guide> > once > I've figured these things out. > 5. I see the version of lucene being used it quiet old (2.0.0 and the > latest ver is 2.9.1). Is there any reason why OODT is using this old > version? > 6. Should I be spending the effort to use a different (i.e. sql > database) or are other OODT implementations using lucene? > > Thanks in advance for any help. > > Kind regards, > Tom > -- Sent from a Tin Can attached to a String
