Hi Avenka, you asked for a HowTo to add a field "inverseID" which allows to calculate max(id) from its first term: If you do not use solr you have to calculate "100000000 - id" and store it in an extra field "inverseID". If you fill solr with your own code, add a TrieLongField "inverseID" and fill with the value "-id". If you only want to change schema.xml (and add some classes): * You need a new FieldType "inverseLongType" and a Field "inverseID" of Type "inverseLongType" * You need a line <copyField source="id" dest="inverseID"/> (see http://wiki.apache.org/solr/SchemaXml#Copy_Fields)
For inverseLongType I see two possibilities a) use TextField and make your own filter to calculate "100000000 - id" b) extends TrieLongField to a new FieldType "InverseTrieLongField" with: @Override public String readableToIndexed(String val) { return super.readableToIndexed(Long.toString( -Long.parseLong(val))); } @Override public Fieldable createField(SchemaField field, String externalVal, float boost) { return super.createField(field,Long.toString( -Long.parseLong(val)), boost ); } @Override public Object toObject(Fieldable f) { Object result = super.toObject(f); if(result instanceof Long){ return new Long( -((Long)result).longValue()); } return result; } Beste regards Karsten View this message in context: http://lucene.472066.n3.nabble.com/DataImport-using-last-indexed-id-or-getting-max-id-quickly-tp3993763p3994560.html -------- Original-Nachricht -------- > Datum: Wed, 11 Jul 2012 20:59:10 -0700 (PDT) > Von: avenka <ave...@gmail.com> > An: solr-user@lucene.apache.org > Betreff: Re: DataImport using last_indexed_id or getting max(id) quickly > Thanks. Can you explain more the first TermsComponent option to obtain > max(id)? Do I have to modify schema.xml to add a new field? How exactly do > I > query for the lowest value of "100000000 - id"? > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/DataImport-using-last-indexed-id-or-getting-max-id-quickly-tp3993763p3994560.html > Sent from the Solr - User mailing list archive at Nabble.com.