Comments (3)
Hi @vincentlux
This might happen due to instability of DBEngine class which activates except
in following code.
sqlova/sqlova/utils/utils_wikisql.py
Lines 1646 to 1670 in 7a8636d
DBEngine class is modified from SQLNet code which is based on original WikiSQL evaluation code (I guess).
I'll check whether this still happens when DBEngine from WikiSQL evaluation code is employed.
Thanks!
Wonseok
from sqlova.
Hi Wonseok,
Thanks for the quick response! This is interesting and I will also check with using the option you suggested. Thanks!
from sqlova.
@vincentlux I found the problem. It is caused by the wrong ordering of predicted where-column.
For example, when the ground truth is
{'sel': 1, 'conds': [[6, 0, 'at&t center 18,797'], [0, 2, 57]], 'agg': 0}
the previous prediction in train
function could be
{'agg': 0, 'sel': 1, 'conds': [[0, 0, 'at&t center 18,797'], [6, 2, '57']]}
Hence, the execution accuracy of the model over train-set returned from the train
function has been under-estimated.
During the test, there is no problem as this issue is caused by the use of ground-truth during the training which makes the debugging difficult.
I have updated the code. Please let me know if the problem still happens.
Wonseok
from sqlova.
Related Issues (20)
- 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
- Question about the human eval result, thank you. HOT 2
- No module named 'matplotlib' after I download matplotlib
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.