Compiling SolrJ for Java 6

2015-11-03 Thread O. Olson
Hi, I'm looking to compile the SolrJ for Solr 4.10.3 for running on Java 6. (Due to choices beyond my control, we are on this older version of SolrJ and Java 6.) I'm looking for any pointers on how I could do it? I tried downloading the source from SVN (for Solr 4.10.3, not the latest version).

Re: Compiling SolrJ for Java 6

2015-11-03 Thread O. Olson
Thank you Erick. I'm sorry I did not clarify this in my original message. I'm compiling Solr (or SolrJ) under Java 7. I'm aware that it requires Java 7 to compile, and that's why I have not changed the "java.source" value in the common-build.xml file. SolrJ compiles fine. My problem is that I

Re: Compiling SolrJ for Java 6

2015-11-03 Thread O. Olson
Damm. I always thought cross compilation of Java worked (i.e. compile in one version with the target of a previous version). I guess it worked in my code because I did not use any of the new features. Thank you very much Shawn. No, I'm not running SolrCloud, but I wanted to use the new features

Re: Trying to get AnalyzingInfixSuggester to work in Solr?

2015-05-07 Thread O. Olson
Thank you Erick. I'm sorry I did not mention this earlier, but I am still on Solr 4.10.3. Once I upgrade to Solr 5.0+ , I would consider your suggestion in your blog post. O. O. Erick Erickson wrote Uh, you mean because I forgot to pate in the URL? Siih... Anyway, the URL is irrelevant

Re: Trying to get AnalyzingInfixSuggester to work in Solr?

2015-05-07 Thread O. Olson
Thank you Erick. I have no clue what you are referring to when you used to word this? Are you referring to my question in my original email/message? Erick Erickson wrote Have you seen this? I tried to make something end-to-end with assorted gotchas identified Best, Erick --

Re: Trying to get AnalyzingInfixSuggester to work in Solr?

2015-05-07 Thread O. Olson
Thank you Rajesh for your persistence. I now got it to work. In my original email/message, I mentioned that I use 'text_general' as defined in the examples: http://svn.apache.org/viewvc/lucene/dev/trunk/solr/example/example-DIH/solr/db/conf/schema.xml?view=markup I'm sorry I did not mention this

Re: Trying to get AnalyzingInfixSuggester to work in Solr?

2015-05-07 Thread O. Olson
Thank you Rajesh, Alessandro and Erick. I apparently did not have much knowledge about the Suggester - in fact I had no clue that there is a difference between the SpellcheckComponent and the SuggestComponent. I would be reading about this, esp. Erick blog post on Lucidworks. O. O. Rajesh

Trying to get AnalyzingInfixSuggester to work in Solr?

2015-05-06 Thread O. Olson
I'm trying to get the AnalyzingInfixSuggester to work but I'm not successful. I'd be grateful if someone can point me to a working example. Problem: My content is product descriptions similar to a BestBuy or NewEgg catalog. My problem is that I'm getting only single words in the suggester

Re: Trying to get AnalyzingInfixSuggester to work in Solr?

2015-05-06 Thread O. Olson
Thank you Rajesh. I think I got a bit of help from the answer at: http://stackoverflow.com/a/29743945 While that example sort of worked for me, I'm not had the time to test what works and what didn't. So far I have found that I need the the field in my searchComponent to be of type 'string'. In

Re: Trying to get AnalyzingInfixSuggester to work in Solr?

2015-05-06 Thread O. Olson
Thank you Rajesh for responding so quickly. I tried it again with a restart and a reimport and I still cannot get this to work i.e. I'm seeing no difference. I'm wondering how you define: 'textSuggest' in your schema? In my case I use the field 'text' that is defined as: field name=text

Re: Trying to get AnalyzingInfixSuggester to work in Solr?

2015-05-06 Thread O. Olson
Thank you Rajesh. I'm not familiar with the queryConverter. How do you wire it up to the rest of the setup? Right now, I just put it between the SpellCheckComponent and the RequestHandler i.e. my config is as: searchComponent class=solr.SpellCheckComponent name=suggest lst

Re: Negative Boosting documents with a certain word

