zhangjianleittntty opened a new issue, #22869:
URL: https://github.com/apache/shardingsphere/issues/22869
1.The shardingsphere-proxy application was started.
2.Mysql was connection to shardingsphere-proxy.
3.SQL: Insert and Update its went to processor sharding operation.
4.Question: The data transfer is from old table to multi-tables. The DistSQL
exection is error.
**(1)**>mysql> ADD RESOURCE resource_1 (
->
URL=jdbc:mysql://127.0.0.1:3310/orderweek_0?serverTimezone=UTC&useSSL=false,
-> USER=root,
-> PASSWORD=12345678,
-> PROPERTIES(maximumPoolSize=10,idleTimeout=30000));
**Result:**
> You have an error in your SQL syntax: ADD RESOURCE
resource_1..........
**(2)**mysql> REGISTER STORAGE UNIT ds_2 (
->
URL="jdbc:mysql://127.0.0.1:3310/orderweek_0?serverTimezone=UTC&useSSL=false",
-> USER="root",
-> PASSWORD="12345678",
->
PROPERTIES("minPoolSize"="1","maxPoolSize"="20","idleTimeout"="60000")
-> );
**Result:**
>You have an error in your SQL syntax: REGISTER STORAGE UNIT
ds_2..........
**(3)**mysql> MIGRATE TABLE ds_2.order_info INTO order_info;
**Result:**
>ERROR 30000 (HY000): Unknown exception: null
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail:
[email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
