intersect query

2014-03-25 Thread cmd.ares
my_index(one core): id,dealer,productName,amount,region 1,A1,iphone4,400,east 2,A1,iphone4s,450,east 3,A2,iphone5s,550,east .. 4,A1,iphone4,400,west 5,A1,iphone4s,450,west 6,A3,iphone5s,550,west .. -I'd like to get which dealer sale the 'iphone' both in the 'east' and 'west' pl/sql

solr result handler??

2014-08-29 Thread cmd.ares
I have a blacklist save some keywords,and the query results need to be excluded the blacklist。if any filed value contains the keyword,the row should be removed. I think there are two ways: 1.modify the solr resultset handler..and which class can be modify? 2.if can implement or extend some class to

Order by an expression in Solr

2013-07-19 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 WHE

Hierarchical Facets filter the current(or first) level?

2013-04-24 Thread cmd.ares
since the path is very large,so i want to show the path like dos commend cmd>dir /ad ratherthan cmd>dir /s/ad how to filer the query faceting?It would be return the first level only!to be like this: 1674480 123123

multiple field join?

2013-05-29 Thread cmd.ares
http://wiki.apache.org/solr/Join I found solr join is actually sql subquery,does solr support 3 tables jion ? the sql like this SELECT xxx, yyy FROM collection1 WHERE outer_id IN (SELECT inner_id FROM collection1 where zzz = "vvv") and outer_id2 IN (SELECT inner_id2 FROM collection1 where tt

solr faceting sum function

2012-12-13 Thread cmd.ares
lucene index structure: product_name type price --- iphone4s mobile 2000 iphone5 mobile 5000 S3 mobile 3000 intel i3 pc 1000 intel i5

facet count distinct and sum group by field

2012-12-13 Thread cmd.ares
lucene index structure: product_name type price --- iphone4s mobile 2000 iphone4s mobile 1500 iphone5 mobile 5000 iphone5 mobile 5000 S3

industry word extract

2013-02-17 Thread cmd.ares
i use dih to create index on oracle table data table:tab_post_content ---id-content(varchar2 4000)--: for example 0001 i have an ipad and Seagate hd industry word table: tab_iword --code-word-: for example 01/00/00 computer 01/01/00 cpu 01/01/01 intel 01/01/02 amd 01/02/0

solr 4 fragmentsBuilder and highlightMultiTerm

2013-02-21 Thread cmd.ares
how to config the solrconfig.xml to open fragmentsBuilder and highlightMultiTerm on 4.0 and 4.1 i read the documnet on wiki but i don't know where the snippet should be placed. and how to call by url path thanks -- View this message in context: http://lucene.472066.n3.nab

solr 4 tika config

2012-10-16 Thread cmd.ares
I want to index all pdf files in "d:\myfiles\*.*" file fullname as the field id file content as the field txt the index should be like this: -id---txt-- d:\myfiles\0.pdfa d:\myfiles\subfolder1\1.pdf bb