Re: pk vs. uniqueKey with DIH delta-import

2009-06-20 Thread Lance Norskog
https://issues.apache.org/jira/browse/SOLR-1191 describes a different problem but I think his Ali's solution applies here. I tried 'select concat("",id) from table' and this also had the same exception. I can't test now, but I think this is the solution: select concat("prefix",id) AS ID The JDB

Re: pk vs. uniqueKey with DIH delta-import

2009-06-18 Thread Erik Hatcher
On Jun 18, 2009, at 4:51 AM, Noble Paul നോബിള്‍ नोब्ळ् wrote: apparently the row return a null 'board_id' I replied "No" earlier, but of course you're right here. The deletedPkQuery I originally used was not returning a board_id column. And even if it did, that isn't the uniqueKey (i

Re: pk vs. uniqueKey with DIH delta-import

2009-06-18 Thread Erik Hatcher
On Jun 18, 2009, at 4:51 AM, Noble Paul നോബിള്‍ नोब्ळ् wrote: apparently the row return a null 'board_id' No. I'm working with a test database situation with a single record, and I simply do a full-import, then change the deleted column to 'Y' and try a delta-import. The deletedPkQuery

Re: pk vs. uniqueKey with DIH delta-import

2009-06-18 Thread Noble Paul നോബിള്‍ नोब्ळ्
a have raised an issue and fixed it https://issues.apache.org/jira/browse/SOLR-1228 2009/6/18 Noble Paul നോബിള്‍ नोब्ळ् : > apparently the row return a null 'board_id' > > your stacktrace sugggests this. even if it is fixed I guess it may not > work because your are storing the id as > > > board-

Re: pk vs. uniqueKey with DIH delta-import

2009-06-18 Thread Noble Paul നോബിള്‍ नोब्ळ्
apparently the row return a null 'board_id' your stacktrace sugggests this. even if it is fixed I guess it may not work because your are storing the id as board-${test.board_id} and unless your query returns something like board- it may not work for you. Anyway i shall put in a fix ion DIH to