mysql bigint field inserto to es , find error data about elasticsearch-jdbc HOT 3 OPEN

find a way ，
can change SQL to below when use elasticsearch-jdbc tool index data to elasticsearch from mysql , don't change mysql table structure ！

elasticsearch-jdbc-2.3.3.1/bin/mysql-xxx.sh:

"statement": "select convert(bignum,CHAR) as bignum from xxx where xxxxx";

change to string type index to es

from elasticsearch-jdbc.

The fact is that database and JDBC know about big integer, Java knows big integer, but ES does not (and Javascript/JSON is silent about this).
JDBC importer tries to convert to JSON numbers by using Java, and ES tries again to index a numeric value from the JSON number.
JDBC importer tries by default to downgrade to numeric values to retain numbers. JDBC importer uses scale and precision defaults, they can be changed, but result must fit into Java double.
If you index strings, all numeric properties are lost.

from elasticsearch-jdbc.

@jprante thx, if i index long type, -8629845578222121431 will change to -8629845578222121000 , but correct data is -8629845578222121431，the -8629845578222121000 is an error data. so too long type number can only change index Strings.
you have good idea ?

from elasticsearch-jdbc.