2015-05-02 Thread O. Olson
Thank you very much Chris. I'm sorry I could not get back to you because I did not have the time to try this. If I change my query from q=laptops to q=laptops%20(*:*%20-Refurbished)^10%20(*:*%20-Recertified)^10 I get exactly what I want! Thank you!! Is there anyway to

Negative Boosting documents with a certain word

2015-04-30 Thread O. Olson
Hi, My Solr documents contain descriptions of products, similar to a BestBuy or a NewEgg catalog. I'm wondering if it were possible to push a product down the ranking if it contains a certain word. By this I mean it would still appear in the search results. However, instead of appearing

Integrating Solr with an existing web application - and SolrJ

2015-04-27 Thread O. Olson
I can get the standard Solr example to run within Jetty and I can use it through the velocity templates. I'm now thinking of integrating Solr with a couple of existing websites. In this regard, I have the following questions: 1. For a medium sized website (about 100+ concurrent users), what is

Re: Integrating Solr with an existing web application - and SolrJ

2015-04-27 Thread O. Olson
Thank you very much Doug. I was thinking of putting Solr on a separate server, but I did not expect you to so strongly recommend Jetty. I think I would stick to the embedded Jetty, because I don't need the security. I'm using Solr 4.10.3 at the moment, so I'm not familiar with Solr 5. Thanks

Re: Checkout the source Code to the Release Version of Solr?

2015-02-17 Thread O. Olson
Thank you Mike. This is what I was looking for. I apparently did not understand what tags where. Mike Drob wrote The SVN source is under tags, not branches. http://svn.apache.org/repos/asf/lucene/dev/tags/lucene_solr_4_10_3/ -- View this message in context:

Re: Checkout the source Code to the Release Version of Solr?

2015-02-17 Thread O. Olson
Thank you Hrishikesh. Funny how GitHub is not mentioned on http://lucene.apache.org/solr/resources.html I think common-build.xml is what I was looking for. Thank you Hrishikesh Gadre-3 wrote Also the version number is encoded (at least) in the build file

Re: Checkout the source Code to the Release Version of Solr?

2015-02-17 Thread O. Olson
Thank you Shawn. I have not updated my version in a while, so I prefer to do it to 4.10 first, rather than go directly to 5.0. I'd be working on it towards the end of this week. -- View this message in context:

Checkout the source Code to the Release Version of Solr?

2015-02-17 Thread O. Olson
At this time the latest released version of Solr is 4.10.3. Is there anyway we can get the source code for this release version? I tried to checkout the Solr code from http://svn.apache.org/repos/asf/lucene/dev/branches/lucene_solr_4_10/ In the commit log, I see a number of revisions but nothing

Detect ongoing Solr Import and its Completion

2015-02-05 Thread O. Olson
My setup is fairly similar to the examples. I start a Solr Import using the UI i.e. I go to: http://localhost:8983/solr/#/corename/dataimport//dataimport and click the Execute button to start the Import. First, I'm curious if there is a way of figuring out if there is an import running. I

Re: Detect ongoing Solr Import and its Completion

2015-02-05 Thread O. Olson
Thank you very much Alvaro and Shawn. The DataImport Status command was what I was looking for. I have tried it a bit, and I feel the output is good enough for me. Thanks again Alvaro Cabrerizo wrote Maybe you are asking for the status command. Currently this is the url I invoke for checking

Re: Where can we set the parameters in Solr Config?

2015-02-04 Thread O. Olson
Thank you Alex and Jack for pointing out solrcore.properties and core.properties files. This is much better than specifying these on the command line. I think I need to use the solrcore.properties. I will try it in the next few days. Thanks again. Alexandre Rafalovitch wrote core.properties?

Where can we set the parameters in Solr Config?

2015-02-03 Thread O. Olson
I'm sorry if this is a basic question, but I am curious where, or at least, how can we set the parameters in the solrconfig.xml. E.g. Consider the solrconfig.xml shown here:

Re: Where can we set the parameters in Solr Config?

