0

I have a MySQL table whose data I have to export to .csv and then ingest this .csv to GeoMesa.

My Mysql table structure is like below:

[MySQL table description[1]

Now, as you can see the the_geom attribute of table has data type point and in database it is stored as blob like shown below:

MySQL sample data

Now I have two problems :

  1. When I export the MySQL data into a (.csv) file my csv file shows (...) for the_geom attribute as shown below instead of any binary representation or anything which will allow it to be ingested in GeoMesa. So, how to overcome this?

the_geom attribute of MySQL table

  1. Csv file also shows # for any attribute with datetime datatype but if you expand the column the date time can be seen as sown in below picture (however my question is does it will cause problem in geomesa?).

Attribute with datetime datatype shown as # because of column width

Cœur
  • 37,241
  • 25
  • 195
  • 267
Arjun Chaudhary
  • 2,373
  • 2
  • 19
  • 36

1 Answers1

0

For #1, MySQL's export is not automatically converting the Point datatype into text for you. You might need to call a conversion function such as AsWKT to output the geometry as Well Known Text. The WKT format can be used by GeoMesa to read in the Point data.

For #2, I think you'll need to do the same for the date field. Check out the date and time functions.

GeoJim
  • 1,320
  • 7
  • 12