search

datafuselabs / databend-jdbc

jdbc implementation for databend cloud
Apache License 2.0
10 stars 9 forks source link

optimize error output #231

Closed hantmac closed 1 month ago

hantmac commented 2 months ago

Now the error output is :

 Error executing query: SQL: insert into ccw_test.rain 
select * from databend_zf.rain limit 1000 Query failed: Optional[{"id":"56c863f5-65b3-4eb5-8129-1ab00396d8fa","session_id":"91e98d25-a783-4806-a989-9cb6c5dbfbf4","node_id":"KSyzcl22crFgi9g9excTp3","state":"Failed","session":{"database":"ccw_test","role":"public","settings":{},"txn_state":"AutoCommit","last_server_info":{"id":"KSyzcl22crFgi9g9excTp3","start_time":"2024-06-27T15:14:02.302+08:00"},"last_query_ids":["56c863f5-65b3-4eb5-8129-1ab00396d8fa"]},"error":{"code":1006,"message":"Fields in select statement is not equal with expected, select fields: 3, insert fields: 4","detail":""},"warnings":[],"has_result_set":false,"schema":[],"data":[],"affect":null,"stats":{"scan_progress":{"rows":0,"bytes":0},"write_progress":{"rows":0,"bytes":0},"result_progress":{"rows":0,"bytes":0},"total_scan":{"rows":2000,"bytes":30569},"running_time_ms":39},"stats_uri":"/v1/query/56c863f5-65b3-4eb5-8129-1ab00396d8fa","final_uri":"/v1/query/56c863f5-65b3-4eb5-8129-1ab00396d8fa/final","next_uri":"/v1/query/56c863f5-65b3-4eb5-8129-1ab00396d8fa/final","kill_uri":"/v1/query/56c863f5-65b3-4eb5-8129-1ab00396d8fa/kill"}] cause: null

maybe so complicated to read.

So we only need the code,message,detail field, like:

  {"code":1006,"message":"Fields in select statement is not equal with expected, select fields: 3, insert fields: 4","detail":""}