2015-02-03 Thread O. Olson
Thank you Jim. I was hoping if there is an alternative to putting the parameters on the command line, which would be a pain if there are more than a few parameters i.e. like a config file for example. Thanks again Jim.Musil wrote We set them as extra parameters sent to to the servlet (jetty or

Solr Suggester Autocomplete Working Example

2015-02-02 Thread O. Olson
Hi, I'm am wondering if anyone can point me to a website that user Solr's Suggester or Autocomplete or whatever you call it. I am looking for something that is closer to the default provided in the examples, but is also used commercially. I have a local Solr installation that is

Re: Solr Suggester Autocomplete Working Example

2015-02-02 Thread O. Olson
Thank you Michael. I will look at safaribooksonline.com later today when I create my account. I am not sure how to use AnalyzingInfixSuggester. I googled a bit, and I can find the source code, but not how to use it. You are perfectly correct when you say that I am using a field also used for

Re: Solr Suggester Autocomplete Working Example

2015-02-02 Thread O. Olson
Alexandre Rafalovitch wrote Actually, you have a capability to do unbelievable level of customization in Solr, starting from schema definition and down to writing custom components in Java. Or even completely rebuilding Solr the way you want from sources. Or was that a reference to your

Re: Is there a problem with -Infinity as boost?

2014-10-21 Thread O. Olson
://observer.wunderwood.org/ On Oct 20, 2014, at 3:04 PM, O. Olson lt; olson_ord@ gt; wrote: I am considering using a boost as follows: boost=log(qty) Where qty is the quantity in stock of a given product i.e. qty could be 0, 1, 2, 3, … etc. The problem I see is that log(0) is -Infinity. Would

Is there a problem with -Infinity as boost?

2014-10-20 Thread O. Olson
I am considering using a boost as follows: boost=log(qty) Where qty is the quantity in stock of a given product i.e. qty could be 0, 1, 2, 3, … etc. The problem I see is that log(0) is -Infinity. Would this be a problem for Solr? For me it is not a problem because log(0) log(1) log(2) etc.

Re: Setting of Default Boost in Edismax Search Handler

2014-09-26 Thread O. Olson
I'm grateful to elyograg and erikhatcher on the #solr IRC for helping me with this question. They first pointed me to the Edismax documentation's boost parameter at http://wiki.apache.org/solr/ExtendedDisMax#bf_.28Boost_Function.2C_additive.29 and asked me to put the following in my solrconfig.xml

Setting of Default Boost in Edismax Search Handler

2014-09-25 Thread O. Olson
I have a setup very similar to the /browse handler in the example (http://svn.apache.org/viewvc/lucene/dev/trunk/solr/example/example-DIH/solr/db/conf/solrconfig.xml?view=markup) I am curious if it is possible to set a default boost function (e.g. bf=log(qty)) , so that all query results would

Re: Solr Boosting Unique Values

2014-09-23 Thread O. Olson
Thank you Erick for your prompt response. I'm sorry I could not get back to you earlier. My current setup does not use the ImageUrl field for the search (more specifically as the default search field). The ImageUrl field contains a URL to the image which is for most part a GUID, which is

Solr Boosting Unique Values

2014-09-22 Thread O. Olson
I use Solr to index some products that have an ImageUrl field. Obviously some of the images are duplicates. I would like to boost the rankings of products that have unique images (i.e. more specifically, unique ImageUrl field values, because I don't deal with the image binary). By this I mean,

Boost based on match in separate field

2014-09-11 Thread O. Olson
I have an index of books in Solr. I copy all the fields to a field called text and search on it i.e. in my schema.xml I have: copyField source=* dest=text/ Then in my solrconfig.xml (similar to the velocity example in example\example-DIH\solr\db) I use the edismax

Re: CopyField Wildcard Exception possible?

2014-08-30 Thread O. Olson
Thank you Ahmet. I am not familiar with using the ScriptUpdateProcessor, but I would look into it. I am also not sure how bad this would be on the import performance. O. O. -- View this message in context:

Re: CopyField Wildcard Exception possible?

2014-08-29 Thread O. Olson
Thank you Joe. I am not familiar with creating a JIRA ticket. I was however hoping that there might be a solution to this. If there is none, then I would consider explicitly specifying the fields. O. O. -- View this message in context:

CopyField Wildcard Exception possible?

2014-08-28 Thread O. Olson
I have hundreds of fields of the form in my schema.xml: field name=F10434 type=string indexed=true stored=true multiValued=true/ field name=B20215 type=string indexed=true stored=true multiValued=true/ . I also have a field 'text' that is set as the Default Search Field

Re: Understanding the Debug explanations for Query Result Scoring/Ranking

2014-07-28 Thread O. Olson
Thank you very much Chris. I was not aware of debug.explain.structured. It seems to be what I was looking for. Thanks also to Jack Krupansky. Yes, delving into those numbers would be my next step, but I will get to that later. O. O. Chris Hostetter-3 wrote Just to be clear, regardless of

Re: Understanding the Debug explanations for Query Result Scoring/Ranking

2014-07-25 Thread O. Olson
Thank you Uwe. Unfortunately, I could not get your explain solr website to work. I always get an error saying Ops. We have internal server error. This event was logged. We will try fix this soon. We are sorry for inconvenience. At this point, I know that I need to have some technical background

Re: Understanding the Debug explanations for Query Result Scoring/Ranking

2014-07-25 Thread O. Olson
Thank you very much Erik. This is exactly what I was looking for. While at the moment I have no clue about these numbers, they ruby formatting makes it much more easier to understand. Thanks to you Koji. I'm sorry I did not acknowledge you before. I think Erik's solution is what I was looking

Understanding the Debug explanations for Query Result Scoring/Ranking

2014-07-24 Thread O. Olson
Hi, If you add /*debug=true*/ to the Solr request /(and wt=xml if your current output is not XML)/, you would get a node in the resulting XML that is named debug. There is a child node to this called explain to this which has a list showing why the results are ranked in a particular

Re: Debug different Results from different Request Handlers

2014-06-18 Thread O. Olson
Thank you Erik (and to steffkes who helped me on the IRC #Solr Chat). Sorry for the delay in responding, but I got this to work. Your suggestion about adding debug=true to the query helped me. Since I was adding this to the Velocity request handler, I could not see the debug results,

Re: Debug different Results from different Request Handlers

2014-06-14 Thread O. Olson
Thank you Erik. I tried /products?q=hp|lyncwt=xml and I show no results i.e. numFound=0, so I think there is something wrong. You are correct, that the VRW is not the problem but the Query Parser. Could you please let me know how to determine the query parser? For most part I have not changed

Debug different Results from different Request Handlers

2014-06-13 Thread O. Olson
Hi, In my solrcofig.xml I have one Request Handler displaying the results using Apache Velocity:    requestHandler name=/products class=solr.SearchHandler And another with regular XML: requestHandler name=/search class=org.apache.solr.handler.component.SearchHandler I am seeing different

DataImport using SqlEntityProcessor running Out of Memory

2014-05-11 Thread O. Olson
I have a Data Schema which is Hierarchical i.e. I have an Entity and a number of attributes. For a small subset of the Data - about 300 MB, I can do the import with 3 GB memory. Now with the entire 4 GB Dataset, I find I cannot do the import with 9 GB of memory. I am using the SqlEntityProcessor

Re: Change Velocity Template Directory in Solr 4.6

2013-12-12 Thread O. Olson
Thank you very much for the confirmation iorixxx. When I started this thread on Dec. 6, I did not know about the confluence wiki (https://cwiki.apache.org/confluence/display/solr/Apache+Solr+Reference+Guide). I learned about it through another thread I started

Re: Change Velocity Template Directory in Solr 4.6

2013-12-11 Thread O. Olson
Thank you iorixxx. Yes, when I run: java -Dsolr.allow.unsafe.resourceloading=true -jar start.jar And I then load the root of my site, I get: ERROR - 2013-12-11 14:36:03.434; org.apache.solr.common.SolrException; null:java.io.IOException: Unable to find resource 'browse.vm' at

Re: Use of Deprecated Classes: SortableIntField SortableFloatField SortableDoubleField

2013-12-10 Thread O. Olson
Thank you kydryavtsev andrey. Wow this reference guide at https://cwiki.apache.org/confluence/display/solr/Apache+Solr+Reference+Guid is a lot more detailed than the official Solr Wiki at http://wiki.apache.org/solr/. May be those responsible for Solr should link to it. Thank you for confirming

Re: Change Velocity Template Directory in Solr 4.6

2013-12-10 Thread O. Olson
Hi, Does anyone have a clue regarding this? Or would this question be more appropriate on the Solr-Dev? After posting this I realized that the template directory needs to be named velocity even if you place it under /core/conf/. This seems to be too restrictive. O. O. -- View this message

Replacing Deprecated CachedSqlEntityProcessor with SqlEntityProcessor with a cacheImpl parameter

2013-12-10 Thread O. Olson
Hi,       I am looking to replace the Deprecated CachedSqlEntityProcessor with SqlEntityProcessor with a cacheImpl parameter but I cannot find documentation.    The Deprecated note at the top of

Use of Deprecated Classes: SortableIntField SortableFloatField SortableDoubleField

2013-12-09 Thread O. Olson
Use of Deprecated Classes: SortableIntField SortableFloatField SortableDoubleField   I am attempting to migrate from Solr 4.3 to Solr 4.6. When I run the example in 4.6, I get warnings SortableIntField etc. asking me to consult the documentation to replace them accordingly.   If these classes

Re: Use of Deprecated Classes: SortableIntField SortableFloatField SortableDoubleField

2013-12-09 Thread O. Olson
Thank you kydryavtsev andrey. Could you please suggest some examples. There is no documentation on this. Also is there a reason why these classes are not used in the examples even though they are deprecated? I am looking for examples like below: Should I put the following in my schema.xml file to

Change Velocity Template Directory in Solr 4.6

2013-12-06 Thread O. Olson
I would like to know how to set the Velocity Template Directory in Solr.   About 6 months ago I asked this question on this list: http://lucene.472066.n3.nabble.com/Change-Velocity-Template-Directory-td4078120.html  At that time Erik Hatcher advised me to use the v.base_dir in solrconfig.xml.

Re: Customize Velocity Output, Utility Class or Custom Tool

2013-08-05 Thread O. Olson
Thank you very much *Erik*. At this point I have trouble compiling Solr /(I needed help from the IRC)/, so I am not qualified to submit a patch. However, now I know where this location is, I might consider creating my own tool and putting it in there :-). Thanks again, because I don’t think

Re: Customize Velocity Output, Utility Class or Custom Tool

2013-08-02 Thread O. Olson
Would this question be more appropriate on Solr-Dev? Thank you in advance, O. O. O. Olson wrote Hi, I am using Solr with the VelocityResponseWriter. http://wiki.apache.org/solr/VelocityResponseWriter I am wondering if there is anyway to add my own Utility Class i.e. how do I put

Customize Velocity Output, Utility Class or Custom Tool

2013-08-01 Thread O. Olson
Hi, I am using Solr with the VelocityResponseWriter. http://wiki.apache.org/solr/VelocityResponseWriter I am wondering if there is anyway to add my own Utility Class i.e. how do I put it in the Velocity Context. Or as an alternative to add my own Custom Tool? By the way, where is

Velocity Example: Where is #url_for_home defined?

2013-07-15 Thread O. Olson
I am new to using Velocity esp. with Solr. In the Velocity example provided, I am curious where #url_for_home is set i.e. its value assigned? (It is used a lot in the macros defined in VM_global_library.vm.) Thank you in advance, O. O. -- View this message in context:

Change Velocity Template Directory

2013-07-15 Thread O. Olson
Is there any way to change the default Velocity directory where the Velocity templates are stored? In the example download, I modified the solrconfig.xml under the Solr Request Handler to add: str name=v.base_dirconf/mycustom//str I have a mycustom directory under the conf directory for the

Re: Velocity Example: Where is #url_for_home defined?

2013-07-15 Thread O. Olson
Thank you very much Erik. That’s exactly what I was looking for. I can swear I looked into VM_global_library.vm. I'm not sure how I missed it :-( O. O. Erik Hatcher-4 wrote #url_for_home is defined in conf/velocity/VM_global_library.vm. Note that it builds upon #url_root defined just above

Re: Change Velocity Template Directory

2013-07-15 Thread O. Olson
Thank you Erik. I did not think the Windows file/directory path format would work for Solr. For others the following worked for me: str name=v.base_dirC:\Users\MyUsername\Solr\example\example-DIH\solr\db\conf\mycustom\/str Erik Hatcher-4 wrote Try supplying an absolute path. I'm away from my

Re: Debugging Solr XSL

2013-06-14 Thread O. Olson
Thank you Upayavira Miguel. I decided to use Visual Studio – since I can at least set breakpoints and do interactive debugging in the UI. I hope the way Visual Studio treats XSL is the same as Solr - else I would have problems :-). Thanks again, O.O. -- View this message in context:

Debugging Solr XSL

2013-06-13 Thread O. Olson
Hi, I am attempting to transform the XML output of Solr using the XsltResponseWriter http://wiki.apache.org/solr/XsltResponseWriter to HTML. This works, but I am wondering if there is a way for me to debug my creation of XSL. If there is any problem in the XSL you simply get a stack trace

Curious why Solr Jetty URL has a # sign?

2013-06-10 Thread O. Olson
Hi, This may be a dumb question but I am curious why the sample Solr Jetty results in a URL with a # sign e.g. http://localhost:8983/solr/#/~logging ? Is there any way to get rid of it, so I could have something like: http://localhost:8983/solr/~logging ? Thank you, O. O. -- View

Re: Curious why Solr Jetty URL has a # sign?

2013-06-10 Thread O. Olson
Thank you Chris. No, I do not have an XY Problem. I am new to Solr, Jetty and related technology and was playing. I did not like the /#/ in the URL and felt that it had no purpose. So, if I understand this correctly is Solr using the # as a JQuery hook to decide which view to show? Am I

Re: Curious why Solr Jetty URL has a # sign?

2013-06-10 Thread O. Olson
Thank you Alex for the explanation. I was not aware of single page application design. After a bit of google, it seems to be more popular than I expected. O. O. Alexandre Rafalovitch wrote The # part is JavaScript URL. It is not seen by the server. It is part of a standard

No files added to classloader from lib

2013-06-05 Thread O. Olson
Hi, I downloaded Solr 4.3 and I am attempting to run and configure a separate Solr instance under Jetty. I copied the Solr dist directory contents to a directory called solrDist under the single core db that I was running. I then attempted to get the DataImportHandler using the following

Re: No files added to classloader from lib

2013-06-05 Thread O. Olson
Good call Jack. I totally missed that. I am curious how dataimport handler worked before – if I made a mistake in the specification and it did not get the jar. Anyway, it works now. Thanks again. O.O. apache-solr-dataimporthandler-.*\.jar - note that the apache- prefix has been removed from

Re: Warning: no uniqueKey specified in schema.

2013-05-24 Thread O. Olson
Thank you Shawn for clearing this up. I was only using the “db” core, and forgot that this example had a few other cores which have their own schema.xml. I commented out this core in the solr.xml and now get no warnings :-). O. O. -- View this message in context:

Warning: no uniqueKey specified in schema.

2013-05-23 Thread O. Olson
Hi, I just downloaded Apache Solr 4.3.0 from http://lucene.apache.org/solr/. I then got into the /example directory and started Solr with: java -Djava.util.logging.config.file=etc/logging.properties -Dsolr.solr.home=./example-DIH/solr/ -jar start.jar I have not made any changes at

RE: How do I use CachedSqlEntityProcessor?

2013-05-22 Thread O. Olson
Thank you bbarani. Unfortunately, this does not work. I do not get any exception, and the documents import OK. However there is no Category1, Category2 … etc. when I retrieve the documents. I don’t think I am using the Alpha or Beta of 4.0. I think I downloaded the plain vanilla release version.

RE: How do I use CachedSqlEntityProcessor?

2013-05-22 Thread O. Olson
Thank you very much James. Your suggestion worked exactly! I am curious why I did not get any errors before. For others, the following worked for me: entity name=Cat1 query=SELECT CategoryName, SKU from CAT_TABLE WHERE CategoryLevel=1 cacheKey=SKU cacheLookup=Product.SKU

RE: How do I use CachedSqlEntityProcessor?

2013-05-22 Thread O. Olson
Thank you guys, particularly James, very much. I just imported 200K documents in a little more than 2 mins – which is great for me :-). Thank you Stefan. I did not realize that it was not a syntax error and hence no error. Thank you for clearing that up. O. O. -- View this message in context:

RE: Speed up import of Hierarchical Data

2013-05-22 Thread O. Olson
Just an update for others reading this thread: I had some CachedSqlEntityProcessor and had it addressed in the thread How do I use CachedSqlEntityProcessor? (http://lucene.472066.n3.nabble.com/How-do-I-use-CachedSqlEntityProcessor-td4064919.html) I basically had to declare the child entities in

How do I use CachedSqlEntityProcessor?

2013-05-21 Thread O. Olson
I am using the DataImportHandler to Query a SQL Server and populate Solr with data that has hierarchical relationships. The following is an outline of my table structure: PROD_TABLE - SKU (Primary Key) - Title (varchar) - Descr (varchar) CAT_TABLE - SKU (Foreign Key) - CategoryLevel

RE: How do I use CachedSqlEntityProcessor?

2013-05-21 Thread O. Olson
Thank you James bbarani. This worked in the sense that there was no error or exception in the data import. Unfortunately, I do not see any of my Category1, Category2 etc. when I retrieve the documents. If I use the first configuration of the db-data-config.xml posted in my original post, I see

RE: Speed up import of Hierarchical Data

2013-05-17 Thread O. Olson
Thank you James. I think I got this to work using CachedSqlEntityProcessor – and it seems extremely fast. I will try SortedMapBackedCache on Monday :-). Thank you, O. O. Dyer, James-2 wrote Using SqlEntityProcessor with cacheImpl=SortedMapBackedCache is the same as specifying

Speed up import of Hierarchical Data

2013-05-16 Thread O. Olson
I am using the DataImportHandler to Query a SQL Server and populate Solr. Unfortunately, SQL does not have an understanding of hierarchical relationships, and hence I use Table Joins. The following is an outline of my table structure: PROD_TABLE - SKU (Primary Key) - Title (varchar) - Descr

Re: Speed up import of Hierarchical Data

2013-05-16 Thread O. Olson
Thank you Stefan. I am new to Solr and I would need to read up more on CachedSqlEntityProcessor. Do you have any clue where to begin? There do not seem to be any tutorials online. The link you provided seems to have a very short and unclear explanation. After “Example 1” you have “The usage is

RE: Speed up import of Hierarchical Data

2013-05-16 Thread O. Olson
Thank you James. Are there any examples of SortedMapBackedCache? I am new to Solr and I do not find many tutorials in this regard. I just modified the examples and they worked for me. What is a good way to learn these basics? O. O. Dyer, James-2 wrote See

Solr Data Config Queries per Field

2013-01-29 Thread O. Olson
Hi, I am new to Solr, and I am using the DataImportHandler to Query a SQL Server and populate Solr. I specify the SQL Query in the db-data-config.xml file. Each SQL Query seems to be associated with an entity. Is it possible to have a query per field? I think it would be easier to explain

Re: Solr Data Config Queries per Field

2013-01-29 Thread O. Olson
Gora Mohanty-3 wrote On 29 January 2013 22:42, O. Olson lt; olson_ord@ gt; wrote: [...] SQL Database Schema: Table: Prod_Table Column 1: SKU - ID/Primary Key Column 2: Title Table: Cat_Table Column 1: SKU - Foreign Key Column 2: CategoryLevel Column 3: CategoryName Where

Re: Solr Data Config Queries per Field

2013-01-29 Thread O. Olson
Gora Mohanty-3 wrote Yes, things should function as you describe, and no you should not need any change in your schema from changing the DIH configuration file. Please take a look at http://wiki.apache.org/solr/SolrFacetingOverview#Facet_Indexing for how best to define faceting fields. Also,

RE: Solr Faceting with Name Values

2013-01-29 Thread O. Olson
Thank you Robi for the information. I will be looking into this esp. the implementation. Having to join the names together and then split them later is something I have to discuss with my team. O. O. Petersen, Robert wrote Hi O.O 1. Yes faceting on field function_s would return all the

Solr Faceting with Name Values

2013-01-28 Thread O. Olson
Hi, We are looking at putting our Product Catalog into Solr. Our Product Catalog involves a Product, and a number of [Name, Value] pairs – which represent attributes of a particular product. The attribute names are standard along a certain Product Category, but they are too numerous to

RE: Solr Faceting with Name Values

2013-01-28 Thread O. Olson
Thank you Robi. Your idea seems good but I have a few questions: 1. From your description, I would create a field “Function_s” with the value “Scanner” and “Function_s” with the value “Printer” for my two Products. This seems good. Is it possible for you give me a query for this dynamic

Re: Solr SQL Express Integrated Security - Unable to execute query

2013-01-24 Thread O. Olson
Shawn Heisey-4 wrote There will be a lot more detail to this error. This detail may have a clue about what happened. Can you include the entire stacktrace? Thanks, Shawn Thank you Shawn. The following is the entire stacktrace. I hope this helps: INFO: Creating a connection for entity

Re: Solr SQL Express Integrated Security - Unable to execute query

2013-01-24 Thread O. Olson
Michael Della Bitta-2 wrote On Thu, Jan 24, 2013 at 11:34 AM, O. Olson lt; olson_ord@ gt; wrote: Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The server SQLEXPRESS is not configured to listen with TCP/IP. That's probably your problem... Michael Della Bitta

Solr SQL Express Integrated Security - Unable to execute query

2013-01-23 Thread O. Olson
Hi, I am using the /example-DIH in the Solr 4.0 download. The example worked out of the box using the HSQLDB. I then attempted to modify the files to connect to a SQL Express instance running on my local machine. A http://localhost:8983/solr/db/dataimport?command=full-import results in

Re: Delete all Documents in the Example (Solr 4.0)

2013-01-22 Thread O. Olson
Thank you Erick for that great tip on getting a listing of the Cores. O. O. -- View this message in context: http://lucene.472066.n3.nabble.com/Delete-all-Documents-in-the-Example-Solr-4-0-tp4035156p4035454.html Sent from the Solr - User mailing list archive at Nabble.com.

Enable Logging in the Example App

2013-01-21 Thread O. Olson
Hi,       I am really new to Solr, and I have never used anything similar to it before. So please pardon my ignorance. I downloaded  Solr 4.0 from http://lucene.apache.org/solr/downloads.html and start it using the commandline:   java -jar start.jar    This generates a number of INFO

Delete all Documents in the Example (Solr 4.0)

2013-01-21 Thread O. Olson
Hi,       I am attempting to use the example-DIH that comes with the Solr 4.0 download. In /example, I start Solr using:   java -Dsolr.solr.home=./example-DIH/solr/ -jar start.jar   After playing with it for a while, I decided to delete all documents in the index. The FAQ at

Re: Delete all Documents in the Example (Solr 4.0)

2013-01-21 Thread O. Olson
- Messaggio originale - Da: Shawn Heisey s...@elyograg.org A: solr-user@lucene.apache.org Cc: Inviato: Lunedì 21 Gennaio 2013 12:35 Oggetto: Re: Delete all Documents in the Example (Solr 4.0) On 1/21/2013 11:27 AM, O. Olson wrote: http://localhost:8983/solr/update and I got a 404

Re: Enable Logging in the Example App

2013-01-21 Thread O. Olson
Thank you Ahmet. This worked perfectly. O. O. - Messaggio originale - Da: Ahmet Arslan iori...@yahoo.com A: solr-user@lucene.apache.org; O. Olson olson_...@yahoo.it Cc: Inviato: Lunedì 21 Gennaio 2013 15:44 Oggetto: Re: Enable Logging in the Example App Hi Olson, java

Question on Solr Velocity Example

2013-01-18 Thread O. Olson
Hi,       I am new to Solr (and Velocity), and have downloaded Solr 4.0 from http://lucene.apache.org/solr/downloads.html. I started the example solr, and indexed the XML files in the /exampledocs directory. Next, I pointed the browser to: http://localhost:8983/solr/browse and I get the

Re: Question on Solr Velocity Example

2013-01-18 Thread O. Olson
- Messaggio originale - Da: Erik Hatcher erik.hatc...@gmail.com A: solr-user@lucene.apache.org; O. Olson olson_...@yahoo.it Cc: Inviato: Venerdì 18 Gennaio 2013 15:20 Oggetto: Re: Question on Solr Velocity Example Great question.  $response is as described here http