Re: Is there any "Query" in Lucene can search the term, which is similar as "SQL-LIKE"?

2011-10-17 Thread Sujit Pal
ram88||';'||mv.c_param89||';'||mv.c_param90||';'||mv.c_param91||';'||mv.c_param92||';'||mv.c_param93||';'||mv.c_param94||';'||mv.c_param95||';'||mv.c_param96||';'||mv.c_param97||';'||mv.c_param98||

Re: Is there any "Query" in Lucene can search the term, which is similar as "SQL-LIKE"?

2011-10-12 Thread Mead Lai
7;||mv.c_param84||';'||mv.c_param85||';'||mv.c_param86||';'||mv.c_param87||';'||mv.c_param88||';'||mv.c_param89||';'||mv.c_param90||';'||mv.c_param91||';'||mv.c_param92||';'||mv.c_param93||';'||mv.c_pa

Re: Is there any "Query" in Lucene can search the term, which is similar as "SQL-LIKE"?

2011-10-12 Thread Mead Lai
27;||mv.c_param87||';'||mv.c_param88||';'||mv.c_param89||';'||mv.c_param90||';'||mv.c_param91||';'||mv.c_param92||';'||mv.c_param93||';'||mv.c_param94||';'||mv.c_param95||';'||mv.c_param96||';'||mv.c_param

Re: Is there any "Query" in Lucene can search the term, which is similar as "SQL-LIKE"?

2011-10-11 Thread Chris Lu
ram94||';'||mv.c_param95||';'||mv.c_param96||';'||mv.c_param97||';'||mv.c_param98||';'||mv.c_param99||';'||mv.c_param100||';' > FROM MyTable mv > > *=Step2*: search the view with LIKE '%keyword%' > > SELECT * > FROM V_MY_VIEW wcv > WHERE wcv.content LIKE '%keyword%' > > Finally, it works nice, but inefficiency, almost cost 5~7 seconds. cos ONE > MILLION rows are tooo huge. > > *Lucene way:* >So, I use the Lucene to store these ONE MILLION data, > code:document.add(new Field("content", content, Store.YES, > Index.ANALYZED));//variable content, is the strings which jointed from the > 100 columns > The problem is that: if some keyword is not a word or a term, the > search will return nothing. > Usually, the keyword would be a person's name or some jargon, like > 'catstiger.amber','amin.ahmad','fund-in-trust'. > and 'catstiger.amber' can't be split into a term to save in the index store >Cos, the Index.ANALYZED would fail to recognition the keyword as a term > , so there is no such index at all. > So, In short, is there any "Query" in Lucene can search the term, which is > similar as "SQL-LIKE"? > >This SQL-function will meet the purpose: > > SELECT * FROM luceneDB ldb > WHERE ldb.content *LIKE* '%keyword%' > > Thank you very much. > > Regards, > Mead >

Re: Is there any "Query" in Lucene can search the term, which is similar as "SQL-LIKE"?

2011-10-11 Thread Ian Lea
v.c_param89||';'||mv.c_param90||';'||mv.c_param91||';'||mv.c_param92||';'||mv.c_param93||';'||mv.c_param94||';'||mv.c_param95||';'||mv.c_param96||';'||mv.c_param97||';'||mv.c_param98||';'||mv.c_p

Is there any "Query" in Lucene can search the term, which is similar as "SQL-LIKE"?

2011-10-11 Thread Mead Lai
#x27;;'||mv.c_param92||';'||mv.c_param93||';'||mv.c_param94||';'||mv.c_param95||';'||mv.c_param96||';'||mv.c_param97||';'||mv.c_param98||';'||mv.c_param99||';'||mv.c_param100||';' FROM MyTable mv *=Step2*