Re: How to do sorting instead of using bq

Hi Upayavira, Yes, I have create boost which is come from outside and I can't index them into the doc because it need to be realtime sort. How can i do? other solution for the sort in this case? Thank you very much, Chun. -- View this message in context: http://lucene.472066.n3.nabble.com/H

How to do sorting instead of using bq

Hi all, I'm trying to sort some docs which is about 200 or more docs. by using bq like this.. *[bq] => product_id:L90094438^1 product_id:L90094438^3 product_id:L90094438^5 product_id:W27529923^123 product_id:W27529678^127 product_id:W27530909^133* *[sort] => score asc* The score that ret

Re: Customise score

Hi Jack, I just found out that the sort it doesn't work right for the next page. The response result show that "numFound":23850. So I tried this .../select?q=MacBook&sort=sum(base_score,query($q,0))+desc&wt=json&indent=true&start=100 The summary of base_score and document sort at the next page s

Re: Customise score

Hi, Jack, Thank you very much for you solution its works! I'm sorry that I didn't make it clear at the beginning for 'score' which i mean document score (solr produce it at query time). Thank you very much for all of you, Chun. -- View this message in context: http://lucene.472066.n3.n

Re: Customise score

Hi Jack, I tried as you suggest .../select?q=MacBook&sort=sum(base_score,score)+desc&wt=json&indent=true but it didn't work and I got this error message "error":{ "msg":"sort param could not be parsed as a query, and is not a field that exists in the index: sum(base_score,score)", "c

Re: Customise score

Hi Ahmet, I also tried this .../select?q=MacBook&sort=sum(base_score, score)+desc&wt=json&indent=true I got the same error "error":{ "msg":"Can't determine a Sort Order (asc or desc) in sort spec 'sum(base_score, score) desc', pos=15", "code":400}} Best regards, Chun -- View this me

Re: Customise score

Gora, firstly I would like thank you for your quick response. .../select?q=MacBook&sort=SUM(base_score, score)+desc&wt=json&indent=true I tried that but it didn't work and I got this error message "error":{ "msg":"Can't determine a Sort Order (asc or desc) in sort spec 'SUM(base_score, scor

Customise score

Dear all, Could anybody suggest me how to customize the score? So, I have data like this .. {ID : '0001', Title :'MacBookPro',Price: 400,Base_score:'121.2'} {ID : '0002', Title :'MacBook',Price: 350,Base_score:'100.2'} {ID : '0003', Title :'Laptop',Price: 300,Base_score:'155.7'} Notice that I ha

Re: How to sort value that numeric mix alpha

Thank you for both of you I finally re-index data and remove 'C' and index only numeric. So, that the way I fix my problem. Best, Chun. -- View this message in context: http://lucene.472066.n3.nabble.com/How-to-sort-value-that-numeric-mix-alpha-tp4144615p4144693.html Sent from the Solr - Use

How to sort value that numeric mix alpha

Dear all, Could anybody suggest me how to sort the field that has numeric mix with alpha. In my case I have field name 'product_id' which contain value like C1,C2,C3,C4,C9,C12,C23,C50 when I try to sort (DESC) it return wrong result something like this C9,C50,C4,C3,C23,C2,C12,C1 As you see I ha

Re: Solr shut down by itself

HI Alex, Thank you very much for your suggestion. I found some OOM problem before it shut down. Now I will try to fix that problem. Best, Chun. -- View this message in context: http://lucene.472066.n3.nabble.com/Solr-shut-down-by-itself-tp4138233p4138378.html Sent from the Solr - User mailing

Solr shut down by itself

Dear all, Could anyone tell me what wrong with this? How can I fix this problem? INFO - 2014-05-27 03:08:00.252; org.eclipse.jetty.server.Server; Graceful shutdown SocketConnector@0.0.0.0:8983 INFO - 2014-05-27 03:08:00.254; org.eclipse.jetty.server.Server; Graceful shutdown o.e.j.w.WebAppCont

Re: about analyzer and tokenizer

