lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hangu Choi <dev.ha...@gmail.com>
Subject [DIH] deltaQuery has no column to resolve to declared primary key pk='id'
Date Tue, 10 Nov 2015 07:11:15 GMT
Hi,
I stuck in DIH...

full import is fine.
and delta import was also fine before I add deltaQuery and parentDeltaQuery
in 'auth' entity.

thank you for any help..




<dataConfig>
    <dataSource driver="org.mariadb.jdbc.Driver"

url="jdbc:mysql://localhost:3306/mydb?allowMultiQueries=true"
                user="sa"
                password="" />
    <document>
        <entity name="article" PK="article_id"
                query="select article_id, revision_id, title, content,
utc_rev_datetime from article_revision a1 where revision_id in  (select
max(revision_id) from article_revision a2 where a1.article_id =
a2.article_id)"
                deltaImportQuery="select article_id, revision_id, title,
content, utc_rev_datetime from article_revision a1 where revision_id in
 (select max(revision_id) from article_revision a2 where a1.article_id =
a2.article_id) and article_id=${dataimporter.delta.article_id}"
                deltaQuery="select article_id from article_revision a1
where revision_id in  (select max(revision_id) from article_revision a2
where a1.article_id = a2.article_id) and a1.utc_rev_datetime >
'${dataimporter.last_index_time}'">
           <field column="article_id" name="id" />
           <field column="title" name="title" />
           <field column="utc_rev_datetime" name="utc_rev_datetime" />
           <field column="content" name="content" />
           <entity name="auth" PK="auth_id"
                        query="select * from article_authority where
article_id ='${article.article_id}'"
                        deltaQuery="select article_id from
article_authority where utc_last_managed_datetime >
'${dataimporter.last_index_time}'"
                        parentDeltaQuery="select article_id from
article_revision a1 where revision_id in  (select max(revision_id) from
article_revision a2 where a1.article_id = a2.article_id) and
a1.article_id=${auth.article_id}" >
                <field name="auth_id" column="auth_id" />
                <field name="read_auth_level" column="read_auth_level" />
                <field name="manager_id" column="manager_id" />
                <field name="utc_last_managed_datetime"
column="utc_last_managed_datetime" />
           </entity>
        </entity>
    </document>
</dataConfig>





Regards,
Hangu

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message