Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Enhancement] 字段转换的时候能否兼容大模型解析s2sql时间格式不满足要求的情况 #1401

Open
2 of 3 tasks
wangwz587 opened this issue Jul 11, 2024 · 1 comment
Open
2 of 3 tasks

[Enhancement] 字段转换的时候能否兼容大模型解析s2sql时间格式不满足要求的情况 #1401

wangwz587 opened this issue Jul 11, 2024 · 1 comment
Assignees
@jerryjzhang
Labels
enhancement New feature or request

Comments

@wangwz587
Copy link

Search before asking

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

Description

大模型输出的sql不稳定，时间条件不满足prompt中的要求下，字段名称修正的时候能否兼容这类问题？
如将下述的“年份=2018”修正为“YEAR (数据日期)”？
image
image
image
补充，本例对接的大模型是qwen1.5 32B

Solution

“年份”修正为“YEAR (数据日期)”
“月份”修正为“MONTH (数据日期)”
“日”修正为“DAY (数据日期)”

Are you willing to submit PR?

  • Yes I am willing to submit a PR!

Code of Conduct
@wangwz587 wangwz587 added the enhancement New feature or request label Jul 11, 2024
@jerryjzhang
Copy link
Collaborator

这个会比较tricky，也不太清楚大模型会幻觉成“年份”、“年”等术语表达。是不是可以先尝试修改prompt，给一些更明确的指令说明。在下个版本会支持在助理层面配置自定义prompt

@jerryjzhang jerryjzhang self-assigned this Jul 20, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@jerryjzhang jerryjzhang

Labels
enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@jerryjzhang @wangwz587