advice on creating a solr index when data source is from many unrelated db tables
I understand (and its straightforward) when you want to create a index for something simple like Products. But how do you go about creating a Solr index when you have data coming from 10-15 database tables, and the tables have unrelated data? The issue is then you would have many 'columns' in your index, and they will be NULL for much of the data since you are trying to shove 15 db tables into a single Solr/Lucense index. This must be a common problem, what are the potential solutions?
Re: advice on creating a solr index when data source is from many unrelated db tables
So I have tables like this: Users UserSales UserHistory UserAddresses UserNotes ClientAddress CalenderEvent Articles Blogs Just seems odd to me, jamming on these tables into a single index. But I guess the idea of using a 'type' field to quality exactly what I am searching is a good idea, in case I need to filter for only 'articles' or blogs or contacts etc. But there might be 50 fields if I do this no? On Fri, Jul 30, 2010 at 4:01 AM, Chantal Ackermann < chantal.ackerm...@btelligent.de> wrote: > Hi Ahmed, > > fields that are empty do not impact the index. It's different from a > database. > I have text fields for different languages and per document there is > always only one of the languages set (the text fields for the other > languages are empty/not set). It works all very well and fast. > > I wonder more about what you describe as "unrelated data" - why would > you want to put unrelated data into a single index? If you want to > search on all the data and return mixed results there surely must be > some kind of relation between the documents? > > Chantal > > On Thu, 2010-07-29 at 21:33 +0200, S Ahmed wrote: > > I understand (and its straightforward) when you want to create a index > for > > something simple like Products. > > > > But how do you go about creating a Solr index when you have data coming > from > > 10-15 database tables, and the tables have unrelated data? > > > > The issue is then you would have many 'columns' in your index, and they > will > > be NULL for much of the data since you are trying to shove 15 db tables > into > > a single Solr/Lucense index. > > > > > > This must be a common problem, what are the potential solutions? > > > >
run on reboot on windows
Hi, I'm trying to get Solr to run on windows, such that if it reboots the Solr service will be running. How can I do this?
Re: run on reboot on windows
By default it uses Jetty, so your saying Tomcat on windows server 2008/ IIS7 runs as a native windows service? On Sun, May 2, 2010 at 12:46 AM, Dave Searle wrote: > Set tomcat6 service to auto start on boot (if running tomat) > > Sent from my iPhone > > On 2 May 2010, at 02:31, "S Ahmed" wrote: > > > Hi, > > > > I'm trying to get Solr to run on windows, such that if it reboots > > the Solr > > service will be running. > > > > How can I do this? >
Re: run on reboot on windows
its not tomcat/jetty that's the issue, its how to get things to re-start on a windows server (tomcat and jetty don't run as native windows services) so I am a little confused..thanks. On Sun, May 2, 2010 at 7:37 PM, caman wrote: > > Ahmed, > > > > Best is if you take a look at the documentation of jetty or tomcat. SOLR > can > run on any web container, it's up to you how you configure your web > container to run > > > > Thanks > > Aboxy > > > > > > > > > > > > From: S Ahmed [via Lucene] > [mailto:ml-node+772174-2097041460-124...@n3.nabble.com > ] > Sent: Sunday, May 02, 2010 4:33 PM > To: caman > Subject: Re: run on reboot on windows > > > > By default it uses Jetty, so your saying Tomcat on windows server 2008/ > IIS7 > > runs as a native windows service? > > On Sun, May 2, 2010 at 12:46 AM, Dave Searle <[hidden email]>wrote: > > > > Set tomcat6 service to auto start on boot (if running tomat) > > > > Sent from my iPhone > > > > On 2 May 2010, at 02:31, "S Ahmed" <[hidden email]> wrote: > > > > > Hi, > > > > > > I'm trying to get Solr to run on windows, such that if it reboots > > > the Solr > > > service will be running. > > > > > > How can I do this? > > > > > > _ > > View message @ > > http://lucene.472066.n3.nabble.com/run-on-reboot-on-windows-tp770892p772174. > html > To start a new topic under Solr - User, email > ml-node+472068-464289649-124...@n3.nabble.com > To unsubscribe from Solr - User, click > < (link removed) > GZvcnRoZW90aGVyc3R1ZmZAZ21haWwuY29tfDQ3MjA2OHwtOTM0OTI1NzEx> here. > > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/run-on-reboot-on-windows-tp770892p772178.html > Sent from the Solr - User mailing list archive at Nabble.com. >
Re: run on reboot on windows
Thanks, for some reason I was looking for a solution outside of jetty/tomcat, when that was the obvious way to get things restarted :) On Sun, May 2, 2010 at 7:53 PM, Dave Searle wrote: > Tomcat is installed as a service on windows. Just go into service > control panel and set startup type to automatic > > Sent from my iPhone > > On 3 May 2010, at 00:43, "S Ahmed" wrote: > > > its not tomcat/jetty that's the issue, its how to get things to re- > > start on > > a windows server (tomcat and jetty don't run as native windows > > services) so > > I am a little confused..thanks. > > > > On Sun, May 2, 2010 at 7:37 PM, caman > > wrote: > > > >> > >> Ahmed, > >> > >> > >> > >> Best is if you take a look at the documentation of jetty or tomcat. > >> SOLR > >> can > >> run on any web container, it's up to you how you configure your web > >> container to run > >> > >> > >> > >> Thanks > >> > >> Aboxy > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> From: S Ahmed [via Lucene] > >> [mailto:ml-node+772174-2097041460-124...@n3.nabble.com > >> %2b772174-2097041460-124...@n3.nabble.com> > >> ] > >> Sent: Sunday, May 02, 2010 4:33 PM > >> To: caman > >> Subject: Re: run on reboot on windows > >> > >> > >> > >> By default it uses Jetty, so your saying Tomcat on windows server > >> 2008/ > >> IIS7 > >> > >> runs as a native windows service? > >> > >> On Sun, May 2, 2010 at 12:46 AM, Dave Searle <[hidden email]>wrote: > >> > >> > >>> Set tomcat6 service to auto start on boot (if running tomat) > >>> > >>> Sent from my iPhone > >>> > >>> On 2 May 2010, at 02:31, "S Ahmed" <[hidden email]> wrote: > >>> > >>>> Hi, > >>>> > >>>> I'm trying to get Solr to run on windows, such that if it reboots > >>>> the Solr > >>>> service will be running. > >>>> > >>>> How can I do this? > >>> > >> > >> > >> > >> _ > >> > >> View message @ > >> > >> > http://lucene.472066.n3.nabble.com/run-on-reboot-on-windows-tp770892p772174 > >> . > >> html > >> To start a new topic under Solr - User, email > >> ml-node+472068-464289649-124...@n3.nabble.com > >> %2b472068-464289649-124...@n3.nabble.com> > >> To unsubscribe from Solr - User, click > >> < (link removed) > >> GZvcnRoZW90aGVyc3R1ZmZAZ21haWwuY29tfDQ3MjA2OHwtOTM0OTI1NzEx> here. > >> > >> > >> > >> > >> -- > >> View this message in context: > >> > http://lucene.472066.n3.nabble.com/run-on-reboot-on-windows-tp770892p772178.html > >> Sent from the Solr - User mailing list archive at Nabble.com. > >> >
