eguilg / nl2sql Goto Github PK
View Code? Open in Web Editor NEW阿里天池首届中文NL2SQL挑战赛top6
Home Page: https://tianchi.aliyun.com/competition/entrance/231716/introduction
License: BSD 3-Clause "New" or "Revised" License
阿里天池首届中文NL2SQL挑战赛top6
Home Page: https://tianchi.aliyun.com/competition/entrance/231716/introduction
License: BSD 3-Clause "New" or "Revised" License
你好,我也是因为最近才看到这个比赛,比赛结束后就没办法获取数据集了,能发一份数据集嘛~
邮箱:[email protected]~~万分感谢~
你好,可以提供一下答辩ppt吗?有些原理还没看懂,谢谢
您好,我们公司现在与华中科技大学进行产学研合作,同时对NL2SLQ有研究意向,我们想与你们团队进行相关交流,是否方便提供相关联系方式,我们会让相关负责的在校老师联系您,或者可以通过邮箱联系我们([email protected])
跑出的结果比较差,
想问一下作者的比赛成绩是只用了这一个模型么?模型的参数和脚本里的相同么?
The datasets is that the table corresponding to question is given.
But in real industrial application, we have 100+ tables for 1 new question.
Thank you!
真正落地的时候,给一个问题,会有100多张表候选,要先定位到表,才能生成SQL,这个有什么方法定位到表?
修改了三处地方:
1、model\chinese-bert_chinese_wwm_pytorch\config.json, 其中vocab_size的值改为 30522
2、code\sqlnet\model\sqlbert.py,大约141行附近,增加三行:sel_col_mask = sel_col_mask - 254;where_col_mask = where_col_mask - 254;qcol_mask = qcol_mask - 254,程序才能跑起来
3、log日志的位置。code\sqlnet.utils.py文件,950行附近,save_error_case(error_case, gt_cases, dir='./log/')改为save_error_case(error_case, gt_cases, dir='../log/')
最终结果:
Train loss = 2.019
Dev Logic Form Accuracy: 0.732, Execution Accuracy: 0.747
Best Logic Form: 0.732 at epoch 29
Best Execution: 0.747 at epoch 29
Best Mean: 0.740 at epoch 29
Best val acc: (0.9993093922651933, 0.9882596685082873, 0.9861878453038674, 0.975828729281768, 0.9509668508287292, 0.9544198895027625, 0.8031767955801105)
On epoch individually (28, 28, 29, 20, 24, 28, 29)
好像没有预期的高啊
请问能够推断出结果么,就是得到sql查询后的结果
您好,请问您有数据集吗,错过了比赛,想自己先研究一下,麻烦还能共享下数据吗?非常非常感谢!如果可以麻烦请发到邮箱[email protected]。已经star,希望麻烦您给发一份数据
楼主 看了下代码好像用的集成模型 但好像只有bert的训练代码 还有final_test.josn文件是啥
方便分享答辩ppt吗?想学习一下实现原理,非常感谢 邮箱是[email protected]
能否提供一下数据集吗?非常感谢。我也正在做这方面的学习,问题就是没有中文数据集
能否提供相关数据集
您好,现在这个比赛已经结束,不能在官网上获得数据了。不知道大神能否提供一个数据下载链接,😄,万分感谢!
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.