Re: dismax and date boosts

2010-07-14 Thread Shawn Heisey
I have finally figured out how to turn this off in Thunderbird 3: Go to Tools, Options, Display, and turn off "Display emoticons as graphics". On 4/12/2010 12:04 PM, Shawn Heisey wrote: On 4/12/2010 11:55 AM, Shawn Heisey wrote: [NOW-6MONTHS TO NOW]^5.0 , [NOW-1YEARS TO NOW-6MONTHS]^3.0 [NO

Re: dismax and date boosts

2010-04-20 Thread Shawn Heisey
I found what I believe is a better option even if the multiplication would work - FROM_UNIXTIME. That returns the same kind of output as you get from an actual database date field. On 4/20/2010 12:07 PM, Shawn Heisey wrote: So, if I have my database multiply my value by 1000, I can put that d

Re: dismax and date boosts

2010-04-20 Thread Shawn Heisey
So, if I have my database multiply my value by 1000, I can put that directly into a tdate field and it'll work as expected? If that's the case, I think I might be able to modify my query from "SELECT *" to "SELECT *,post_date*1000 as pdate" and add the pdate field to the schema as type tdate.

Re: dismax and date boosts

2010-04-17 Thread Lance Norskog
No, a copyField will not do the xlation from (seconds from epoch) to (milliseconds from 1/1/1970). You should be able to do this with a combination of functions in your database SELECT call. The major DBs all have a wealth of functions that xform between numbers and dates. The DIH is smart about t

Re: dismax and date boosts

2010-04-15 Thread Shawn Heisey
It's stored in the database as a bigint, seconds since epoch, not a date. I need to store the integer value in Solr for the application to consume (done as a tlong), but I want to create a second copy that's tdate. That's the part I don't know how to do. If I just do a copyField in the schem

Re: dismax and date boosts

2010-04-14 Thread Lance Norskog
Wait- it's in a database? That's much simpler. The select should supply the date as an SQL Date or Timestamp type. The DIH will get this directly and store it as a Solr tdate. You should not have to do any arithmetic or formatting of date strings. This may need a few layers of SQL functions. On

Re: dismax and date boosts

2010-04-14 Thread Shawn Heisey
On 4/14/2010 8:12 AM, Shawn Heisey wrote: On 4/12/2010 9:29 PM, Lance Norskog wrote: During indexing: the basic Solr XmlUpdateHandler does not have a facility for this. In the DataImportHandler you can add Javascript that takes your 'seconds since epoch', adds the delta between your epoch and 1/

Re: dismax and date boosts

2010-04-12 Thread Lance Norskog
So, you have a user-visible field that is in 'seconds since epoch'. You would like to index this, and the Solr date features are handy. And, you do not have an application prepping the data to index, nor do you have a UI that can receive Solr dates and turn them back into 'seconds since epoch'. Du

Re: dismax and date boosts

2010-04-12 Thread Shawn Heisey
On 4/12/2010 11:55 AM, Shawn Heisey wrote: [NOW-6MONTHS TO NOW]^5.0 , [NOW-1YEARS TO NOW-6MONTHS]^3.0 [NOW-2YEARS TO NOW-1YEARS]^2.0 [* TO NOW-2YEARS]^1.0 And here we have the perfect example of something I mentioned a while ago - my Thunderbird (v3.0.4 on Win7) turning Solr boost syntax into

dismax and date boosts

2010-04-12 Thread Shawn Heisey
I am trying to boost relevancy based on a date field with dismax, and I've included the requestHandler config below. The post_date field in my database is simple UNIX time, seconds since epoch. It's in a MySQL bigint field, so I've stored it as a tlong in Solr. This filed is required by our