Re: Quering the database

Thanks alot to all now its clear the problem was in the schema. One more thing i would like to know is if the user queries for something does it have to always be like q=field:monitor where field is defined in schema and monitor is just a text in a column. Hando -- View this message in context:

Re: enhancing auto complete

Whoops! table still not looks ok :( trying to send once again loremLorem ipsum dolor sit amet Hieyed ddi lorem ipsum dolor test lorem ipsume test xyz lorem ipslili lorem ipLorem ipsum dolor sit amet

Re: enhancing auto complete

Avlesh, Thanks for responding The table mentioned below looks like, lorem Lorem ipsum dolor sit amet Hieyed ddi lorem ipsum dolor test lorem ipsume

Re: Solr searching performance issues, using large documents

Spanning won't work- you would have to make overlapping mini-documents if you want to support this. I don't know how big the chunks should be- you'll have to experiment. Lance On Mon, Aug 2, 2010 at 10:01 AM, Peter Spam wrote: > What would happen if the search query phrase spanned separate docu

Re: Problems running on tomcat

I have observed this error while there is mistake in indexed fields.. i.e; The field defined while indexing but undefined in schema... then this error is thrown.. You can check for that missing filed in your Catalina logs.. There it will be written as Unknown filed.. Regards, Rajani Maski On Tu

Re: Multiple solr servers Vs Katta

This is nowhere near the volume of data where you would have to use Katta. Katta has much more limited search and configuration features- it is more a very distributed version of Lucene than a search server. Solr has added a lot of features over and above Lucene. To have 2 query servers for each i

Re: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

> (PS. is there a way where I can test the current connectionstring?) There are many jdbc-explorer apps around that take a jdbc url. You should be able to test your jdbc url and driver with one of those. On Mon, Aug 2, 2010 at 2:33 PM, PeterKerk wrote: > > Hi Michael, > > Thanks, I now use that.

QueryUtils API Change - Custom ExtendedDismaxQParserPlugin accessing QueryUtils.makeQueryable throws java.lang.IllegalAccessError

We have a custom implementation of ExtendedDismaxQParserPlugin, which we bundle into a jar and have it exposed in the multicore shared lib. The custom ExtendedDismaxQParserPlugin implementation still uses QueryUtils makeQueryable method, same as the ExtendedDismaxQParserPlugin implementation. Howev

Re: Queries with multiple wildcards failing in branch3x

This looks like the index corruption caused by a commit on Friday. See the thread I sent earlier with subject "heads up -- index corruption on Solr/Lucene trunk/3.x branch". Mike On Mon, Aug 2, 2010 at 6:00 PM, Paul Dlug wrote: > I'm running a recent build of branch3x (r981609), queries with >

Re: Phrase search

I'm trying to match "Apple 2" but not "Apple2" using phrase search, this is why I have it quoted. I was under the impression --when I use phrase search-- all the analyzer magic would not apply, but it is!!! Otherwise, how would I search for a phrase?! Using Google, when I search for "Windo

Queries with multiple wildcards failing in branch3x

I'm running a recent build of branch3x (r981609), queries with multiple wildcards (e.g. a*b*c*) are failing with the exception below in the log. These queries worked fine for me with solr 1.4, known bug? SEVERE: java.lang.IndexOutOfBoundsException: Index: 114, Size: 39 at java.util.ArrayL

Re: Implementing lookups while importing data

: We have a database that has numeric values for some columns, which : correspond to text values in drop-downs on a website. We need to : index both the numeric and text equivalents into Solr, and can do : that via a lookup on a different table from the one holding the : main data. We are currentl

Re: Phrase search

: I don't understand why i'm getting this behavior. I was under the : impression if I search for "Apple 2" (with quotes and space before “2”) : it will give me different results vs. if I search for "Apple2" (with : quotes and no space before “2”), but I'm not! Why? if you search "Apple 2" in

Re: how to highlight string in jsp

: Subject: how to highlight string in jsp : References: <8cd00862ad8eae9-12e0-2...@webmail-m057.sysops.aol.com> : : In-Reply-To: http://people.apache.org/~hossman/#threadhijack Thread Hijacking on Mailing Lists When starting a new discussion on a mailing list, please do not reply to an exist

Re: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

Hi Michael, Thanks, I now use that. But the same error. (PS. is there a way where I can test the current connectionstring?) Therefore I have attached 1 image with 2 screenshots of my situation. http://lucene.472066.n3.nabble.com/file/n1017327/Untitled.png Untitled.png Here's my current data-c

Re: SolrCore has a large number of SolrIndexSearchers retained in "infoRegistry"

: 1. QueryComponent#process : Is requesting for a SolrIndexSearcher twice by calling : SolrQueryRequest#getSearcher() but is never being closed. I see several : instances where getSearcher is being called but is never being properly : closed - performing a quick call heirarchy of SolrQueryReq

Re: StatsComponent and sint?

: With an sint, it seems to have trouble if there are any documents with : null values for the field. It appears to decide that a null/empty/blank : value is -1325166535, and is thus the minimum value. 1) there is relaly no such thing as a "null" value for a field ... there are documents that

