the query makes my head spin . joining on an sql does not enable you to populate multivalued fields . Otherwise , it is all fine
pk attribute is missing in the entity On Tue, Oct 14, 2008 at 6:16 PM, Florian Aumeier <[EMAIL PROTECTED]> wrote: > Noble Paul നോബിള് नोब्ळ् schrieb: >> >> apparently you have not specified the deltaQuery attribute in the entity. >> Check the delta-import section in the wiki >> http://wiki.apache.org/solr/DataImportHandler >> or you can share your data-config file and we can take a quick look >> >> > > here is my data-config. I configured both, the deltaQuery and query entity > in one data-config. Is this the correct usecase? > Also, I found it easier to join the document on the database level instead > of leaving it to solr. > > <dataConfig> > <dataSource type="JdbcDataSource" driver="org.postgresql.Driver" > url="jdbc:postgresql://bm02:5432/bm" user="user" /> > > <document name="articles"> > <entity name="articles" deltaQuery="SELECT a.id AS article_id,a.stub AS > article_stub,a.ref AS article_ref,a.id_blogs,a.title AS article_title, > a.normalized_text, au.url AS article_url, bu.url AS blog_url, b.title AS > blog_title,b.subtitle AS blog_subtitle, r.rank, > coalesce(a.updated,a.published,a.added) as ts FROM articles a join blogs b > on a.id_blogs = b.id join urls au on a.id_urls = au.id join urls bu on > b.id_urls = bu.id LEFT OUTER JOIN ranks r on a.id = r.id_articles WHERE > b.id_urls is not null AND a.hidden is false AND b.hidden is false AND a.ref > is not null AND b.ref is not null AND (rankid in (SELECT rankid FROM ranks > order by rankid desc limit 1) OR rankid is null) AND > coalesce(a.updated,a.published,a.added) > > '${dataimporter.last_index_time}'" > query="SELECT a.id AS article_id,a.stub AS article_stub,a.ref AS > article_ref,a.id_blogs,a.title AS article_title, a.normalized_text, au.url > AS article_url, bu.url AS blog_url, b.t\ > itle AS blog_title,b.subtitle AS blog_subtitle, r.rank, > coalesce(a.updated,a.published,a.added) as ts FROM articles a join blogs b > on a.id_blogs = b.id join urls au on a.id_urls = au\ > .id join urls bu on b.id_urls = bu.id LEFT OUTER JOIN ranks r on a.id = > r.id_articles WHERE b.id_urls is not null AND a.hidden is false AND b.hidden > is false AND a.ref is not null AN\ > D b.ref is not null AND (rankid in (SELECT rankid FROM ranks order by rankid > desc limit 1) OR rankid is null) AND > coalesce(a.updated,a.published,a.added)"> > <field column="article_id" name="a_id" /> > <field column="normalized_text" name="norm_text" /> > <field column="article_ref" name="id" /> > <field column="article_stub" name="stub" /> > <field column="id_blogs" name="blog_id" /> > <field column="article_title" name="a_title" /> > <field column="article_url" name="article_url" /> > <field column="ts" name="ts" /> > <field column="rank" name="rank" /> > <field column="blog_ref" name="blog_ref" /> > <field column="blog_title" name="b_title" /> > <field column="blog_subtitle" name="subtitle" /> > > <field column="blog_url" name="blog_url" /> > > </entity> > > </document> > > </dataConfig> > > Florian > > -- --Noble Paul
