lucene-solr-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Solr Wiki] Update of "DataImportHandler" by JamesDyer
Date Thu, 01 Nov 2012 15:29:03 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Solr Wiki" for change notification.

The "DataImportHandler" page has been changed by JamesDyer:
http://wiki.apache.org/solr/DataImportHandler?action=diff&rev1=324&rev2=325

Comment:
changed delta namespace from "dataimport.delta" to "dih.delta".  The longer name doesn't work
in all instances.

   * '''`deltaQuery`''' : Only used in delta-import
   * '''`parentDeltaQuery`''' : Only used in delta-import
   * '''`deletedPkQuery`''' : Only used in delta-import
-  * '''`deltaImportQuery`''' : (Only used in delta-import) . If this is not present , DIH
tries to construct the import query by(after identifying the delta) modifying the '`query`'
(this is error prone). There is a namespace `${dataimporter.delta.<column-name>}` which
can be used in this query.  e.g: `select * from tbl where id=${dataimporter.delta.id}`  <!>
[[Solr1.4]].
+  * '''`deltaImportQuery`''' : (Only used in delta-import) . If this is not present , DIH
tries to construct the import query by(after identifying the delta) modifying the '`query`'
(this is error prone). There is a namespace `${dih.delta.<column-name>}` which can be
used in this query.  e.g: `select * from tbl where id=${dih.delta.id}`  <!> [[Solr1.4]].
  
  == Commands ==
  <<Anchor(commands)>> The handler exposes all its API as http requests . The
following are the possible operations
@@ -261, +261 @@

      <document name="products">
          <entity name="item" pk="ID"
                  query="select * from item"
-                 deltaImportQuery="select * from item where ID='${dataimporter.delta.id}'"
+                 deltaImportQuery="select * from item where ID='${dih.delta.id}'"
-                 deltaQuery="select id from item where last_modified &gt; '${dataimporter.last_index_time}'">
+                 deltaQuery="select id from item where last_modified &gt; '${dih.last_index_time}'">
              <entity name="feature" pk="ITEM_ID"
                      query="select description as features from feature where item_id='${item.ID}'">
              </entity>
@@ -284, +284 @@

  
  {{{
          deltaQuery="select id from item where id in
-                                 (select item_id as id from feature where last_modified >
'${dataimporter.last_index_time}')
+                                 (select item_id as id from feature where last_modified >
'${dih.last_index_time}')
                                  or id in
                                  (select item_id as id from item_category where item_id in
-                                     (select id as item_id from category where last_modified
> '${dataimporter.last_index_time}')
+                                     (select id as item_id from category where last_modified
> '${dih.last_index_time}')
-                                 or last_modified &gt; '${dataimporter.last_index_time}')
+                                 or last_modified &gt; '${dih.last_index_time}')
-                                 or last_modified &gt; '${dataimporter.last_index_time}'"
+                                 or last_modified &gt; '${dih.last_index_time}'"
  }}}
   * Writing a huge deltaQuery like the above one is not a very enjoyable task, so we have
an alternate mechanism of achieving this goal.
  
@@ -298, +298 @@

      <dataSource driver="org.hsqldb.jdbcDriver" url="jdbc:hsqldb:/temp/example/ex" user="sa"
/>
      <document>
              <entity name="item" pk="ID" query="select * from item"
-                 deltaImportQuery="select * from item where ID=='${dataimporter.delta.id}'"
+                 deltaImportQuery="select * from item where ID=='${dih.delta.id}'"
-                 deltaQuery="select id from item where last_modified &gt; '${dataimporter.last_index_time}'">
+                 deltaQuery="select id from item where last_modified &gt; '${dih.last_index_time}'">
                  <entity name="feature" pk="ITEM_ID"
                      query="select DESCRIPTION as features from FEATURE where ITEM_ID='${item.ID}'"
-                     deltaQuery="select ITEM_ID from FEATURE where last_modified > '${dataimporter.last_index_time}'"
+                     deltaQuery="select ITEM_ID from FEATURE where last_modified > '${dih.last_index_time}'"
                      parentDeltaQuery="select ID from item where ID=${feature.ITEM_ID}"/>
  
  
              <entity name="item_category" pk="ITEM_ID, CATEGORY_ID"
                      query="select CATEGORY_ID from item_category where ITEM_ID='${item.ID}'"
-                     deltaQuery="select ITEM_ID, CATEGORY_ID from item_category where last_modified
> '${dataimporter.last_index_time}'"
+                     deltaQuery="select ITEM_ID, CATEGORY_ID from item_category where last_modified
> '${dih.last_index_time}'"
                      parentDeltaQuery="select ID from item where ID=${item_category.ITEM_ID}">
                  <entity name="category" pk="ID"
                          query="select DESCRIPTION as cat from category where ID = '${item_category.CATEGORY_ID}'"
-                         deltaQuery="select ID from category where last_modified &gt;
'${dataimporter.last_index_time}'"
+                         deltaQuery="select ID from category where last_modified &gt;
'${dih.last_index_time}'"
                          parentDeltaQuery="select ITEM_ID, CATEGORY_ID from item_category
where CATEGORY_ID=${category.ID}"/>
              </entity>
          </entity>

Mime
View raw message