On 4/8/2010 7:05 AM, Shawn Heisey wrote:
Here's what I'm using as the query in my latest config:
Actually, that was three separate queries:
query="SELECT * FROM ${dataimporter.request.dataTable} WHERE did >
${dataimporter.request.minDid} AND did <=
${dataimporter.request.maxDid} AND (did %
${dataimporter.request.numShards}) IN (${dataimporter.request.modVal})"
deltaQuery="SELECT MAX(did) FROM ${dataimporter.request.dataTable}"
deltaImportQuery="SELECT * FROM ${dataimporter.request.dataTable} WHERE
did > ${dataimporter.request.minDid} AND did <=
${dataimporter.request.maxDid} AND (did %
${dataimporter.request.numShards}) IN (${dataimporter.request.modVal})">
The deltaImportQuery is in fact identical to the regular query used for
full-import. The deltaQuery is just something related that returns
quickly, the information is thrown away when it does a delta-import.
Shawn
