MohammadrezaPourreza / Few-shot-NL2SQL-with-prompting

MIT License
318 stars 65 forks source link

运行后一直卡着不动 #14

Open ShiXiangXiang123 opened 1 year ago

ShiXiangXiang123 commented 1 year ago

image

ShiXiangXiang123 commented 1 year ago

光标也不能点 就这么一直卡着 没有任何提示

yyq commented 1 year ago

you can try debug your code with some IDE

sabersama commented 1 year ago

作者的代码里如果有异常不会报错,而是time.sleep(3),如果一致有错就会死循环,建议自己加点日志然后改对应的问题 image

WaleedChughtai30 commented 1 year ago

You have to make shorten the prompts of "schema_linkng_prompt","classification_prompt","easy_prompt","medium_prompt" and "hard_prompt" as GPT models like 3.5 (I guess you were using that as I was using that and found out that) takes shorter prompt.

"你需要搞短 'schema_linkng_prompt'、'classification_prompt'、'easy_prompt'、'medium_prompt' 和 'hard_prompt' 的prompt,因为像 GPT 模型 3.5 一样(我猜你在使用它,因为我也在使用它,发现需要更短的prompt)需要更短prompt"

WWWWWWLLLL commented 1 year ago

image

想问一下这个问题解决了吗?

ShiXiangXiang123 commented 1 year ago

解决了,是因为字符过多,gpt3.5只支持有限的字符提示,你删除一点prompt就行了。或者换成gpt4

------------------ 原始邮件 ------------------ 发件人: "MohammadrezaPourreza/Few-shot-NL2SQL-with-prompting" @.>; 发送时间: 2023年10月12日(星期四) 晚上6:41 @.>; 抄送: "淡写 @.**@.>; 主题: Re: [MohammadrezaPourreza/Few-shot-NL2SQL-with-prompting] 运行后一直卡着不动 (Issue #14)

想问一下这个问题解决了吗?

— Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.Message ID: @.***>

WWWWWWLLLL commented 1 year ago

只需要把模型改成3.5,然后删除prompt就行了吗?我都删的剩一两个了,还是不行

------------------ 原始邮件 ------------------ 发件人: "MohammadrezaPourreza/Few-shot-NL2SQL-with-prompting" @.>; 发送时间: 2023年10月12日(星期四) 晚上7:13 @.>; @.**@.>; 主题: Re: [MohammadrezaPourreza/Few-shot-NL2SQL-with-prompting] 运行后一直卡着不动 (Issue #14)

解决了,是因为字符过多,gpt3.5只支持有限的字符提示,你删除一点prompt就行了。或者换成gpt4

------------------ 原始邮件 ------------------ 发件人: "MohammadrezaPourreza/Few-shot-NL2SQL-with-prompting" @.>; 发送时间: 2023年10月12日(星期四) 晚上6:41 @.>; 抄送: "淡写 @.**@.>; 主题: Re: [MohammadrezaPourreza/Few-shot-NL2SQL-with-prompting] 运行后一直卡着不动 (Issue #14)

想问一下这个问题解决了吗?

— Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.Message ID: @.> — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you commented.Message ID: @.>

ShiXiangXiang123 commented 1 year ago

是的,你需要删除一部分,不是所有,你截图给我看吧!!!

------------------ 原始邮件 ------------------ 发件人: "MohammadrezaPourreza/Few-shot-NL2SQL-with-prompting" @.>; 发送时间: 2023年10月12日(星期四) 晚上7:16 @.>; 抄送: "淡写 @.**@.>; 主题: Re: [MohammadrezaPourreza/Few-shot-NL2SQL-with-prompting] 运行后一直卡着不动 (Issue #14)

只需要把模型改成3.5,然后删除prompt就行了吗?我都删的剩一两个了,还是不行

------------------ 原始邮件 ------------------ 发件人: "MohammadrezaPourreza/Few-shot-NL2SQL-with-prompting" @.>; 发送时间: 2023年10月12日(星期四) 晚上7:13 @.>; @.**@.>; 主题: Re: [MohammadrezaPourreza/Few-shot-NL2SQL-with-prompting] 运行后一直卡着不动 (Issue #14)

解决了,是因为字符过多,gpt3.5只支持有限的字符提示,你删除一点prompt就行了。或者换成gpt4

------------------ 原始邮件 ------------------
发件人: "MohammadrezaPourreza/Few-shot-NL2SQL-with-prompting" @.>;
发送时间: 2023年10月12日(星期四) 晚上6:41
@.>;
抄送: "淡写 @.**@.>;
主题: Re: [MohammadrezaPourreza/Few-shot-NL2SQL-with-prompting] 运行后一直卡着不动 (Issue #14)

想问一下这个问题解决了吗?


Reply to this email directly, view it on GitHub, or unsubscribe.
You are receiving this because you authored the thread.Message ID: @.>
— Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you commented.Message ID:
@.> — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.Message ID: @.***>

ShiXiangXiang123 commented 1 year ago

拿去吧 ------------------ 原始邮件 ------------------ 发件人: "MohammadrezaPourreza/Few-shot-NL2SQL-with-prompting" @.>; 发送时间: 2023年10月12日(星期四) 晚上7:16 @.>; 抄送: "淡写 @.**@.>; 主题: Re: [MohammadrezaPourreza/Few-shot-NL2SQL-with-prompting] 运行后一直卡着不动 (Issue #14)

只需要把模型改成3.5,然后删除prompt就行了吗?我都删的剩一两个了,还是不行

------------------ 原始邮件 ------------------ 发件人: "MohammadrezaPourreza/Few-shot-NL2SQL-with-prompting" @.>; 发送时间: 2023年10月12日(星期四) 晚上7:13 @.>; @.**@.>; 主题: Re: [MohammadrezaPourreza/Few-shot-NL2SQL-with-prompting] 运行后一直卡着不动 (Issue #14)

解决了,是因为字符过多,gpt3.5只支持有限的字符提示,你删除一点prompt就行了。或者换成gpt4

------------------ 原始邮件 ------------------
发件人: "MohammadrezaPourreza/Few-shot-NL2SQL-with-prompting" @.>;
发送时间: 2023年10月12日(星期四) 晚上6:41
@.>;
抄送: "淡写 @.**@.>;
主题: Re: [MohammadrezaPourreza/Few-shot-NL2SQL-with-prompting] 运行后一直卡着不动 (Issue #14)

想问一下这个问题解决了吗?


Reply to this email directly, view it on GitHub, or unsubscribe.
You are receiving this because you authored the thread.Message ID: @.>
— Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you commented.Message ID:
@.> — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.Message ID: @.***>