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 JDBC code may be hunting for "id" as a return from the query instead of just accepting a return with an unnamed value? On Thu, Jun 18, 2009 at 6:35 AM, Erik Hatcher <e...@ehatchersolutions.com>wrote: > > 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 (id field) value. > > What about having the results of the deletedPkQuery run through the same > transformation process that indexing would, only for the field that matches > Solr's uniqueKey setting would be necessary?? > > Erik > > -- Lance Norskog goks...@gmail.com 650-922-8831 (US)