中文表名
中文字段
从mysql同步至starrocks
抛出异常
Caused by: com.starrocks.connector.flink.manager.StarRocksStreamLoadFailedException: Failed to flush data to StarRocks, Error response:
{“Status”:“Fail”,“BeginTxnTimeMs”:1,“Message”:“Getting syntax error at line 1, column 12. Detail message: Unexpected input ‘-’, the most similar input is {a legal identifier}.”,“NumberUnselectedRows”:0,“CommitAndPublishTimeMs”:0,“Label”:“d7bea6ad-6933-485c-a163-59906668f946”,“LoadBytes”:0,“StreamLoadPlanTimeMs”:1,“NumberTotalRows”:0,“WriteDataTimeMs”:0,“TxnId”:72113,“LoadTimeMs”:0,“ReadDataTimeMs”:0,“NumberLoadedRows”:0,“NumberFilteredRows”:0}
使用chunjun在同步
{
“job”: {
“content”: [
{
“reader”: {
“name”: “mysqlreader”,
“parameter”: {
“username”: “root”,
“password”: “wywanyiwy”,
“connection”: [
{
“table”: [
“wytest”
],
“jdbcUrl”: [
“jdbc:mysql://127.0.0.1:3306/test?useSSL=false”
]
}
],
“column”: [
{
“name”: “id”,
“type”: “INT”,
“key”: “id”
},
{
“name”: “中文”,
“type”: “STRING”,
“key”: “中文”
},
{
“name”: “password”,
“type”: “STRING”,
“key”: “password”
}
]
}
},
“writer”: {
“name”: “starrockswriter”,
“parameter”: {
“username”: “root”,
“password”: “ssc@hainan”,
“loadUrl”: “10.0.31.107:8030”,
“connection”: [
{
“jdbcUrl”: “jdbc:mysql://10.0.31.107:9030/test?allowLoadLocalInfile=false&autoDeserialize=false&allowLocalInfile=false&allowUrlInLocalInfile=false”,
“table”: [
“wytest”
],
“schema”: “test”
}
],
“writeMode”: “overwrite”,
“column”: [
{
“name”: “id”,
“type”: “INT”,
“key”: “id”
},
{
“name”: “中文”,
“type”: “STRING”,
“key”: “中文”
},
{
“name”: “password”,
“type”: “STRING”,
“key”: “password”
}
],
“batchSize”: 1024
}
}
}
],
“setting”: {
“speed”: {
“bytes”: 0,
“channel”: 1
},
“errorLimit”: {
“record”: 1
}
}
}
}
中文字段加上 任务可以跑成功，但数据没有进来，去掉就抛出异常Caused by: com.starrocks.connector.flink.manager.StarRocksStreamLoadFailedException: Failed to flush data to StarRocks, Error response:
{“Status”:“Fail”,“BeginTxnTimeMs”:2,“Message”:“Getting syntax error at line 1, column 12. Detail message: Unexpected input ‘-’, the most similar input is {a legal identifier}.”,“NumberUnselectedRows”:0,“CommitAndPublishTimeMs”:0,“Label”:“ff3cb30b-3cda-4901-a169-f94ff196abb8”,“LoadBytes”:0,“StreamLoadPlanTimeMs”:3,“NumberTotalRows”:0,“WriteDataTimeMs”:0,“TxnId”:72121,“LoadTimeMs”:0,“ReadDataTimeMs”:0,“NumberLoadedRows”:0,“NumberFilteredRows”:0}