Comments (3)
Hi @farsmile
To predict SQL from the plane text, you need to tokenize questions first by using StandforeCoreNLP, for example, by using following function.
Lines 18 to 34 in b7ce9ad
After that, to generate SQL, the ground truth is not required. It is used in test
function only to calculate loss and accuracies of dev set
or test set
. See below.
Lines 432 to 441 in b7ce9ad
Thanks.
Wonseok
from sqlova.
Hi Wonseok:
it works again.
so much thanks!
from sqlova.
您好Wonseok:
感谢您在这里的漂亮工作,问题如下:
https://github.com/naver/sqlova/blob/master/train.py#L406
g_wvi_corenlp = get_g_wvi_corenlp(t)
这是在开发中使用“conds”,如果想要的话从英语的计划句中预测,他找不到像“{”conds“:[[0,0,”1998“]],”sel“:1,”agg“:0}这样的方法。 。以下url告诉SQLnet xiaojunxu / SQLNet#12上的类似问题
have i miss something or do you have a similar snippet of codes.
非常感谢
Hi Wonseok:
thanks for your pretty work here and the issue is as following:
https://github.com/naver/sqlova/blob/master/train.py#L406
g_wvi_corenlp = get_g_wvi_corenlp(t)
this is using the "conds" in dev and if one want to predict from a plan sentence of english, he would not find the way to get something like "{"conds":[[0,0,"1998"]], "sel":1, "agg":0}".the following url tells a similar problem on SQLnet
xiaojunxu/SQLNet#12have i miss something or do you have a similar snippet of codes.
thank a lot
same question, How did you change it?
from sqlova.
Related Issues (20)
- Typos in ReadMe.md
- How can I have a look at the ftable1.csv and ftable2.csv
- For real industrial application, what strategy to locate the exact table? HOT 1
- How to fine tune sequence-to-SQL?
- How do I use predict.py for custom data? HOT 2
- weird error occurs when run predict.py
- Testing models with predict.py does not give me any results file HOT 1
- Need of results_train.jsonl
- Standford coreNLP
- Training on custom data HOT 4
- Replicating dev results on BERT base
- Training doesn't run + how to predict with custom query? HOT 1
- Keras implementation of Column Attention
- Error with annotate_ws.py HOT 7
- Isuue in utlis.wikisql.py
- TypeError: 'Document' object is not iterable
- There is insufficient memory during training, and the get_wemb_bert function call in the train function applies for a lot of memory
- dbengine HOT 5
- How to use RoBERTa instead of BERT ?
- How can I evaluate the pre-trained model on WikiSQL? 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 sqlova.