Phoenix批量导数错误: java.sql.SQLException: ERROR 201 (22000): Illegal data.

错误详情:

Error: java.lang.RuntimeException: org.apache.phoenix.schema.IllegalDataException: java.sql.SQLException: ERROR 201 (22000): Illegal data.

Caused by: java.sql.SQLException: ERROR 201 (22000): Illegal data.

Caused by: java.lang.NumberFormatException: For input string: "2168573950"

 

错误原因:

     这是数据类型错误, 2168573950 所对应的字段我给的是 integer类型, 很明显不够用, 将其改为 bigint 即可