What is the best data type to store GEOMETRY data type in MemSQL?
As far as I know, MemSQL supports GEOGRAPHY data type.
But, GEOMETRY data type supports flat, or Euclidean (flat surface) data. and, the GEOGRAPHY data type stores elliptic (round surface) data such as GPS latitude and longitude coordinates.
If I store GEOMETRY type’s data in GEOGRAPHY data type, I think the calculation(such as distance) will be wrong. Please guide us which is the best DATA TYPE to store GEOMETRY data type.