lucene - Apache Solr one to many relationship mapping -


i have following configured in db-config.xml

<dataconfig>   <datasource type="jdbcdatasource"             driver="com.mysql.jdbc.driver"             url="jdbc:mysql://host:port/schema"             user="username"             password="password" />      <document name="product">     <entity name="store" query="select mid,name,display_name,address,email,pincode,b.latitude,b.longitude,city,locality,b.lid,b.locid business b join locality loc on b.locid = loc.locid join location l on l.lid = loc.lid b.status='a' , isitemstore ='y' , mid between  11151 , 11161 ">         <field column="mid" name="id"/>         <field column="lid" name="lid"/>         <field column="locid" name="locid"/>         <field column="name" name="name"/>         <field column="display_name" name="display_name"/>         <field column="address" name="address"/>         <field column="email" name="email"/>         <field column="pincode" name="pincode"/>         <field column="latitude" name="latitude"/>         <field column="longitude" name="longitude"/>         <field column="city" name="city"/>         <field column="locality" name="locality"/>          <entity name="item" query="select ib.cid,ib.bid,ib.item_id,b.bname,c.cname,ib.description,short_description,     concat(field_1,' ',field_2,' ',field_3,' ',field_4,' ',field_5,' ',field_6) item_feature,inv.pos_code,sku_count,unit_price,final_price item_business ib join brand b on ib.bid = b.bid join category c on c.cid=ib.cid join `${store.mid}-inventory-table` inv ib.status='a'">                 <field column="item_id" name="item_id"/>                     <field column="short_description" name="short_description"/>                <field column="item_desc" name="item_desc"/>                <field column="item_feature" name="item_feature"/>                <field column="bid" name="bid"/>                <field column="cid" name="cid"/>                <field column="bname" name="brand_name" />                <field column="cname" name="category_name" />                     <field column="pos_code" name="pos_code" />                   <field column="sku_count" name="sku_count" />                     <field column="unit_price" name="unit_price" />                   <field column="final_price" name="final_price" />                  </entity>     </entity>     </document> </dataconfig>

the below snippet have in schema.xml

<uniquekey>id</uniquekey>           <field name="id" type="tlong" indexed="true" stored="true"/>      <field name="name" type="text_general" indexed="true" stored="true"/>      <field name="display_name" type="text_general" indexed="true" stored="true"/>      <field name="address" type="text_general" indexed="true" stored="true"/>      <field name="email" type="text_general" indexed="true" stored="true"/>      <field name="pincode" type="text_general" indexed="true" stored="true"/>     <field name="latitude" type="tdouble" indexed="true" stored="true"/>     <field name="longitude" type="tdouble" indexed="true" stored="true"/>     <field name="city" type="text_general" indexed="true" stored="true"/>     <field name="locality" type="text_general" indexed="true" stored="true"/>     <field name="item_id" type="tlong" indexed="true" stored="true"/>            <field name="bname" type="text_general" indexed="true" stored="true"/>     <field name="cname" type="text_general" indexed="true" stored="true"/>     <field name="item_feature" type="text_general" indexed="true" stored="true"/>     <field name="item_desc" type="text_general" indexed="true" stored="true"/>     <field name="short_description" type="text_general" indexed="true" stored="true"/>     <field name="pos_code" type="text_general" indexed="true" stored="true"/>         <field name="sku_count" type="tint"    indexed="true"  stored="true"/>      <field name="unit_price" type="tdouble"    indexed="true"  stored="true"/>      <field name="final_price" type="tdouble"    indexed="true"  stored="true"/>

solrconfig.xml

 <lib dir="../../../dist/" regex="solr-dataimporthandler-\d.*\.jar" />     <requesthandler name="/dataimport"  class="org.apache.solr.handler.dataimport.dataimporthandler">     <lst name="defaults">         <str name="config">db-data-config.xml</str>     </lst>    </requesthandler

i beginner in apache solr. , followed solr wiki server , running jetty server.

scenario : store has items , items have attributes.

i store information , store items store has.

but indexing happens 1 store , 1 item instead of 1 store , items in 1 store.

how second query in db-config.xml run multiple times fetch items store?

and see there multi-value option, not sure how use in context.

can 1 help?


Comments

Post a Comment

Popular posts from this blog

html - Outlook 2010 Anchor (url/address/link) -

i'm trying link specific pdf page msoutlook'10 or msword'10, #page=... anchor particularly useful , works fine elsewhere. unfortunately when click [ctr-k] in outlook or winword, links re-formatted assuming unc path. pdf file located on shared drive. using "file:" prefix links open pdf in adobe reader (outside of browser), , "http:" open inside browser. issue seem need open in browser "file:" prefix in order anchor work. know anchors work inside browser. outlook uses windows/explorer default program (based on file extension) seems open in adobe reader neglecting anchor. is aware of solution, link specific page or bookmark of shared-pdf ms outlook and/or winword link? common references: mailermailer.com/...anchor-tags-html-emails campaignmonitor.com/...anchor-links-in-email-newsletters/ stackoverflow.com/...anchor-in-pdf-document
Read more

javascript - Why does running this loop 9 times take 100x longer than running it 8 times? -

consider code: test = function() { } t = new test(); (var = 0; < 8; i++) { result = t instanceof test; } if change number of iterations 8 9 , loop take 100 times longer complete in latest version of firefox (41.0.1). tested on 2 different pcs , magic limit 8. here jsperf test used: http://jsperf.com/instanceof-8-times-vs-9-times does have idea why might happen? seems specific instanceof . not happen if else object, example check property. note: filed bugzilla bug this. jan de mooij mozilla team has posted details in bugzilla thread . here's simplistic interpretation of highly technical answers: in i < 8 case, firefox smart enough hoist result = t instanceof test; statement out of loop (according tests, doesn't seem omit altogether). in i < 9 case, apparently doesn't optimization . why? reason not clear, related fact 9 iterations threshold above function considered "hot" enough run through jit compiler. i < 8 cas...
Read more

Getting gateway time-out Rails app with Nginx + Puma running on Digital Ocean -

following this guide setup app on digital ocean droplet, not working. site not loading , it's throwing: "gateway time-out". the puma server works, since ps aux | grep puma prints: root 15878 0.0 0.4 376832 2168 ? sl 12:50 0:00 puma 2.13.4 (unix:///var/www/myapp/shared/tmp/sockets/myapp-puma.sock) [20150930164940] root 15881 0.0 0.7 903676 3692 ? sl 12:50 0:06 puma: cluster worker 0: 15878 [20150930164940] root 24654 0.0 0.1 11748 916 pts/2 s+ 18:00 0:00 grep --color=auto puma my nginx config: user root; worker_processes 1; events { worker_connections 1024; } http { upstream puma { server unix:///var/www/myapp/shared/tmp/sockets/myapp-puma.sock; } server { listen 80; server_name myapp.com; root /var/www/myapp/current/public; access_log /var/www/myapp/current/log/access.log; error_log /...
Read more