RE: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

Peter: My datasource looks like this: From: PeterKerk [vettepa...@hotmail.com] Sent: Monday, August 02, 2010 4:10 PM To: solr-user@lucene.apache.org Subject: RE: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loadin

Re: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

And found another thing, even when I have this in my data-config.xml (a totally deformed XML file), I still get the same login failed error...where I would expect something like a non-well formed XML document error... Im using cygwin...dont know if that caches anything, but its still weird I thoug

Re: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

I just cant seem to get past this error! So perhaps if any of you are running on Windows with SQL Server 2008, maybe you could post your data-config? I could have a look at it so I at least know my data-config is configured correctly :) Thanks a bunch! -- View this message in context: http://lu

Re: min/max, StatsComponent, performance

: So one question is if there's any way to increase StatsComponent performance. : Does it use any caches, or does it operate without caches? My Solr is running I believe it uses the field cache to allow fast lookup of numeric values for documents as it iterates through teh document set -- there

Re: SpatialSearch: sorting by distance

: sort=dist(2,lat,lon,55.755786,37.617633) asc : : In general results are sorted, but some documents are not in right order. : I'm using DistanceUtils.getDistanceMi(...) from lucene spatial to calculate : real distance after reading documents from Solr. according ot the wiki for hte "dist" funct

Re: Problems running on tomcat

Hi Ahmet, Works with tomcat6. Tks! On Mon, Aug 2, 2010 at 3:04 PM, Claudio Devecchi wrote: > Hi Ahmet, > > I'm using tomcat7 with solr 1.4.1 =\ > If you worked fine on tomcat6 I'll try with the same version... > > Tks for helping.. > > > On Mon, Aug 2, 2010 at 2:30 PM, Ahmet Arslan wrote: > >>

Re: does this indicate a commit happened for every add?

: Subject: does this indicate a commit happened for every add? : In-Reply-To: : References: http://people.apache.org/~hossman/#threadhijack Thread Hijacking on Mailing Lists When starting a new discussion on a mailing list, please do not reply to an existing message, instead start a fresh ema

Re: Index compatibility 1.4 Vs 3.1 Trunk

: I am trying to use the solr code from ' : https://svn.apache.org/repos/asf/lucene/dev/trunk' as my design warrants use : of PolyType fields. My understanding is that the indexes are incompatible, : am I right ?. I have about a million docs in my index (indexed via solr : 1.4). Is re-index

RE: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

@Michael: your suggestion to place the jar file in that folder has brought me 1 step further. Now I get a new error. It seems as if the user cannot log in. Strange because it IS the correct pwd. In my MSSQL mgmt studio I provide: server name: (local) login: sa password:123456 Now if you look at m

Re: Phrase search

I'm using Solr 1.2, so I don't have splitOnNumerics. Reading that URL, is my use of catenateNumbers="1" causing this? Should I set it to "0" vs. "1" as I have it now? -M -Original Message- From: Markus Jelsma To: solr-user@lucene.apache.org Sent: Mon, Aug 2, 2010 3:54 pm Subject

RE: Re: Phrase search

Hi,   Queries on an analyzed field will need to be analyzed as well or it might not match. You can configure the WordDelimiterFilterFactory so it will not split into multiple tokens because of numerics, see the splitOnNumerics parameter [1].   [1]: http://wiki.apache.org/solr/AnalyzersTokeni

RE: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

I successfully used MSSQL JDBC by placing sqljdbc4.jar file in the lib directory, so e.g. example\lib\sqldbc4.jar. Apart from that, my dataconfig looks very similar - I also set the CLASSPATH, which didn't work. -Original Message- From: PeterKerk [mailto:vettepa...@hotmail.com] Sent: M

Re: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

Hi Gora, I just ran the classpath command in a DOS command prompt, that normally works for regular PATH variable as well. Your suggestion for the open source JTDS driver sounds good. So if you look at my data-config.xml: What would I have to place there under driver property? Also Im still