Thank you very much for your suggestion both of you. I will try more to figure out which way will be match with my case. Chun. -- View this message in context: http://lucene.472066.n3.nabble.com/about-analyzer-and-tokenizer-tp4138129p4138227.html Sent from the Solr - User mailing list archive

about analyzer and tokenizer

Dear all, How can I do this... I index the document => Macbook then when I query mac book I should get the result. This is my schema setting... Any suggest would be very appreciate. Chun. -- View this message in context

Re: group.ngroups behavior in response

Hi Amit, could you tell me is this problem fix in Solr 4.6.0? because i still having this problem or any suggestion? please help. thank you very much, Chun. -- View this message in context: http://lucene.472066.n3.nabble.com/group-ngroups-behavior-in-response-tp4033924p4132473.html Sent from

Re: numFound is not correct while using Result Grouping

I'm still having the same problem which is can not get ngroups when set group.main=true. Is this problem fix? I'm usgin Solr 4.6.0 than you very much, Chun. -- View this message in context: http://lucene.472066.n3.nabble.com/numFound-is-not-correct-while-using-Result-Grouping-tp4042766p41324

Re: PHP Solr Client - spellchecker

Thank you very much Shawn, Now i'm trying to use prefix for my suggestion instead. Best regards, Chun -- View this message in context: http://lucene.472066.n3.nabble.com/PHP-Solr-Client-spellchecker-tp4122780p4123054.html Sent from the Solr - User mailing list archive at Nabble.com.

PHP Solr Client - spellchecker

org.apache.solr.core.SolrCore; [collection1] webapp=/solr path=/spell params={spellcheck=true&extendedResults=true&fl=product_name_th&spellcheck.accuracy=0.8&q=macbook&spellcheck.collate=true&qt=spellchecker} hits=4 status=0 QTime=2 At this point I can see that it

Re: Can not index document in solar

Thank you Eric, I figured out something that actually the document is indexed but it doesn't show on my api result because it missed some field. So I would like to delete this post how can I? Thank you very much, Chun. -- View this message in context: http://lucene.472066.n3.nabble.com/Can-n

Can not index document in solar

Dear all, Could you guys please help me? I just try to index document into solar it doesn't give me any error but it doesn't index document too but it used to work but not now please see.. #Solr Log WARN - 2014-02-25 11:30:35.675; org.apache.solr.handler.loader.XMLLoader; Unknown attribute id

Re: Limit amount of search result

hi Samee, Thank you very much for your suggestion. Now I got it worked now;) Chun. -- View this message in context: http://lucene.472066.n3.nabble.com/Limit-amount-of-search-result-tp4117062p4117952.html Sent from the Solr - User mailing list archive at Nabble.com.

Limit amount of search result

Dear all gurus, I would like to limit amount of search result, let's say I have many shop which is selling shirt. So when I search "white shirt" I want to give a maximum number per shop (ex. 5). The result should be like this... -> Shop A -> Shop A -> Shop B -> Shop B -> Shop B -> Shop B -> Shop

Re: Import data from mysql to sold

I agree with you. I finally have another solution for this problem we will import all data directly from mysql instead. Thank you for all comments, keep sharing keep learning :) _/|\_ Chun. -- View this message in context: http://lucene.472066.n3.nabble.com/Import-data-from-mysql-to-sold-tp4

Re: Import data from mysql to sold

Hi Jack, Thank you very much for your reply. I've read that article already but it seem not what i am looking for. I'm not sure if it's possible to do what i want or not. Now I can import all data from mysql to Solr but my boss just want me to find the way to import from MongoDB into solr. Bes

Re: Import data from mysql to sold

Hi gurus, after I got Solr DIH work with mysql now I need to make figure out how to make it work with MongoDB. I have been searching for all day but I don't have luck with it. So could anyone please suggest me any site for my solution? Thank you very much, Chun. -- View this message in conte

Re: Import data from mysql to sold

