[Bug] Chat Data hive ERROR!(pyhive.exc.OperationalError)...cannot recognize input near "2024-10-11"','

[Sloane9511]

Search before asking

• I had searched in the issues and found no similar issues.

Operating system information

Linux

Python version information

3.10

DB-GPT version

latest release

Related scenes

• Chat Data
• Chat Excel
• Chat DB
• Chat Knowledge
• Model Management
• Dashboard
• Plugins

Installation Information

• Installation From Source

• Docker Installation

• Docker Compose Installation

• Cluster Installation

• AutoDL Image

• Other

Device information

GPU:1
GPU Memorry:24G

Models information

LLM:CHATGLM4_9B
embedding model:M3E

What happened

Chat Data用hive数据库对话报错但生成的sql查询语句是正确的：

What you expected to happen

可正常与数据库交互

How to reproduce

1、docker-compose部署
2、新建hive数据库连接，但连接会报错Password should be set if and only if in LDAP or CUSTOM mode
3、修改conn_hive.py如下图，添加auth="custom":

4、hive数据库连接创建成功
5、chat data与Hive数据库对话，报错但生成的sql查询语句是正确的：

Additional context

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!