Comments (5)
这个问题在之前类似的issue中有回答过。以下是原答案:
To train RESDSQL on your dataset, you have to prepare at least three files (Take Spider's file as an example):
database
, a folder where the sqlite databases are saved.train_spider.json
, a json file that contains pairs of training data, each of them should contain three fields:db_id
,query
, andquestion
.tables.json
, a json file that describes the schema of all databases.
To run inference and evaluation, you should prepare a separate dev_gold.sql
file containing the gold SQL query and its corresponding db_id.
Originally posted by @lihaoyang-ruc in #45 (comment)
from resdsql.
好的谢谢,那如果不需要从database执行SQL,只是需要生成SQL的话还需要database吗?除此之外只需要生成SQL还需要哪些调整呢?
from resdsql.
目前是需要的,因为我依赖database来采样生成没有语法错误的SQL,你可以在sqlite中创建空数据库,不插入任何数据,只当作语法检查器使用。又或者你可以自己实现一个语法检查器,替代掉去database中执行的步骤。
from resdsql.
好的,十分感谢,database执行步骤具体是在哪个文件呢?我看一下如何自己实现检查器替代?
from resdsql.
utils/text2sql_decoding_utils.py文件的results = execute_sql(cursor, pred_sql)
行。
from resdsql.
Related Issues (20)
- Execuse me. What happened to paper CodeS? Isn't this article open source before? HOT 9
- Low training metrics HOT 14
- Support for Historical Conversation in RESDSQL HOT 4
- Question about evaluation scripts HOT 2
- 请问推理方法 HOT 2
- 最低支持的GPU内存是多少,我怎么跑不起来。
- Dev result file?
- 部分带有别名的sql在经过normalization处理后出现错误 HOT 2
- Inference script not working HOT 5
- CoSQL HOT 1
- 训练Cross-Encoder的时候为什么24G的显存还不够用? HOT 1
- 关于RESDSQL在BIRD上的运行时间 HOT 2
- Training cross-coder error HOT 1
- xlm_roberta_text2natsql_schema_item_classifier HOT 3
- Evaluation detail on CSpider HOT 1
- 你好,请问如何将自己的数据集处理成CSpider的形式? HOT 3
- 你好,请问如何SQL2NatSQL?我想用自己的数据集跑text2NatSQL的方法。 HOT 2
- 请问模型训练有多gpu并行支持吗 HOT 1
- Can the ranking-filter successfully choose all the right schema items? HOT 1
- 为什么我使用对bird训练的classifier时出现了truncated_dataset.json文件,而且陷入了循环无法结束运行 HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from resdsql.