I just would like to thank you for all guru's comments ;) Now i got it work Thank you for sharing and helps. _/|\_ Chun. -- View this message in context: http://lucene.472066.n3.nabble.com/Import-data-from-mysql-to-sold-tp4114982p4115431.html Sent from the Solr - User mailing list archive

Re: Import data from mysql to sold

please see below code.. my question is.. 1. what is the url for? (url="jdbc:mysql://localhost:3306/mydb01" ) does it means my database url? 2. did i do it right with this i'm not sure name means the field in Solr? Thank you very much, Chun.

Import data from mysql to sold

Dear all gurus, I would like to import my data (mysql) about 4 Million rows into solar 4.6. What is the best way to do it? Please suggest me. Million thanks, Chun. -- View this message in context: http://lucene.472066.n3.nabble.com/Import-data-from-mysql-to-sold-tp4114982.html Sent from t

Re: Query by range of price

Thank you very much Mr. Raymond You just saved my world ;) It's worked and *sort by conditions * but facet.query=price_min:[* TO 1300] not working yet but I will try to google for the right solution. Million thanks _/|\_ Rachun. -- View this message in context: http://lucene.4720

Re: Query by range of price

Hi Raymond, I keep trying to encode the '&' but when I look at the solar log it show me that '%26' I'm using urlencode it didn't work what should i do? Im using SolrPHPClient. Please suggest me. Thank you very much, Rachun -- View this message in

Re: Query by range of price

Hi Raymond, I keep trying to encode the '&' but when I look at the solar log it show me that '%26' I'm using urlencode it didn't work what should i do? Im using PHPSolrClient. Please suggest me. Thank you very much, Rachun -- View this message in

Re: Query by range of price

Hi Raymond, I keep trying to encode the '&' but when I look at the solar log it show me that '%26' I'm using urlencode it didn't work what should i do? Please suggest me. Thank you very much, Rachun -- View this message in context: http://lucene.4720

Re: Query by range of price

Thank you very much Raymond, I will try -- View this message in context: http://lucene.472066.n3.nabble.com/Query-by-range-of-price-tp4111655p4112229.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Query by range of price

I have no idea Mr. Eric :( thanks, Rachun -- View this message in context: http://lucene.472066.n3.nabble.com/Query-by-range-of-price-tp4111655p4111853.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Query by range of price

this is the log says: INFO - 2014-01-17 09:50:14.448; org.apache.solr.core.SolrCore; [collection1] webapp=/solr path=/select params={start=0&q=???%26sort%3Dprice_min+asc,update_date+desc%26facet.query%3Dprice_min:[*%2BTO%2B1300]&json.nl=map&wt=json&rows=100} status=400 QTime=2 could you plea

Query by range of price

Hi Gurus, Please help... I just want to query the document with price_min range and I do like this q=...&sort=price_min asc,update_date desc&facet.query=price_min:[*+TO+1300] I got error '400' Status: Bad Request what's wrong with this? Thank you very much. -- View this message in context:

Re: Can I define the copy field like title_*

thank you very much Mr. Sumit -- View this message in context: http://lucene.472066.n3.nabble.com/Can-I-define-the-copy-field-like-title-tp468p471.html Sent from the Solr - User mailing list archive at Nabble.com.

Can I define the copy field like title_*

I just wonder can I define copy field like this instead of millions thank you Rachun -- View this message in context: http://lucene.472066.n3.nabble.com/Can-I-define-the-copy-field-like-title-tp468.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: How to index data in muliValue field with key

thank you Mr. Steve. Now I understood and i figured out to separate field to title_th and title_en and it worked ;) -- View this message in context: http://lucene.472066.n3.nabble.com/How-to-index-data-in-muliValue-field-with-key-tp4110653p4110981.html Sent from the Solr - User mailing list arc

How to index data in muliValue field with key

*This might be very simple question but I can't figure out after i tried to google all day. I just want the data to show like this* /"record": [ { id: "product001" name: "iPhone case", title: { th: "เคส ไอโฟน5 iphone5 Case วิบวับ ลายผสมมุกสีชมพู back case",