inlong icon indicating copy to clipboard operation
inlong copied to clipboard

[Bug][Sort] Doris single table columns keyword backticking

Open Yizhou-Yang opened this issue 2 years ago • 1 comments

What happened

Current doris single table connector does not backtick columns properly, so if it has a column that is keyword (desc,select,insert, etc...), there will be error.

see error like this: 2023-08-15 17:50:36.265 [doris-streamload-output-format-thread-1] INFO org.apache.doris.flink.table.DorisStreamLoad [] - Streamload Response:{"status":200,"respMsg":"OK","respContent":"{\n "TxnId": 9157,\n "Label": "xxx",\n "TwoPhaseCommit": "false",\n "Status": "Fail",\n "Message": "[ANALYSIS_ERROR]errCode = 2, detailMessage = Syntax error in line 1:\n...llerType,orderDate,status,desc,empId,updateDate,haveGr...\n ^\nEncountered: DESC\nExpected: DESC is keyword, maybe DESC\n",\n "NumberTotalRows": 0,\n "NumberLoadedRows": 0,\n "NumberFilteredRows": 0,\n "NumberUnselectedRows": 0,\n "LoadBytes": 0,\n "LoadTimeMs": 0,\n "BeginTxnTimeMs": 0,\n "StreamLoadPutTimeMs": 2,\n "ReadDataTimeMs": 0,\n "WriteDataTimeMs": 0,\n "CommitAndPublishTimeMs": 0\n}\n"}

What you expected to happen

backtick columns correctly.

How to reproduce

this only occurs in doris single table scenerios

Environment

No response

InLong version

master

InLong Component

InLong Sort

Are you willing to submit PR?

  • [X] Yes, I am willing to submit a PR!

Code of Conduct

Yizhou-Yang avatar Sep 14 '23 09:09 Yizhou-Yang

This issue is stale because it has been open for 60 days with no activity.

github-actions[bot] avatar Nov 14 '23 01:11 github-actions[bot]