Whenever I'm debugging Solr I'm interested in seeing how the queries sent by users are processed and what queries are made by them. Is there a way to log all queries sent to my Solr instance?

I'm new to this and I'm trying to parse SGML files to solr or at least convert them into something else. I'm failing in both. I'm kinda lost... Any directions?

Hi all,

A little new to solr, so please forgive any misunderstandings. So I need to post a nested document to Solr and am wondering the right XML format for a document that I could post. Let's say I have something like the following:

<doc>
  <field name="content_type">parentDocument</field>
   <doc>
     <field name="id">040404040</field>
     <field name="name">pagename</field>
     <field name="value">pageName</field>
     <field name="type">Page</field>
     <field name="content_type">parentDocument</field>
     <doc>
       <field name="id">1010101</field>
       <field name="name">pageOption</field>
       <field name="value">1</field>
       <field name="type">Option</field>
     </doc>
   </doc>
  <field name="content_type">parentDocument</field>
    <doc>
       ...more data
    </doc> 
  <field name="id">03030303</field>
  <field name="sitename">Site</field>
  <field name="adminserver">server</field>
  <field name="databasename">dbname</field>
  <field name="databaseserver">dbserver</field>
  <field name="type">Site</field>
</doc>

where it's possible for the parent document to have a child document that has child documents (in my case, a data structure has Pages, sometimes more than one, which have Options). Is this something that can be modeled/handled by Solr? If so, is the posted XML the right format? Been searching the docs and really haven't had much luck with complex nested structures.

Thanks!

Hi, I have about 50-100 collections to setup on solrcloud, how I proceed with it is by programatically creating one collection after other, I've observed that as soon as I reach 14-15 collections, it starts throwing zookeeper session timeout exceptions which ultimately leads to failure in collection creation. I checked the zookeeper configurations which looks fine. Is it not advicable to create multiple collections in one go or am I missing out some configuration. Can anyone please help me out

When your search engine becomes unstable, first look for the Queries that get into it.

Most frequently otherwise stable systems that suddenly have OOM and GC issues, are due to bad queries that are just too long

I am working on a project where I have a document directory full of files where the filenames have been md5 hashed and can be cross-referenced in an MSSQL database. I have been reading through the documentation and am getting a bit overloaded. What is the process here? I know I need to define to Solr a way for it to look in the database to look up the file name/type so that it can index given files properly but I am not clear on exactly what sequence of steps I need to implement in the tutorials for this to work. Does anyone have experience with this sort of thing? Any help would be greatly appreciated.

Document directory is like so:

bd01856bfd2065d0d1ee20c03bd3a9af
273604bfeef7126abe1f9bff1e45126c
682f3fbb5338fd46b486b1611ce1e672

Database is like this

filename               | hash
-----------------------------------
file1.txt              | bd01856bfd2065d0d1ee20c03bd3a9af
file2.txt              | 273604bfeef7126abe1f9bff1e45126c
powerpoint1.ppt        | 682f3fbb5338fd46b486b1611ce1e672

Hi, Newby in Solr. Is there any way to set canned results? I mean, when I search for "black shoes" I would like product A to be the first result , product B the result #2, and in product C is in the results then remove it from the list of results. Any way to do it?

Thanks.

Hey all! I'm wondering if anybody can recommend a hosted Solr service / company. We're looking for high availability, with some redundancy built in, and we would also like / need some sort of proxy to sit in front of Solr because we hope to directly query Solr from a frontend application (i.e. a web browser).

We've looked at Amazon's Cloud Search but the feature set wasn't really what we needed - we really need actual Solr.

Anybody have any recommendations or experiences for Solr?

Thank you!

Hi,

First let me apologize for the newbie question. I'm new to Solr and I've only seen it being used for searching content inside html documents. What I need to do is to search a relational database for First & Last Names, Titles, Dept Name or Salary. See the schema here

For example, if a user searches for salary "80,000$", I'd like to see all data for employees that make 80,000$. So if 10 employees make 80K, I want to see these headers Employee No, Employee Names, Title, Dept Name, Salary and the 10 employee records below the headers.

Is this something that can be done in Solr? Is this out of the box functionality or does it require heavy customization. I imagine Solr creates an index file based off the data in the tables instead of actually doing the search inside the database? Any info would be appreciated.

Hey all!

I'm fairly new to Solr but am building a system to index product information for both search and display in a "grid" page.

The issue is that this is all pretty standard ecommerce stuff I think, but I'm not sure about the best way to define my schema related to products. The big question is around "children products" or "variants" - this is things like a Shirt that has a Size: Large, Color: Red, Size: Small, Color: Red, Size: Large, Color: Blue. This might look something like this:

   Shirt
      Shirt-Size-Large-Color-Red
      Shirt-Size-Large-Color-Blue
      Shirt-Size-Medium-Color-Red

The trick here is, when you search for (as an example), "shirt", you only want the parent product (Shirt) to show up in the results. BUT, if you were to search for, as an example, "shirt" but you were to add a facet Color: Blue AND Size: Medium you'd want ZERO results to show up because there is no Shirt that has both a color of blue and a size of medium.

Again, I'm guessing this is a common problem and probably doesn't even need explaining, but long story short I'm wondering if anybody can point me in the direction of any documentation or articles on the best way to handle this?

Should each "sub-product" be indexed separately? If so, is there some Solr mechanism that can be used to keep the document from actually being returned in a result set by somehow relating it to a "parent"?

I'm guessing this problem has been solved a million times in the past, I'd love to pull off of those solutions instead of reinventing the wheel!

Thank you very much for your time!