Logstash-input-jdbc handle geo shape for mysql geometry field

when i use logstash-input-jdbc to transform data from mysql to es,i find a problem which seems like can not convert ASCII-8bit to UTF-8;this is not plugin'bug ;because mysql use a different format to encode geometry. when you transform data directly,if failed ,you should use mysql function to handle geometry field before you transform those data from mysql to es through by logstash-input-jdbc!

detail explanation:
please refer to https://dev.mysql.com/doc/refman/5.7/en/gis-format-conversion-functions.html;
because mysql use internal geometry format to store geometry field;use should use ST_AsText () function to handle geometry field when transform data from mysql to logstash-input-jdbc

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.