heads up -- index corruption on Solr/Lucene trunk/3.x branch

This issue: https://issues.apache.org/jira/browse/LUCENE-2574 which was committed 3 days ago (Friday Jul 30) can cause index corruption. I just committed a fix for the corruption, but if you've been using Solr/Lucene trunk or 3x branch updated after the first commit on Friday, and you built

Re: Phrase search

Thanks for the quick response. Which part of my WordDelimiterFilterFactory is changing "Apple 2" to "Apple2"? How do I fix it? Also, I'm really confused about this. I was under the impression a phrase search is not impacted by the analyzer, no? -M -Original Message- From: Marku

Re: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

On Mon, 2 Aug 2010 02:22:50 -0700 (PDT) PeterKerk wrote: > > > I'm running MSSQL Server 2008 > > I did this: set CLASSPATH= C:\Program Files\Microsoft SQL Server > JDBC Driver 3.0\sqljdbc_3.0\enu\sqljdbc4.jar (I dont know where I > can check if this has been executed correctly) Not familiar w

how to highlight string in jsp

Hello, I am trying to display the highlight string in different color on jsp. I use following in servlet. query.setHighlight(true).setHighlightSnippets(1); query.setParam("hl.fl", "Abstract"); I wonder how I can display it in jsp Thanks in advanced. xm

RE: Phrase search

Well, the WordDelimiterFilterFactory in your query analyzer clearly makes "Apple 2" out of "Apple2", that's what it's for. If you're looking for an exact match, use a string field. Check the output with the debugQuery=true parameter.   Cheers,   -Original message- From: johnmu...@aol.c

Phrase search

Hi All, I don't understand why i'm getting this behavior. I was under the impression if I search for "Apple 2" (with quotes and space before “2”) it will give me different results vs. if I search for "Apple2" (with quotes and no space before “2”), but I'm not! Why? Here is my fieldType s

Re: Problems running on tomcat

Hi Ahmet, I'm using tomcat7 with solr 1.4.1 =\ If you worked fine on tomcat6 I'll try with the same version... Tks for helping.. On Mon, Aug 2, 2010 at 2:30 PM, Ahmet Arslan wrote: > What is version of solr and tomcat? > > I think i saw same problem with tomcat 7 and solr 1.4.1 combination, th

Re: Problems running on tomcat

What is version of solr and tomcat? I think i saw same problem with tomcat 7 and solr 1.4.1 combination, thats why i am asking. I just tried to replicate this problem with tomcat 6 and solr 1.4.1, but everything went fine. --- On Fri, 7/30/10, Claudio Devecchi wrote: > From: Claudio Devecch

Re: Solr searching performance issues, using large documents

What would happen if the search query phrase spanned separate document chunks? Also, what would the optimal size of chunks be? Thanks! -Peter On Aug 1, 2010, at 7:21 PM, Lance Norskog wrote: > Not that I know of. > > The DataImportHandler has the ability to create multiple documents > from o

Re: Stress Test Solr

Tomas, This seems like a really useful tool. We're holding a Solr/Lucene conference in Boston, 7-8 October 2010 - and this would be an interesting lightning talk subject. Let me know if you need more info on the event. - Mike Bohlig, Lucid Imagination - Original Message From: T

Register now for Surge 2010

Registration for Surge Scalability Conference 2010 is open for all attendees! We have an awesome lineup of leaders from across the various communities that support highly scalable architectures, as well as the companies that implement them. Here's a small sampling from our list of speakers: John

Re: enhancing auto complete

Ok i'm still interested of the design -Original Message- From: Avlesh Singh To: solr-user@lucene.apache.org Sent: Mon, Aug 2, 2010 5:20 pm Subject: Re: enhancing auto complete Hahaha ... sorry its not. And there is no readymade code that I can give you either. But yes, if y

RE: Stress Test Solr

Very interersting. Could you add some information and link to the relevant wiki page [1] ?   [1]: http://wiki.apache.org/solr/BenchmarkingSolr   -Original message- From: Tomas Sent: Mon 02-08-2010 17:34 To: solr-user@lucene.apache.org; Subject: Stress Test Solr Hi All, we've been buil

Stress Test Solr

Hi All, we've been building an open source tool for load tests on Solr Installations. Thetool is called SolrMeter. It's on google code at http://code.google.com/p/solrmeter/. Here is some information about it: SolrMeter is an stress testing / performance benchmarking tool for Apache Solr instal

Index compatibility 1.4 Vs 3.1 Trunk

