Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [geomesa-users] Adaption RowId, Spatial Bin Level

Marcel,

Note:  The following discussion, while somewhat interesting, is also
deprecated:  The index-schema format described here was specific to the
"_st_idx" table that is being replaced by the "_z3" table and index
structure that we have found often out-performs the older index.

Deprecated "_st_idx" index-schema format...  Table III's "spatial bins"
column refers to the number of (base-32-encoded) Geohash characters that
appear in the RowID.  Our experience was, generally, that the best
performance occurred when the specificity of the RowID was appropriate
for the granularity of data being indexed.  That is to say, if you have
global data that is nearly uniformly distributed, a single (5-bit,
base-32) Geohash character in the RowID may be appropriate; but for data
concerning a single metropolitan area, 3-4 Geohash characters in the
RowID might provide for better differentiation among rows.  This setting
was controlled by what we called the "index-schema format", and while
there is a setting to do this, it is not widely publicized.  (You have
to set a user-data value for the "geomesa.index.st.schema" key within
the simple-feature type when the schema is first registered in GeoMesa.)

I hope this helps to address your interest.  If you have additional
questions, please continue to share them.

Thanks!

Sincerely,
  -- Chris


On Mon, 2015-09-14 at 14:22 +0200, Marcel wrote:
> Hello all,
> I have found in your paper on page 7 (Table III) that increasing the 
> number of spatial bin level (maybe from 1 to 2) can have a positive 
> effect on query response times. Can you tell me, where I can set this 
> adaption of the rowId for my mapreduce job? Would you recommend a 
> spatial bin level of 2 or even higher?
> 
> Thanks,
> Marcel Jacob.
> _______________________________________________
> geomesa-users mailing list
> geomesa-users@xxxxxxxxxxxxxxxx
> To change your delivery options, retrieve your password, or unsubscribe from this list, visit
> http://www.locationtech.org/mailman/listinfo/geomesa-users




Back to the top