Excellent! Thanks a bunch - that did the trick - all defined and my terms are being returned nicely - schema.xml was the ticket - not sure how I missed that in the docs.
Kevin -----Original Message----- From: Shalin Shekhar Mangar [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2008 11:35 PM To: solr-user@lucene.apache.org Subject: Re: Newbie Question - getting search results from dataimport request handler Hi Kevin, You need to modify the schema which came with Solr to suit your data. There should be a schema.xml inside example/solr/conf directory. Once you do that, re-import your data. Take a look at http://wiki.apache.org/solr/SchemaXml On Tue, Nov 11, 2008 at 10:59 AM, Kevin Penny <[EMAIL PROTECTED]> wrote: > I can execute: /solr/select?q=id:87133 > > So there is data there, however I have not defined any 'Fields' in my > data-config and am hoping my column names are the 'fields', yet I'm not > seeing any of them being returned in the 'doc' node below : > > > <response> > - > <lst name="responseHeader"> > <int name="status">0</int> > <int name="QTime">0</int> > - > <lst name="params"> > <str name="q">id:87133</str> > </lst> > </lst> > - > <result name="response" numFound="1" start="0"> > - > <doc> > <str name="id">87133</str> > <int name="popularity">0</int> > <str name="sku">87133</str> > <date name="timestamp">2008-11-11T05:25:29Z</date> > </doc> > </result> > </response> > > Kevin > > -----Original Message----- > From: Noble Paul നോബിള് नोब्ळ् [mailto:[EMAIL PROTECTED] > Sent: Monday, November 10, 2008 11:23 PM > To: solr-user@lucene.apache.org > Subject: Re: Newbie Question - getting search results from dataimport > request handler > > search for *:* and see if the index indeed has the documents . > Once you ensure the docs are there go through the lucene query syntax > and check your query > > On Tue, Nov 11, 2008 at 10:07 AM, Kevin Penny <[EMAIL PROTECTED]> wrote: > > Ok so I executed a: > > solr/dataimport?command=full-import > > then I checked here: > > solr/dataimport > > > > I get a good xml message (figure 1.1) showing me that 125 records have > been indexed (good) and I know one of them contains the word 'job'. > > > > I sould get results from this query string then right (figure 1.0 is my > result - 0 records found)? > > solr/select?q=job > > > > > > figure 1.0 > > <response> > > − > > <lst name="responseHeader"> > > <int name="status">0</int> > > <int name="QTime">0</int> > > − > > <lst name="params"> > > <str name="q">job</str> > > </lst> > > </lst> > > <result name="response" numFound="0" start="0"/> > > </response> > > > > figure 1.1 > > <response> > > − > > <lst name="responseHeader"> > > <int name="status">0</int> > > <int name="QTime">0</int> > > </lst> > > − > > <lst name="initArgs"> > > − > > <lst name="defaults"> > > <str name="config">data-config.xml</str> > > </lst> > > </lst> > > <str name="status">idle</str> > > <str name="importResponse"/> > > − > > <lst name="statusMessages"> > > <str name="Total Requests made to DataSource">1</str> > > <str name="Total Rows Fetched">125</str> > > <str name="Total Documents Skipped">0</str> > > <str name="Full Dump Started">2008-11-10 22:33:55</str> > > − > > <str name=""> > > Indexing completed. Added/Updated: 125 documents. Deleted 0 documents. > > </str> > > <str name="Committed">2008-11-10 22:34:00</str> > > <str name="Optimized">2008-11-10 22:34:00</str> > > <str name="Time taken ">0:0:5.79</str> > > </lst> > > − > > <str name="WARNING"> > > This response format is experimental. It is likely to change in the > future. > > </str> > > </response> > > > > Kevin > > > > -----Original Message----- > > From: Noble Paul നോബിള് नोब्ळ् [mailto:[EMAIL PROTECTED] > > Sent: Monday, November 10, 2008 10:30 PM > > To: solr-user@lucene.apache.org > > Subject: Re: Newbie Question - getting search results from dataimport > request handler > > > > XML is just an intermediete data format Solr internally has no XML > > data. When the data comes out XML is just another representation of > > the same data. > > > > Whether you put in data using XML or DB (SQL) it all goes into the > > same index . Query must be done on that index using the syntax > > http://localhost:8983/solr/select/?q=<your-query-goes-here> > > > > On Tue, Nov 11, 2008 at 9:55 AM, Kevin Penny <[EMAIL PROTECTED]> > wrote: > >> Ok - and what would that be? (query interface) > >> > >> I need the URL format that would work in this situation to return data > from my setup. > >> > >> I've gone through the tutorial and used execution strings like: > >> http://localhost:8983/solr/select/?indent=on&q=video&sort=price+desc > >> etc however I'm working with sql data and not xml data. > >> > >> Thanks > >> > >> -----Original Message----- > >> From: Noble Paul നോബിള് नोब्ळ् [mailto:[EMAIL PROTECTED] > >> Sent: Monday, November 10, 2008 10:18 PM > >> To: solr-user@lucene.apache.org > >> Subject: Re: Newbie Question - getting search results from dataimport > request handler > >> > >> you cannot query the DIH. It can only do indexing > >> after indexing you must do the indexing on the regular query interface > >> > >> On Tue, Nov 11, 2008 at 9:45 AM, Kevin Penny <[EMAIL PROTECTED]> > wrote: > >>> My Question is: what is the format of a search that will return data? > >>> i.e. /solr/select?q=developer&qt=dataimport (won't work) nor will > /solr/dataimport?q=developer (won't work) > >>> "HTTP ERROR: 404 > >>> NOT_FOUND > >>> RequestURI=/solr/dataimport" > >>> > >>> I have created a 'dataimport' set that contains data from a sql db. > >>> > >>> I can view meta data from this url: /solr/dataimport > >>> <response> > >>> − > >>> <lst name="responseHeader"> > >>> <int name="status">0</int> > >>> <int name="QTime">0</int> > >>> </lst> > >>> − > >>> <lst name="initArgs"> > >>> − > >>> <lst name="defaults"> > >>> <str name="config">data-config.xml</str> > >>> </lst> > >>> </lst> > >>> <str name="status">idle</str> > >>> <str name="importResponse"/> > >>> − > >>> <lst name="statusMessages"> > >>> <str name="Total Requests made to DataSource">1</str> > >>> <str name="Total Rows Fetched">10</str> > >>> <str name="Total Documents Skipped">0</str> > >>> <str name="Full Dump Started">2008-11-10 21:51:40</str> > >>> <str name="Time taken ">0:0:4.594</str> > >>> </lst> > >>> − > >>> <str name="WARNING"> > >>> This response format is experimental. It is likely to change in the > future. > >>> </str> > >>> </response> > >>> > >>> I can verify that the data is there by going through > /solr/admin/dataimport.jsp and doing 'verbose' true and debug now. > >>> It shows me the xml data set on the right as such: > >>> > >>> <response> > >>> − > >>> <lst name="responseHeader"> > >>> <int name="status">0</int> > >>> <int name="QTime">4594</int> > >>> </lst> > >>> − > >>> <lst name="initArgs"> > >>> − > >>> <lst name="defaults"> > >>> <str name="config">data-config.xml</str> > >>> </lst> > >>> </lst> > >>> <str name="command">full-import</str> > >>> <str name="mode">debug</str> > >>> − > >>> <arr name="documents"> > >>> − > >>> <arr> > >>> − > >>> <arr> > >>> <int>87133</int> > >>> </arr> > >>> </arr> > >>> − > >>> <arr> > >>> − > >>> <arr> > >>> <int>87134</int> > >>> </arr> > >>> </arr> > >>> − > >>> <arr> > >>> − > >>> <arr> > >>> <int>87135</int> > >>> </arr> > >>> </arr> > >>> − > >>> <arr> > >>> − > >>> <arr> > >>> <int>87136</int> > >>> </arr> > >>> </arr> > >>> − > >>> <arr> > >>> − > >>> <arr> > >>> <int>87137</int> > >>> </arr> > >>> </arr> > >>> − > >>> <arr> > >>> − > >>> <arr> > >>> <int>87138</int> > >>> </arr> > >>> </arr> > >>> − > >>> <arr> > >>> − > >>> <arr> > >>> <int>87139</int> > >>> </arr> > >>> </arr> > >>> − > >>> <arr> > >>> − > >>> <arr> > >>> <int>87140</int> > >>> </arr> > >>> </arr> > >>> − > >>> <arr> > >>> − > >>> <arr> > >>> <int>87141</int> > >>> </arr> > >>> </arr> > >>> − > >>> <arr> > >>> − > >>> <arr> > >>> <int>87142</int> > >>> </arr> > >>> </arr> > >>> </arr> > >>> − > >>> <lst name="verbose-output"> > >>> − > >>> <lst name="entity:item"> > >>> − > >>> <lst name="document#1"> > >>> − > >>> <str name="query"> > >>> SELECT j.id , j.title , FROM dbo.jobs j WITH (NOLOCK) > LEFT WHERE j.siteid = 46 and j.active = 1 > >>> </str> > >>> <str name="time-taken">0:0:4.578</str> > >>> <str>----------- row #1-------------</str> > >>> <str name="zip"/> > >>> <str name="urltitle">Operations Software Developer Job</str> > >>> <str name="altlocation">SAN ANTONIO, TX, 78229</str> > >>> <str name="alttitle">Ope… > >>> > >>> > >>> Here is my solconfig.xml > >>> … > >>> <requestHandler name="dataimport" > class="org.apache.solr.handler.dataimport.DataImportHandler"> > >>> <lst name="defaults"> > >>> <str name="config">data-config.xml</str> > >>> </lst> > >>> </requestHandler> > >>> … > >>> Data-config.xml is in the same dir as solconfig.xml > >>> > >>> My data-config.xml is like any other: > >>> <dataConfig> > >>> <dataSource driver="com.microsoft.sqlserver.jdbc.SQLServerDriver" > >>> url="jdbc:sqlserver://xxxxxxxx:1433;databaseName=xxxxx" user="xxxxx" > password="xxxxx" /> > >>> <document name="jobs"> > >>> <entity name="item" pk="id" query="SELECT j.id > >>> , j.title > >>> … > >>> FROM > >>> dbo.jobs … > >>> WHERE j.siteid = 46 and > j.active = 1" > >>> deltaQuery="select id from dbo.jobs where lastmodified > > '${dataimporter.last_index_time}'"> > >>> > >>> </entity> > >>> </document> > >>> </dataConfig> > >>> > >>> I'm using win xp with apache – and jetty + solr 1.3.0 > >>> > >>> Thanks > >>> > >>> > >>> > >> > >> > >> > >> -- > >> --Noble Paul > >> > > > > > > > > -- > > --Noble Paul > > > > > > -- > --Noble Paul > -- Regards, Shalin Shekhar Mangar.
