Also 10481.5711458735456*79* indexes to 10481.571145873546 using double <fieldType name="double" class="solr.TrieDoubleField" precisionStep="0" positionIncrementGap="0" omitNorms="false"/>
On Tue, May 19, 2015 at 2:57 PM, Vishal Swaroop <vishal....@gmail.com> wrote: > Thanks Erick... I can ignore the trailing zeros > > I am indexing data from Vertica database... Though *double *is very close > but it SOLR indexes 14 digits after decimal > e.g. actual db value is 15 digits after decimal i.e. 249.81735425382405*2* > > SOLR indexes 14 digits after decimal i.e. 249.81735425382405 > > As these values will be used for big data analysis, so I am wondering if > it might impact the result. > <fieldType name="double" class="solr.TrieDoubleField" precisionStep="0" > positionIncrementGap="0" omitNorms="false"/> > > Any suggestions ? > > Regards > > > On Tue, May 19, 2015 at 1:41 PM, Erick Erickson <erickerick...@gmail.com> > wrote: > >> Why do you want to keep trailing zeros? The original input is >> preserved in the "stored" portion and will be returned if you specify >> the field in your "fl" list. I'm assuming here that you're looking at >> the actual indexed terms, and don't really understand why the trailing >> zeros are important >> >> Do not use strings. >> >> Best >> Erick >> >> On Tue, May 19, 2015 at 10:22 AM, Vishal Swaroop <vishal....@gmail.com> >> wrote: >> > Thank you John and Jack... >> > >> > Looks like double is much closer... it removes trailing zeros... >> > a) Is there a way to keep trailing zeros >> > double : 194.846189733028000 indexes to 194.846189733028 >> > <fieldType name="double" class="solr.TrieDoubleField" precisionStep="0" >> > positionIncrementGap="0" omitNorms="false"/> >> > >> > b) If I use "String" then will there be issue doing range query >> > >> > float >> > <fieldType name="float" class="solr.TrieFloatField" precisionStep="0" >> > positionIncrementGap="0" omitNorms="false"/> >> > 277.677836785372000 indexes to 277.67783 >> > >> > >> > >> > On Tue, May 19, 2015 at 11:56 AM, Jack Krupansky < >> jack.krupan...@gmail.com> >> > wrote: >> > >> >> "double" (solr.TrieDoubleField) gives more precision >> >> >> >> See: >> >> >> >> >> https://lucene.apache.org/solr/5_1_0/solr-core/org/apache/solr/schema/TrieDoubleField.html >> >> >> >> -- Jack Krupansky >> >> >> >> On Tue, May 19, 2015 at 11:27 AM, Vishal Swaroop <vishal....@gmail.com >> > >> >> wrote: >> >> >> >> > Please suggest which numeric field type to use so that I can get >> complete >> >> > value. >> >> > >> >> > e.g value in database is : 194.846189733028000 >> >> > >> >> > If I index it as float SOLR indexes it as 194.84619 where as I need >> >> > complete value i.e 194.846189733028000 >> >> > I will also be doing range query on this field. >> >> > >> >> > <fieldType name="float" class="solr.TrieFloatField" precisionStep="0" >> >> > positionIncrementGap="0"/> >> >> > >> >> > <field name="value" type="float" indexed="true" stored="true" >> >> > multiValued="false" /> >> >> > >> >> > Regards >> >> > >> >> >> > >