Hello, I am trying to use the solr code from ' https://svn.apache.org/repos/asf/lucene/dev/trunk' as my design warrants use of PolyType fields. My understanding is that the indexes are incompatible, am I right ?. I have about a million docs in my index (indexed via solr 1.4). Is re-indexing

Re: enhancing auto complete

Hahaha ... sorry its not. And there is no readymade code that I can give you either. But yes, if you liked it, I can share the design of this feature (solr, backend and frontend). Cheers Avlesh @avlesh | http://webklipper.com On Mon, Aug 2, 2010 at 8:47 PM, wrote: >

Re: enhancing auto complete

Hi, I'm also interested of this feature... is it open source? -Original Message- From: Avlesh Singh To: solr-user@lucene.apache.org Sent: Mon, Aug 2, 2010 5:09 pm Subject: Re: enhancing auto complete >From whatever I could read in your broken table of sample use cases, I thi

Re: enhancing auto complete

>From whatever I could read in your broken table of sample use cases, I think you are looking for something similar to what has been done here - http://askme.in; if this is what you are looking do let me know. Cheers Avlesh @avlesh | http://webklipper.com On Mon, Aug 2

enhancing auto complete

Hi, I'm looking for a solution related to auto complete feature for one application. Below is a list of texts from which auto complete results would be populated. Lorem ipsum dolor sit amet tincidunt ut laoreet dolore eu feugiat nulla facilisis at vero eros et te feugait nulla facilisi Clarita

Re: Quering the database

you should (as per the example) define the field as text in your solr-schema not in your RDB. something like: then search like: q=field_1:monitors the example schema illustrates a lot of the possibilities on how you to define fields and what is all means. Moreover have a look at: http://wiki.ap

RE: Quering the database

Thank you for your reply. Still the the problem persists even i tested with a simple example by defining a column of type text as varchar in database and in schema.xml used the default id which is set to string. Row is fetched and document created but searching doesn't give any results of the cont

RE: Quering the database

This question has come up several times over the past weeks. The cause is probably all your fields being of type "string". This is only good for exact matches like id's etc. Try using "text" or another type that tokenizes. -Original Message- From: Hando420 [mailto:hando...@gmail.com] Sen

RE: Rows fetch OK, Total Documents Failed??

Check your schema.xml; one of the fields is probable "Required," and it's not matching to a field extracted from DIH. Keep in mind that schema.xml is case-sensitive for names. -Original Message- From: scr...@asia.com [mailto:scr...@asia.com] Sent: Saturday, July 31, 2010 3:30 AM To: sol

Re: Quering the database

Thank you for your reply. Below is my data-config details. Below are the defined schema fields for the data-config field_1 text -- View this message in context: http://lucene.472066.n3.nabble.com/Querin

Re: Quering the database

On Mon, Aug 2, 2010 at 1:28 PM, Hando420 wrote: > > Hi, > > I am new to solr. I am indexing data from data using solr. Everything is > working fine the documents are indexed and using *:* as a query keyword i > am > able to get all the results from the table. My problem is now if i want to > quer

Quering the database

Hi, I am new to solr. I am indexing data from data using solr. Everything is working fine the documents are indexed and using *:* as a query keyword i am able to get all the results from the table. My problem is now if i want to query using a specific keyword such as monitors, it doesn't return a

RE: Boosting DisMax queries with !boost component

Jonathan Rochkind wrote: > >> qf needs to have spaces in it, unfortunately the local query parser can >> not >> deal with that, as Erik Hatcher mentioned some months ago. > > By "local query parser", you mean what I call the LocalParams stuff (for > lack of being sure of the proper term)? >

Re: SolrJ Response + JSON

Hi, as I promised, I want to give a feedback for transforming SolrJ's output into JSON with the package from json.org (the package was the json.org's one): I need to make a small modification to the package, since they store the JSON-key-value-pairs in a HashMap, I changed this to a LinkedHa

Re: Solr Indexing slows down

Thanks Otis, for this clarification! That means I will have to descrease the commit frequency to speed up indexing. How could I do this if I don't want to introduce an artificial delay time? ... via increasing the batch size? Today I have read in another thread[1] that one should univert the fiel

Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

I'm running MSSQL Server 2008 I did this: set CLASSPATH= C:\Program Files\Microsoft SQL Server JDBC Driver 3.0\sqljdbc_3.0\enu\sqljdbc4.jar (I dont know where I can check if this has been executed correctly) Then when approaching this URL: http://localhost:8983/solr/db/dataimport?command=full-i