Order by an expression in Solr

2013-07-20 Thread cmd.ares
In SQL you can order by an expression like: SELECT * FROM TABLE1 ORDER BY ( CASE WHEN COL1 BETWEEN ${PARAM1} - 10 AND ${PARAM1} + 10 AND COL2=${PARAM2} THEN 1 WHEN COL1 BETWEEN ${PARAM1} - 10 AND ${PARAM1} + 10 AND COL3=${PARAM2} THEN 2 WHEN COL1 - COL3=${PARAM3} THEN 3

Re: dataimporter, custom fields and parsing error

2013-07-20 Thread Andreas Owen
they are in my schema, path is typed correctly the others are default fields which already exist. all the other fields are populated and i can search for them, just path and text aren't. On 19. Jul 2013, at 6:16 PM, Alexandre Rafalovitch wrote: Dumb question: they are in your schema? Spelled

Re: dataimporter, custom fields and parsing error

2013-07-20 Thread Shalin Shekhar Mangar
Are the path and text fields set to stored in the schema.xml? On Sat, Jul 20, 2013 at 3:37 PM, Andreas Owen a...@conx.ch wrote: they are in my schema, path is typed correctly the others are default fields which already exist. all the other fields are populated and i can search for them, just

Re: Order by an expression in Solr

2013-07-20 Thread Jack Krupansky
Sorry, but Solr doesn't perform SQL-like operations. But, please rephrase your query in simple, plain English, and we'll be happy to suggest approaches using Solr. Starting principle: When you think Solr, think NoSQL. You're still thinking SQL! That said, generally, SQL order by refers to

RE: custom field type plugin

2013-07-20 Thread Kevin Stone
Sorry, I accidentally hit send somehow. Here is my ant build.xml for building the CustomPlugins jar file: ?xml version=1.0 encoding=UTF-8 standalone=no? project basedir=. default=jar name=CustomPlugins property environment=env/ property name=debuglevel value=source,lines,vars/ property

RE: custom field type plugin

2013-07-20 Thread Kevin Stone
Thank you for the links, they really helped me understand. I see how the spatial solution works now. I think this could work as a good backup if I cannot get the custom field type working. The custom field would ideally be a bit more robust than what I mentioned before, because a region really

Re: Order by an expression in Solr

2013-07-20 Thread William Bell
Also, when you import set a field that does this in SQL select (CASE WHEN COL1 BETWEEN ${PARAM1} - 10 AND ${PARAM1} + 10 AND COL2=${PARAM2} THEN 1 WHEN COL1 BETWEEN ${PARAM1} - 10 AND ${PARAM1} + 10 AND COL3=${PARAM2} THEN 2 WHEN COL1 - COL3=${PARAM3} THEN 3 WHEN COL4 LIKE

Re: dataimporter, custom fields and parsing error

2013-07-20 Thread Andreas Owen
path was set text wasn't, but it doesn't make a difference. my importer says 1 row fetched, 0 docs processed, 0 docs skipped. i don't understand how it can have 2 docs indexed with such a output. On 20. Jul 2013, at 12:47 PM, Shalin Shekhar Mangar wrote: Are the path and text fields set to

Re: Auto-sharding and numShard parameter

2013-07-20 Thread Erick Erickson
Flavio: One of the great things about having people continually using Solr (and SolrCloud) for the first time is the opportunity to improve the docs. Anyone can update/add to the docs, all it takes is a signon. Unfortunately we has a bunch of spam bots a while ago, so it's now a two step process

Re: Indexing into SolrCloud

2013-07-20 Thread Erick Erickson
NP, glad I was able to help! Erick On Fri, Jul 19, 2013 at 11:07 AM, Beale, Jim (US-KOP) jim.be...@hibu.com wrote: Hi Erick! Thanks for the reply. When I call server.add() it is just to add a single document. But, still, I think you might be correct about the size of the ultimate

Re: Auto-sharding and numShard parameter

2013-07-20 Thread Mark Miller
A lot has changed since those example were written - in general, we are moving away from that type of collection initialization and towards using the Collections API. Eventually, I'd personally like SolrCloud to ship with no predefined collections and have users simply start it and then start